SQL Server

While developing SQL Scripts we may often come across the requirement of getting last day of a given month. In SQL Server 2008 R2 and it’s prior versions getting last day of any month is not an quick task, you have write a bit of T-SQL script to get it. But with the forthcoming of …

New Function In SQL Server Denali To Get Last Day Of Any Month Read More »

Quite a long ago I wrote about a SQL Server programming tip on how to extract date part from a DATETIME column. The post discusses about using of T SQL function convert() to get date part. One of the readers of the post, tipped me about a better way of extracting date part and here …

A Better Way To Extract Date From DateTime Columns [SQL Server] Read More »

If you want to delete top 100/n records from an SQL Server table, it is very easy with the following query: DELETE FROM MyTable WHERE PK_Column IN(     SELECT TOP 100 PK_Column     FROM MyTable     ORDER BY creation    ) Why Would You Require To Delete Top 100 Records? I often delete a top …

How To Delete Top 100 Rows From SQL Server Tables Read More »

While writing SQL Server queries, often I need to extract date part from DateTime columns/variables and it’s very easy to do that: SELECT convert(varchar,getdate(),101) Bonus: How To Retrieve Time Part Alone From DateTime Field Here is the bonus tip to get the time part alone from DateTime fields SELECT convert(varchar,getdate(),108) Hope this helps you.