Abundant Code
C#
C++
JavaScript
ASP.NET
C
Java
SQL Server
SQL Server
How to drop a table if it exists in SQL Server 2014 ?
How to rename a column in SQL Server ?
How to escape a single quote in SQL Server ?
How to find the duplicate records on certain fields in SQL Server ?
How to get the list of all tables from a SQL Server database ?
Inner Join in SQL Server
NULLIF function in SQL Server
Getting all the Foreign Key constraints list of a table in SQL Server
GOTO Label in SQL Server
How to get the Size of all tables in a SQL Server ?
How to disable Foreign Key constraints using T-SQL in SQL Server ?
Exit the Current Scope with a return value in SQL Server
Exit the Current Scope without returning a value in SQL Server
CASE expression in a Query in SQL Server
How to Get a value to a Variable in SQL Server ?
How to ALTER a Column from Null to NOT Null in SQL Server ?
How to Declare a variable in SQL Server ?
How to get the date part from the date time in SQL Server ?
Using FETCH and OFFSET to get N records in SQL Server
How to check if a column exists in a table in SQL Server ?
1
2
3
We provide tips, tricks, and advice for developers and students