| 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...Show all tables having identity columnsThe simplest way to display all the tables which are having identity column in a database of SQL server 2000 / 2005 / 2008 using the following simple 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...Configure SQL Server for ASP.Net session stateOnce you start running multiple web servers for the same web site, the default asp.net session state, InProc, is no longer useful, as you cannot guarantee that each page request goes to the same server. It becomes necessary to have a central state store that every web server accesses. Read More...Install and Use PHP & MySql on Windows MachineIts very easy to install and use PHP & MySql on windows Machine using AppServ Package which is freeware to download and use. Read More... |
|
