Showing posts with label analogous. Show all posts
Showing posts with label analogous. Show all posts

Sunday, March 11, 2012

Create Or Replace

Looking for something analogous to the Create Or Replace option in Oracle. Is there an equivalent command in SQL Server?ALTER PROC <PROC Name>

You want to do this because of the GRANTS?

SQL Server sometimes tends to be finicky...I alway DROP & CREATE, then GRANT|||Hey man, thanks for the reply. I'm just trying to get use to SQL Server and I'm working on a script to create a db, tables, grants, yadayadayada.

I guess that no different then any other ANSI stanard DB...

Drop... DUH! my bad, boy am I rusty...

:o