DevSocial Blogs · SQL Server blogs

This blog describes how to allow update to the system catalogs in SQL Server 2012.

This blog is to demonstrate .How to create Encrypted View and Stored Procedure in SQL to keep them safe(unchanged).

Anupam SinghMay 21, 201419,210250

This blog is about creating a LOGON trigger in SQL for auditing purpose.

Anupam SinghMay 16, 20147,676250

SQL objects created date or modified date.

Khan Abrar AhmedMay 16, 20143,368250

This blog defines how to kill the session in SQL Server.

Khan Abrar AhmedMay 16, 20146,929250

Replace last character of the string in SQL Server.

Khan Abrar AhmedMay 16, 201418,230250

Column reference in SQL Server.

Khan Abrar AhmedMay 16, 20143,463250

This blog will help to handle the transaction in Insert Update Stored Procedure.

Khan Abrar AhmedMay 15, 20144,063250

This blog will provide the example to run the no. of scripts on SQL Server using bat file.

Khan Abrar AhmedMay 15, 201411,222250

In this blog I am going to share a quick way to make a Copy of Table in SQL Server.

Anupam SinghMay 13, 20145,700250

While working on a SP today, I noticed that SQL Server does a case-insensitive string match in a query.

Nitesh KejriwalMay 13, 201422,920250

In this blog I shall demonstrate how to find the nth largest column data in a SQL Server table.

Praveen Raveendran PillaiMay 9, 20143,486250

How to store value in SQL Server session and retrieve the value from SQL server Session.

Khan Abrar AhmedMay 8, 20145,181250

Below query can help us to delete the duplication record from table using CTE.

Khan Abrar AhmedMay 8, 20143,347250

Delete all tables-views-stored procedures in SQL Server.

Bhupendra SinghMay 8, 201429,318250

This blog is help us to what is difference between primary key and Unique key in SQL Server

Jignesh TrivediMay 7, 20146,997250

This blog describes the aggregate functions in SQL.

Ranjit PowarMay 5, 20144,314250

I have a table with a recursive hierarchy (i.e. ID, ParentID). For any item in this hierarchy, I want to be able to bring back a list of everything UP AND DOWN the hierarchy, along with the level for each row. Assume that a parent can only ever have a single child.

Bhupendra SinghMay 2, 20143,675250

This blog defines the method of merging the data of two tables, in SQL Server.

sudipta sanyalApr 30, 20143,133250

In this blog, by using a script I want to display the field list, which is set with a default value in a database.

how to reset identity column value in SQL server or change or rest identity column value to 1 in SQL server.

Ramasagar PulidindiApr 25, 20143,956250

how to get stored procedure last modified date in SQL server

Ramasagar PulidindiApr 25, 201412,925250

datediff() function in SQL Server to get date difference in days hours minutes, years, month between two dates or calculate datediff in SQL Server in days hours minutes format.

Ramasagar PulidindiApr 25, 20145,100250

The below function explains how to remove html tags from string in SQL Server or how to parse html tags and retrieve only text from string in SQL Server without using regular expressions or remove text between and get only text from string in SQL Server.

Ramasagar PulidindiApr 25, 20143,627250