DevSocial Blogs · SQL Server blogs

Here is the syntax for creating, Altering and Droping an Assembly in SQL Server:

Nipun TomarJun 7, 201111,546250

SQL provides many transaction management features. SQL commands COMMIT, ROLLBACK and SAVEPOINT helps in managing the transaction.

Sandeep ShekhawatJun 3, 201155,741250

Using this T-SQL you can easily find the Table relationship just passing Table Name

Gohil JayendrasinhJun 1, 201114,016250

In this blog I will give you the reason.

Shirsendu NandiJun 1, 20114,913250

Here I will will give the query

Shirsendu NandiMay 26, 20115,573250

Here I will discuss about shared locks (S) in SQL Server 2005/2008.

Shirsendu NandiMay 26, 20119,118250

This Blog show you how to increase performance of store procedure.

Ankit NandekarMay 24, 20115,581250

This Blog show you what is the difference between Truncate and Delete.

Ankit NandekarMay 24, 20114,664250

How to database operation with SSIS Script component

Here you can get the details about Script Component Types in SSIS

This blog will explain you, how to enable xp_cmdshell in Sql Server 2008.

Blocked AccountMay 19, 20118,609250

This article shows use, How to use Conditional Split in SSIS

This post will help you how to add dataviewer component in DataFlowTask.

The difference between the GRANT and REVOKE command is as under:

Nipun TomarMay 12, 201133,289250

I will give you a small query with the use of this you can find nth top most salary.

Ankit NandekarMay 12, 20115,807250