Output Clause:- The SQL SERVER 2005 gives us an Output Clause which gives us the information about each row affected by the
SQL Server- Output clause
Continue reading
Month: January 2012
CTE command In Sql Server
Common table expression (CTE):- Common table expression or CTE can be described as the temporary, named record set return by
Share this:
SQL Server-Table Variable
Table variable:- SQL Server provides an variable known as table variable which is used to store data in a similar way as we
Share this:
SQL Server – Local temporary table
Local temporary table:- Local temporary table is created in the tempdb and it is visible to the current user’s session
Share this:
SQL Server – Global temporary tables
Global temporary table:- Global temporary table is created in the tempdb and it is visible to all other sessions as well. Global
Share this:
How to change the database collation
To change the collation of an database following commands can be used: ALTER DATABASE [database name] SET SINGLE_USER WITH ROLLBACK IMMEDIATE ALTER DATABASE [database name] COLLATE Newcollation ALTER DATABASE [database name] SET MULTI_USER For example
Share this:
How to rename a Table in Sql Server
To rename a column in a SQL Table following command can be reused: SP_RENAME ‘old table name’, ‘New table name’
