Skip to content

Database Blogs

Sql, Oracle, MySql Problems & Solutions

Category: Sql Server

how to drop a stored procedure in sql server

Posted on March 15, 2018 By Solaiman

 433 Total Views You are no longer using a stored procedure and want to drop it from database. Drop stored procedure from database using DROP PROCEDURE…

how to drop a store procedure if exists in sql server

Posted on March 15, 2018March 15, 2018 By Solaiman

 1,106 Total Views You are no longer using a stored procedure and want to drop it from database. Drop stored procedure from database using DROP PROCEDURE…

how to insert result of stored procedure into temporary table in sql server

Posted on March 12, 2018 By Solaiman

 1,818 Total Views This recipe will explain with Step by step example of how to insert result of a store procedure into temporary table in sql…

how to replace null with 0 in sql server

Posted on December 12, 2017 By Solaiman

 1,726 Total Views,  2 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

Posted on December 11, 2017December 11, 2017 By Solaiman

 395 Total Views SQL Server provides a built-in stored procedure sp_spaceused. By executing this stored procedure you can easily find the size of a table, including…

how to rename table in sql server

Posted on November 29, 2017 By Solaiman

 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…

String or binary data would be truncated

Posted on November 4, 2017 By Solaiman

 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

Posted on November 4, 2017 By Solaiman

 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

Posted on November 4, 2017November 4, 2017 By Solaiman

 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

Posted on November 2, 2017November 4, 2017 By Solaiman

 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…

Posts navigation

Older posts

Recent Posts

  • How to check if a column exists in SQL Server table
  • how to drop a stored procedure in sql server
  • how to drop a store procedure if exists in sql server
  • how to insert result of stored procedure into temporary table in sql server
  • how to replace null with 0 in sql server

Recent Comments

  • md abdur rouf on How to check if a column exists in SQL Server table
  • Yeasmin on how to drop a store procedure if exists in sql server
  • Syed Maftahur Rahman Sohel on how to replace null with 0 in sql server
  • Yeasmin on how to replace null with 0 in sql server
  • Arif on String or binary data would be truncated

Archives

  • December 2018
  • March 2018
  • December 2017
  • November 2017
  • October 2017

Categories

  • Sql Server
  • Table

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
All Right Reserved 2016 Proudly powered by WordPress | Theme: Placid by ParagonThemes.