Site Sections
Posts
391
Comments
137
Trackbacks
0
<< nowrap per CSS | Home | Fehlermeldung: "Error while opening the virtual machine: This virtual machine appears to be in use" >>
Prüfen ob eine stored procedure existiert

Fürs Archiv - Prüfen ob eine stored procedure existiert:

if

exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ProcedureName]') and
OBJECTPROPERTY(id, N'IsProcedure') = 1)

-- do something
posted on Sunday, June 17, 2007 11:26 AM Print
Comments
No comments posted yet.

Post Comment

Title *
Name *
Email
Url
Comment *  
Please add 1 and 3 and type the answer here:
Archives
Post Categories
test