In this article we will learn about Difference between Temporary Tables, Table Variable and CTE. In SQL Server, we have various options for storing data…
In this article we will learn about SQL Injection and Bulk Import in SQL Server. SQL injection is yet another common vulnerability that is the…
In this article we will learn about How to Add an Identity on Column in SQL SERVER. If we want to have a column where…
In this article we will learn about Difference between Stored Procedure and Function in SQL Server. Both stored procedures and functions are database objects which…
In this article we learn about Different Types of SQL Keys: Example and Uses. SQL Server key is an attribute or set of attributes in…
In this article we will learn about How to read data from XML string in SQL Server. Please read my previous article Formatting number to…
In this article we will learn about STUFF AND FOR XML PATH for String Concatenation in Sql Server. SQL Server supports XML data using the FOR XML clause. We can…
In this article we learn about Formatting number to add leading zeros in SQL Server. Please read the previous article Difference between ExecuteReader ExecuteScalar and…
In this article we will learn about Microsoft SQL Server Connection Strings. Means we discuss here in how many ways we can get the connection…
In this article we will learn about Difference between ExecuteReader ExecuteScalar and ExecuteNonQuery. Please read all .NET post in this link. ExecuteNonQuery ExecuteNonQuery method will…