Concatenate string and Int in SQL server
In this article, I am going to write t-sql query to concatenate two strings and concatenate string and Int in …
SSMS
Create new SQL Database in different location using SSMS
When you create new SQL Server Database, both Primary data file and Log file of the database will be created under …
Backup and Restore SQL Database using SSMS
Getting Backup of SQL Server database is one of the very important task before doing any critical change in database …
Case Sensitive Search in SQL Query (Where)
Normally, in programming languages like C# .NET, we need to explicitly add criteria to ignore case sensitive search or compare …
Create temp table in SQL Server
SQL Server provides the feature temporary table which helps user to replace Stored Procedure that requires large number of …
The DELETE statement conflicted with the REFERENCE constraint
You will get this error when you are trying to Delete the record from a Table which has a reference …
Insert XML into SQL Server Table using SSMS and C#
Description In SQL Server Relational Database Management System (RDMS), we always try to create best Database Table design. So …