DevSocial Blogs · SQL Server blogs

Get definition/Script of all stored procedures of a database.

Pankaj PandeyMay 2, 20133,648250

Can we get the procedures which are used in another procedures. Is there any solution to get those?

Siva Ganesh RongalaApr 25, 20132,722250

We use either Rank() or Dense_Rank() to get consecutive numbering. But there is a difference between these two functions.

Pradip PandeyApr 25, 201322,060250

Query to insert data from one table to another table in on shot.

Pankaj PandeyApr 23, 201312,749250

In this blog we will see how we use bulk insert statement from SQL 2005 to insert large number of records from a text file.

Sivaraman DhamodaranApr 14, 201317,600250

Run the SQL Query using Query ShortCut.

Gaurav GuptaApr 12, 20136,720250

An introduction to Sequence in SQL Server 2012.

This blog shows Similarity and difference between PatIndex and CharIndex function in SQL SERVER.

Gaurav GuptaApr 11, 201386,688250

Discover concepts like ROW_NUMBER, RANK and DENSE_RANK.

Nitesh SinghalMar 26, 20134,402250

In this blog I'll explain the difference between SCOPE_IDENTITY, IDENT_CURRENT and @@IDENTITY in Sql Server.

Blocked AccountMar 20, 20138,181250

Difference between Sql server 2005 and 2008.

Purushottam RathoreMar 11, 201387,323250

In this blog I will explain about knowing the SQL Server details like version and edition. So we know the limitation of the server we work with. We could use the command in this blog for SQL SERVER 2005/2008/2012

ShyjuMar 5, 201310,762250

SQL Server management Studio's Backward and Forward compatibility.

Vidya Vrat AgarwalJan 13, 20137,697250

MS SQL 2012 or its previous version MS SQL 2008 has inbuilt statement completion feature. This can be set for all languages or for T-SQL only.

Anil KumarDec 26, 20125,203250

In this blog I have explained how to display the nth number from a table.

Vithal WadjeDec 3, 20125,105250

These are different types of query to get second highest value from table.

Kunal VaishyaOct 26, 20124,107250

This blog explains what the File Stream is in SQL Server 2008 and when and how to use it.

Kamal RawatSep 3, 20125,136250

In this Article, we will see about most frequently used string functions in SQL SERVER with working examples.

Prabhu RajaSep 2, 201215,029250

While editing a table in database in SQL Server 2008 I ran into a brick wall, or a 'by design' feature of the Database Management Studio.

Yogesh JaiswalAug 27, 20123,744250

In This blog, I’ll explain the basic difference between ISNULL and NULLIF

Blocked AccountAug 22, 201262,672250

In this blog I am going to explain how to shrink database log file in sql server.

Akshay PatelAug 8, 201220,094250

In this article I am going to explain how to Delete Duplicate Rows From Table In Sql Server.