boobalanmca07 (11/27/2012)
I am using two sql statements in stored procedure,the two sql query is update and alter.
in some times i need to execute update query only,at that time how to execute stored procedure
ALTER? to alter a table, it would only need to occur once, ever, in the database; doesn't really belong in the procedure.
otherwise you end up having to test every time whether to do it or not, which, since it will occur once, wastes a little bit of time checking to see if it needs to be done.
so my advice is to rethink where to put the alter statement...i don't think it belongs in a procedure.
regardless, you'd have to do something like this:
CREATE PROCEDURE MyProc(@paramters int)
AS
BEGIN
IF NOT EXISTS (SELECT 1
from sys.objects objz
left outer join sys.columns colz
on objz.object_id = colz.objectid
where objz.name = 'MyTable'
and colz. name = 'MyColumn')
BEGIN --IF
ALTER TABLE MyTable ADD MyColumn sqlvariant
END --IF
UPDATE MyTable
SET SomeColumn = SomeValue
WHere AnotherColumn = @paramters
END --PROC
Lowell