use TbData
@FromDate Datetime = getdate()
@ToDate Datetime = getdate()
exec myStoreProc @TransDate,@EndDate我这样写出错,请教应如何写呢? 谢谢!
@FromDate Datetime = getdate()
@ToDate Datetime = getdate()
exec myStoreProc @TransDate,@EndDate我这样写出错,请教应如何写呢? 谢谢!
use TbData
go
declare @FromDate Datetime = getdate(),
@ToDate Datetime = getdate()
exec myStoreProc @TransDate,@EndDate--2005 2000
use TbData
go
declare @FromDate Datetime ,@ToDate Datetime
set @FromDate=getdate()
set @ToDate=getdate()
exec myStoreProc @TransDate,@EndDate
set @FromDate=getdate()
set @FromDate=getdate()
exec myStoreProc @TransDate,@EndDate
declare @FromDate Datetime,@ToDate Datetime
set @FromDate=..
set @ToDate=...exec myStoreProc @TransDate,@EndDate
DECLARE @FromDate Datetime
SET @FromDate = getdate()
DECLARE @ToDate Datetime
SET @ToDate= getdate()
exec myStoreProc @TransDate,@EndDate