oh!!!!!
thanks 4 ur reply :-)...
hanuman308
Last Activity: Sep 19 '08, 09:18 PM
Joined: Sep 16 '08
Location:
-
error while executing stored procedure
hi there
i have written follwing SP
to add two columns in my table (passing tablename as parameter)
create procedure sp_addCol
@tablename varchar (50)
as
DECLARE @tsql_TZ varchar (200)
SET @tsql_TZ = 'ALTER TABLE [ '+@tablename+'] ADD timezone varchar (5)'
DECLARE @tsql_EXP varchar (200)
EXEC(@tsql_TZ)
SET @tsql_EXP = 'ALTER TABLE [ '+@tablename+'] ADD exported varchar...
No activity results to display
Leave a comment: