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

Popular posts from this blog

list macos calm editors formula editors

how hibernate @any-related annotations?

why does floated <input> control floated component slip over too distant right ie7, nonetheless firefox?