DevSocial Blogs · SQL Server blogs

This blog defines the dynamic pivot in SQL Server.

Ashok SharmaFeb 20, 20144,326250

Here, we will learn about the Dynamic pivot and removing the null value in the SQL Server.

Ashok SharmaFeb 20, 201439,892250

In this blog we will see how to a fetch list of the recently executed queries.

Bharath ReddyFeb 20, 20143,786250

In this blog, I would like to give an example in which the Order By clause is used with the Union clause in SQL.

Pradip PandeyFeb 20, 20145,332250

This blog defines the unpivot table in SQL Server.

Ashok SharmaFeb 19, 20146,355250

This blog explains the LOG function in SQL server 2012.

Jignesh TrivediFeb 19, 20145,442250

This blog defines how to use store procedure in SQL Server.

Ashok SharmaFeb 17, 20142,795250

This blog defines how to use store procedure with parameter in SQL Server.

Ashok SharmaFeb 17, 20143,053250

This blog defines pivot table in SQL Server.

Ashok SharmaFeb 17, 20146,462250

This blog discusses the method of identifying the costly unused index using a DMV Query.

Gohil JayendrasinhFeb 7, 20143,610250

In this blog, we will generate all the database backup from the SQL Server using the Query.

Kunal PatelJan 24, 20144,523250

Order of the SQL Query processing phases.

Rahul BansalJan 20, 20143,196250

This blog talks about the workaround to limits the number of records per page in SSRS 2012.

Prakash TripathiJan 8, 201415,910250

This blog discusses the key features introduced in SQL Server 2014.

Prakash TripathiJan 8, 20147,957250

Search a word in the entire table of a Database

Abhay ShankerJan 6, 20143,247250

User defined function for find the distance between two Locations.

Get all the database objects using ADO.NET.

Biswa Pujarini MohapatraJan 2, 20148,719250

Enable the sa login in SQL Server.

Abhay ShankerJan 2, 20143,754250

Row constructor in SQL Server.

Abhay ShankerDec 30, 201319,680250

Explains that how to Concatenate columns in SQLServer.

Abhay ShankerDec 26, 20134,467250

Script to get the list of all the parameters of an SQL Server Store Procedure.

Abhay ShankerDec 19, 20134,402250

This blog defines parent-child recursive Query using CTE.

Remove a column from SQL SERVER database table.

Abhay ShankerDec 11, 20138,993250