Previous Topic

Next Topic

Inhoudsopgave

Book Index
Using The Same Parameter More Than Once

In ASE you can use the same parameter more than once. The optimizer will use the first occurrences. MS SQL Server will raise an error instead.

Example

create proc Example (@Par1 int, @Par2 int=null) as

select @Par1 as 'The parameter'

go

exec Example @Par1 = 1, @Par1 = 2

go

drop proc Example