In this article we will learn about IDENTITY PROPERTY in SQL Server. Sometimes we need a column whose values can uniquely identifying the rows in…
In this article we will learn about Different Types of SQL JOINs. A SQL Join statement is used to combine data or rows from two…
In this article we will learnt about Find all the Columns name in a table. Suppose there is a scenario when we require to fetch…
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 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…