In this tips, I will explain how to ALTER or ADD two or more columns in to table by t-sql script.
Published Date : 25/Mar/2011
A very important feature of SQL Server 2008 is that we can enable CDC(Change Data capture) on database or table.We can track the database had CDC enabled by querying IS_CDC_ENABLED column
Published Date : 17/Jan/2011
This is the third tips date related function in sql server. In this I going to show you how to use DATEDIFF() function in sql server. The DATEDIFF () is useful to get the specified date part between two dates
Published Date : 16/Dec/2010
The DATEADD function is a powerful built-in function sql server to add dates in different way and types. So I would like to explore in this tip how we can use the DATEADD function for different purpose.
Published Date : 12/Dec/2010
In this tips, i will explain how to select records based on Row number using ROW_NUMBER() function in sql server.
Published Date : 02/Dec/2010