Jul182010

sql stuff

Published by Pete Celliers at 4:40 PM under

for procedures

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'') AND type in (N'P', N'PC'))
drop PROCEDURE
go

 

for views

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[matching].[workingset_patient_episodes]') AND type in (N'V'))
drop view [matching].[workingset_patient_episodes]
go

 



[KickIt] [Digg] [del.icio.us] [Facebook] [Google] [StumbleUpon]

Tags:

E-mail | Permalink | Post RSSRSS comment feed 1 Responses

Comments


Response by piet on 8/16/2010 11:15:07 AM

hello



Add comment




biuquote
  • Comment
  • Preview
Loading