445 Total Views 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’; Example: USE…
Month: November 2017
String or binary data would be truncated
459 Total Views This recipe will demonstrate how to Fix Sql Server Msg 8152, Level 16, State 14, Line 1 String or binary data would be…
Cannot Insert Explicit Value For Identity Column In Table
420 Total Views This recipe will demonstrate how to Fix Msg 544, Level 16, State 1, Line 1 Cannot insert explicit value for identity column in…
Sql Drop Temp Table If Exists
1,444 Total Views, 2 views today Sql Drop Temp Table If Exists: Drop a temporary table if it is already created or exists. Then you can create…
Drop Table If Exists Sql Server
356 Total Views Drop Table If Exists Sql Server: Use the DROP TABLE statement to drop or remove an existing table definition and data for the…