In this article I am trying to explain how create a user define function using SQL Server 2008 R2.
In this article I am trying to explain how to copy data from one table to another and how to copy data as well as create table in SQL Server 2008 R2.
DELETE, TRUNCATE with RESEED Identity in SQL Server
How to Drop Primary Key Constraint
SQL SERVER – Maximum Number of Index per Table
Date and Time Function in SQL
Select Command in SQL Server
Nested Queries in SQL Server
Change Data Capture (CDC) in SQL Server
How to Backup a Table in SQL Server
How to Backup a SQL Server Database
Upgrade SQL Server 2005 SP3 to SP4