DevSocial Blogs · SQL Server blogs

Below are some query example where you can actually look through column metadata that gives you information regarding whether the column is identity, if it allows null or not and so on.

Tapan PatelSep 2, 20165,367250

For each object which is schema scoped, SQL server identifies that object using the object id. If queried for objects like trigger (which is not schema scoped) or the objects which are not there in sys.objects view, SQL server won’t return the object id.

Tapan PatelSep 2, 20166,882250

In this blog, we will learn the difference b/w GETDATE and SYSDATETIME function in SQL Server.

Pankaj Kumar ChoudharyAug 28, 201622,408250

In this blog, you will learn, how to use Pivot table in SQL Server, using example.

Bhuvan PandeyAug 21, 201611,309250

This blog is about changing the default values of select/edit commands in SQL Server Management Studio

Midhun TpAug 21, 20164,359250

In this blog, I will show how to remove the special characters in SSRS report builder.

Rathrola Prem KumarAug 21, 201633,929250

In this blog, you will learn, how to create a stored procedure with a real time scenario, using SQL Server.

Bhuvan PandeyAug 20, 201689,122250

In this blog, we will learn how to get the missing values from a column.

Pankaj Kumar ChoudharyAug 17, 20164,864250

In this blog, w will learn, how to get the list of last executed queries.

Pankaj Kumar ChoudharyAug 17, 201688,196250

In this blog we learn how to get the host name and logged user name.

Pankaj Kumar ChoudharyAug 17, 20164,981250

Generate random password using MS SQL Stored procedure.

Vishal JadavAug 16, 201649,329250

In this blog, we will learn, how to generate the fixed length number pad ride side with 0.

Pankaj Kumar ChoudharyAug 15, 20163,715250

In this blog, we will learn, how to generate a random number ID for each row of the table.

Pankaj Kumar ChoudharyAug 15, 201625,252250

In this blog, we learn, how to insert the bulk data from a CSV file to the data table.

Pankaj Kumar ChoudharyAug 12, 201612,094250

In this blog, we will learn how to implement inner join, although we define the outer join in the query.

Pankaj Kumar ChoudharyAug 8, 20164,325250

In this blog, you will learn, how to make the row value in commas separate from other column data.

Bikesh SrivastavaAug 8, 20165,486250

In this blog, we learn how to change the color of the status bar in SQL Server.

Pankaj Kumar ChoudharyAug 8, 201620,539250

In this blog, we will see how to fix the issue when we get an error that the SQL Server cannot be connected.

Pradeep SahooAug 3, 201624,550250

In this blog we learn about the use of ANSI_NULLS in SQL Server.

Pankaj Kumar ChoudharyAug 3, 201625,742250

In this blog we learn about the Difference b/w QUOTED_IDENTIFIER ON and QUOTED_IDENTIFIER OFF command.

Pankaj Kumar ChoudharyAug 3, 201613,774250

This blog explain that how to get all table name that contain a specific column.

Pankaj Kumar ChoudharyAug 3, 20163,743250

In this blog, we learn about the String_Split function , which is a very useful function and comes with SQL Server 2016.

Pankaj Kumar ChoudharyAug 1, 20166,514250

In this blog, I am going to show you how the OWASP (Open Web Application Security Project) top 10 vulnerabilities are most dangerous in Web Applications and how we can maintain secure Web Applications from such security flaws.

Santosh Kumar AdidawarpuAug 1, 201610,406250

In this blog, we will learn about Hierarchical Database Model, with real examples and SQL query.

Shamim UddinJul 31, 201610,789250