DevSocial Blogs · SQL Server blogs

This Blog give you information about DDL, DML, DCL AND TCL Commands.

Ankit NandekarMay 10, 2011223,944250

In this i will give u query to select only date part from DateTime.

Ankit NandekarMay 10, 20114,957250

Here you will see Important Difference in SQL Server.

Good Utility For SQL Server Database Bauckup and Zipped automaticly. Browse site and download software, its freeware! Absolutely Nice. http://sqlbackupandftp.com/

Vilas GiteMay 9, 20113,985250

In SQL Server, if we set the property of an identity “ON” then we cannot we cannot insert a single value in identity column easily

Nipun TomarMay 6, 20118,488250

Following Commands helps in Knowing:

Nipun TomarMay 6, 20113,088250

In SQL Server 2008 we can remove the duplicate rows from the table by using the following Query:

Nipun TomarMay 6, 20114,341250

In this blog you will Check Username if it exist in Database then- Message already Exist.

This blog show you How can we insert multiple values in table using only one insert?

Ankit NandekarMay 6, 20115,917250

This Blog give you general information about SQL SERVER ACID .

Ankit NandekarMay 6, 20119,146250

This Blog show you how to make database read onlu or read/write.

Ankit NandekarMay 6, 20113,638250

Here I will describe in a light way what is grouping sets.

Shirsendu NandiMay 5, 20112,763250

This Blog show you how to rename table name in Sql Server.

Ankit NandekarMay 5, 20113,679250