SQL Server- Output clause
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 Read Post »
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
CTE command In Sql Server Read Post »
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
SQL Server-Table Variable Read Post »
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
SQL Server – Local temporary table Read Post »
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
SQL Server – Global temporary tables Read Post »
SQL Basic Concepts, SQL Server
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
How to change the database collation Read Post »
SQL Basic Concepts, SQL Server
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’
How to rename a Table in Sql Server Read Post »
You must be logged in to post a comment.