skip to main | skip to sidebar

Structured Query Language (SQL)

Home Data Structure Operating System C Language Client Script SQL .Net

Monday, August 24, 2009

SQL Verify that the stored procedure does not already exist.

IF OBJECT_ID ( 'usp_GetErrorInfo', 'P' ) IS NOT NULL
DROP PROCEDURE usp_GetErrorInfo;
Posted by Senthilkumar Nainamalai at 4:57 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ▼  2009 (31)
    • ►  July (1)
    • ▼  August (25)
      • Basic SQL Query
      • SQL Help Query
      • SQL Join Query
      • SQL Union/ Union All Query
      • SQL Indexes
      • SQL Alter/ Modify Table
      • SQL Rename Command
      • SQL Truncate Vs Delete
      • SQL To get Serial Number for each record
      • SQL Select Maximun/ Minimun value in table
      • Aggregate/ Scalar functions
      • SQL Group By/ Having
      • SQL Select INTO Statement
      • SQL IN clause - Copy tables into another database
      • SQL View Statement
      • SQL Case, Trim Statement
      • SQL String Functions
      • SQL Begin, Rollback & Commit Transaction
      • SQL Declare, If-esle, cast
      • SQL Get Duplicate Records(Pairs of Duplicate Row) ...
      • SQL Column and Row check to get date between
      • SQL
      • SQL Error Handling (Try, Catch)
      • SQL CATCH Block System Functions
      • SQL Verify that the stored procedure does not alre...
    • ►  October (1)
    • ►  November (4)
  • ►  2010 (6)
    • ►  February (6)
  • ►  2014 (7)
    • ►  December (7)