| RSS
|
Fetch the incremented Identity value from MS-SQL ServerThe Microsoft SQL Server Database provides an Identity value which is generated automatically when a record is added in such tables which contains IDENTITY. We can fetch the auto incremented value from MS-SQL Server database to our applications using built in function @@IDENTITY( ) (used in MS-Access) or SCOPE_IDENTITY( ) which is the recommended method for obtaining identity value on SQL Server. Read More...SQL Server 2005 Common Table ExpressionsA common table expression (CTE) can be thought of as a temporary result set that is defined within the execution scope of a SELECT, INSERT, UPDATE, DELETE, or CREATE VIEW statement. A CTE is similar to a derived table in that it is not stored as an object and lasts only for the duration of the query. Read More...Change sa password for SQL Server ExpressWhile installing Visual Studio 2005, it shows like SQL Server 2005 Express edition also installing but you can’t access it. Actually SQL Server 2005 Express edition will be installed on the pc as an instance but it wont appear in the programs list to access. Read More... |
|
