24,115 Total Views, 18 views today There are different ways to check whether specific column is exists in a sql server table Solution:1 IF COL_LENGTH('schemaName.tableName', 'columnName') IS…
how to drop a stored procedure in sql server
552 Total Views, 3 views today You are no longer using a stored procedure and want to drop it from database. Drop stored procedure from database using…
how to drop a store procedure if exists in sql server
1,374 Total Views, 6 views today You are no longer using a stored procedure and want to drop it from database. Drop stored procedure from database using…
how to insert result of stored procedure into temporary table in sql server
3,160 Total Views, 18 views today This recipe will explain with Step by step example of how to insert result of a store procedure into temporary table…
how to replace null with 0 in sql server
2,782 Total Views, 11 views today Problem: Replace null value with 0 in sql server You are selecting rows from a table, and your results contain NULL…
how to check table size in sql server
513 Total Views, 3 views today SQL Server provides a built-in stored procedure sp_spaceused. By executing this stored procedure you can easily find the size of a…
how to rename table in sql server
559 Total Views, 3 views today Rename table name in Sql Server By using sp_rename stored procedure you can rename table name. Syntax: exec sp_rename ‘Schema_Name.Old_Table_Name’, ‘New_Table_Name’;…
String or binary data would be truncated
587 Total Views, 3 views today This recipe will demonstrate how to Fix Sql Server Msg 8152, Level 16, State 14, Line 1 String or binary data…
Cannot Insert Explicit Value For Identity Column In Table
525 Total Views, 4 views today This recipe will demonstrate how to Fix Msg 544, Level 16, State 1, Line 1 Cannot insert explicit value for identity…
Sql Drop Temp Table If Exists
1,824 Total Views, 4 views today Sql Drop Temp Table If Exists: Drop a temporary table if it is already created or exists. Then you can create…