Previous Topic

Next Topic

Inhoudsopgave

Book Index

Using Non-Existing Parameters

In ASE you can call a proc with a parameter that does not exist. The optimizer will ignore this parameter. MS SQL Server will raise an error instead.

Example

create proc Example (@Par1 int) as

select @Par1 as 'The parameter'

go

exec Example @Par1 = 1, @Par2 = 2

go

drop proc Example