give dump way parameter
i'm controlling sqlserver initial time, each unparalleled the emanate way scripts there retard formula next mislay way already exists:
if exists (select *
information_schema.routines
where routine_name = 'someprocedurename'
routine_type = 'procedure'
begin
dump way someprocedurename
end
//then way definition
to stop rupturing pasting boilerplate formula each record i put formula the possess stored way instead scripts feeling this:
dropifrequired('someprocedurename')
//then way definition
my try during fortitude is:
create way dropifrequired
(
@procedurename varchar
)
as
if exists (select * information_schema.routines
where routine_name = @procedurename
routine_type = 'procedure')
begin
dump way @procedurename
end
but i following following error:
msg 102, turn 15, state 1, way deleteprocedure, line 10
incorrect syntax circuitously '@procedurename'.
any ideas i want?
Comments
Post a Comment