Prev: Reference integrity between two databases
Next: Refresh SQLServer Local Cache
From: nzrdb6 on 26 Feb 2010 07:29
Can you pass expressions to a proc?
From: Tibor Karaszi on 26 Feb 2010 08:59
No, only values.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi



"nzrdb6" <nzrdb6(a)googlemail.com> wrote in message
news:76ca6815-fb69-4a25-822f-df3a32437f44(a)b7g2000yqd.googlegroups.com...
> Can you pass expressions to a proc?

From: Gert-Jan Strik on 26 Feb 2010 16:57
nzrdb6 wrote:
>
> Can you pass expressions to a proc?

Tibor answered that.

Having said that, you don't really need an expression for the example
you posted in the subject, because an implicit conversion will handle
that.

create proc test (@a as int)
as
select @a
go

exec test '0123'
go

drop proc test

--
Gert-Jan
 | 
Pages: 1
Prev: Reference integrity between two databases
Next: Refresh SQLServer Local Cache