Codingvila: SQL Server

Introduction This article gives an explanation about how to create parent-child relation by splitting the string in SQL server as well...

SQL Server - Calendar Date (Date, Day, Month, Weekday)

Introduction This article gives an explanation about how to get calendar date in SQL server with Date, Day, Month, Weekday, Quarter, D...

Introduction This article gives an explanation about how to declare variable and set value in SQL server and how to set value in a var...

Introduction This article gives an explanation about STUFF() Function in SQL Server and shows you what is STUFF() Function in SQL Se...

Introduction This article gives an explanation of some of the basic performance tuning techniques in SQL Server and also explains how ...

Introduction This article gives an explanation about how to fix SQL server restore database error and also show you how to alter data...

Introduction This article provides an explanation about how you can use and set up a basic cursor in SQL Server. many of developers/...