Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sghosh30
Starting Member
5 Posts |
 Posted - 2004-07-05 : 08:25:59
|
| HiI am calling SP_A from SP_B. SP_A has a datetime parameter and I am trying to call it like follows (from SP_B)Exec @V_Catch SP_A GETDATE()But the code won't compile unless I replace Getdate with a datetime variable initialized with the current date. Any idea guys?SG |
|
|
kroky
Starting Member
14 Posts |
Posted - 2004-07-05 : 11:43:56
|
| declare @x datetimeset @x = getdate()Exec @V_Catch SP_A @x |
 |
|
|
|
|
|
Passing GetDATE() as parameter