"Taha" <Taha105@hotmail.com> wrote in message
news:%23fAml6VTHHA.3592@TK2MSFTNGP06.phx.gbl...
> Hi All
> Haw Can I Execute Procedure with Para Date like
> Exec MyProcudre Getdate()
> No Declare Need
> Use Sql 2000 Sp3
> Thanks
>
>
>

> Haw Can I Execute Procedure with Para Date like
> Exec MyProcudre Getdate()
> No Declare Need
> Use Sql 2000 Sp3

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns98D4833E810AYazorman@127.0.0.1...
> Taha (Taha105@hotmail.com) writes:
>> Haw Can I Execute Procedure with Para Date like
>> Exec MyProcudre Getdate()
>> No Declare Need
>> Use Sql 2000 Sp3
>
> DECLARE @now datetime
> SELECT @now = getdate()
> EXEC MyProcedure @now
>
> You can only pass constants and variables as actual parameters in EXEC.
> You cannot pass expressions.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx