DevSocial Blogs · SQL Server blogs

In this blog, you will learn how you can find all the months of a particular quarter.

Sourabh SomaniMay 16, 201744,836250

Sometimes this happens when you start Windows and Open Microsoft SQL Server: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

Zahid MustafaMay 16, 20174,220250

Some simple queries that might be helpful

Pravat KumarMay 13, 20175,319250

Table Valued Parameter allows a table (i.e multiple rows of data) to be passed as a parameter to a stored procedure.

Satyaprakash SamantarayMay 9, 2017219,161250

In this blog, we will understand how to resolve "cannot connect to a local\remote SQL Server instance using SQL Server authentication with a error code: 18456".

Sateesh ArvetiMay 8, 201713,272250

In this blog, I have added div tag in the stored procedure, as I used in ASP.NET html.

Satyaprakash SamantarayMay 8, 201712,612250

Triggers are associated with the table or view directly.

Satyaprakash SamantarayMay 3, 201758,865250

We can remove Null values in Table data.

Satyaprakash SamantarayMay 1, 201728,347250

This blog acquaints you with aborting/ killing a long running stored procedure.

Ashutosh MundApr 28, 201768,062250

sys.objects has a big role.

Satyaprakash SamantarayApr 27, 201717,532250

By executing a SQL query, we can get detailed information about what date and time the table and stored procedure were created.

Satyaprakash SamantarayApr 27, 20174,871250

The "exists" condition is used to check if there is any table and stored procedure with that name.

Satyaprakash SamantarayApr 27, 2017152,007250

This blog demonstrates why stored procedures are outdated.

rupali patilApr 26, 201710,165250

Pivot is an operator in SQL Server.

Satyaprakash SamantarayApr 24, 201739,717250

Temporary tables are created in TempDB database and are automatically deleted, when they are no longer used.

Satyaprakash SamantarayApr 24, 2017166,176250

Case statement is mostly used in Real Time scenarios

Satyaprakash SamantarayApr 24, 201722,550250

This article emphasizes that there is no need to delete a whole table. Instead, write SQL query to get this result.

Satyaprakash SamantarayApr 24, 201727,477250

UNPIVOT operator is the reverse process of PIVOT operator.

Satyaprakash SamantarayApr 24, 201714,316250

This blog illustrates SET NOCOUNT ON and SET NOCOUNT OFF, which are very useful in real time scenarios inside stored procedure in SQL Server.

Satyaprakash SamantarayApr 21, 201774,790250

INSTEAD OF DELETE TRIGGERS are used, to delete records from a view.

Satyaprakash SamantarayApr 20, 201776,961250

INSTEAD OF UPDATE TRIGGERS correctly update a view.

Satyaprakash SamantarayApr 20, 201761,697250

This blog acquaints you with deleting duplicate records from a table in SQL Server, using ROW_NUMBER.

Pravat KumarApr 19, 20176,320250

In this blog, we will learn about NULL value in SQL Server.

Amit KumarApr 19, 201718,967250

INSTEAD OF triggers are usually used to correctly update views that are based on multiple tables.

Satyaprakash SamantarayApr 18, 201755,143250