Today I would like to check my database and other few table size in online database. For that I have been use the system produce to get the tables and database size.
Published Date : 15/Dec/2010
In my previous tip I have been posted about DATEADD () function. Another function can use for date and time related operation in Sql server called DATENAME (). The DATENAME () returns a character string representing the specified datepart of the specified date.
Published Date : 14/Dec/2010
In this tips will explain to you, two different ways to select month name in sql server.
Published Date : 12/Nov/2010
The identity column gets value assigned automatically when a new records inserted into the table.
Published Date : 18/Jun/2010
Procedure for Split the words in SQL Sever
Published Date : 12/Apr/2010