Site Sections
Posts
242
Comments
66
Trackbacks
4
<< 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 8 and 4 and type the answer here:
Archives
Post Categories
test