DevSocial Blogs · SQL Server blogs

In this blog we shall see how to delete all the stored procedure in SQL.

Jaganathan BantheswaranJul 30, 201239,098250

In this blog I am going to explain how to work with exceptions handling in sql server stored procedure.

Mohammed KaleemJul 27, 20126,737250

Here we going to see how to Enable & Disable xp_cmdshell in SQL SERVER

Lajapathy ArunJul 3, 2012129,412250

To get list of Linked server configured in server using SQL Server

Lajapathy ArunJul 2, 20123,940250

Query returns all the rows which is different between both tables.

Lajapathy ArunJul 2, 20128,779250

SQL Server 2012 introduces several new features and improvements to replication.

Lajapathy ArunJul 2, 20128,234250

sp_helpdb -- Helps to get basic information of all database in the server

Lajapathy ArunJul 2, 20123,631250

We can drop multiple procedure at a time by comma separating the procedures.

Lajapathy ArunJun 25, 201224,955250

Used to get objects count from database.

Lajapathy ArunJun 23, 20127,384250

SQL Query to get count of objects based on its type like table,function in a SQL Server database.

Sateesh ArvetiJun 23, 201222,284250

In this article we are going to see, How to setup Intellisense in Sql Server 2008.

Lajapathy ArunJun 22, 20125,074250

In this blog, let us see how to add suffix for a field value if the value already exists in the table.

Santhosh Kumar JayaramanJun 4, 201223,842250

This blog is about create a copy of a database

jayakrishnan MorayurMay 27, 20125,127250

SSIS, Data flow task, Sql server,Using SSIS we can transfer huge number of records from one data source to another within very less time.

Biswa Pujarini MohapatraMay 27, 201239,006250

Swap values in a column using sql server

Venkatesan JayakanthamMay 24, 20128,701250

Recently executed queries in SQL Server

Venkatesan JayakanthamMay 24, 20125,339250

Finding the free space available in the log files

Venkatesan JayakanthamMay 24, 20123,679250

This blog explain how to Rename a Stored Procedure

Rahul Kumar SaxenaMay 24, 201242,911250

Char , Varchar, Nvarchar datatype in SQL Server

Venkatesan JayakanthamMay 24, 20125,504250

Bulk importing XML as a binary byte stream or loading xml to sql.

Rajshree MittalMay 23, 20126,660250

In this Blog we Create Table and stored procedure using scripts

how to create database in sql server 2005, Creation of database.

Rajshree MittalMay 22, 20129,822250

Small description about BCP utility,BCP Utility.

Vijaya KadiyalaMay 22, 201228,809250