251 Total Views, 1 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’;…
Month: November 2017
String or binary data would be truncated
267 Total Views, 4 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
265 Total Views, 1 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
885 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…
Drop Table If Exists Sql Server
246 Total Views, 2 views today Drop Table If Exists Sql Server: Use the DROP TABLE statement to drop or remove an existing table definition and data…