SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- 管理员查看订餐记录单,2009/10/21 14:37,张亚平
-- =============================================
CREATE PROCEDURE p_adm_MealOrders
(
@userID nvarchar(256)='', --用户ID
@startDate datetime='2009/01/01 00:00:00',--开始日期
@endDate datetime=getdate(), --结束日期----------我希望结束日期是getdate(),怎么设置?
@colName varchar(50)='', --排序字段
@direction bit = 0 --排序方向(1升0降)
)
AS
BEGIN
select * from dbo.tb_OrderInfo
END
GO
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- 管理员查看订餐记录单,2009/10/21 14:37,张亚平
-- =============================================
CREATE PROCEDURE p_adm_MealOrders
(
@userID nvarchar(256)='', --用户ID
@startDate datetime='2009/01/01 00:00:00',--开始日期
@endDate datetime=getdate(), --结束日期----------我希望结束日期是getdate(),怎么设置?
@colName varchar(50)='', --排序字段
@direction bit = 0 --排序方向(1升0降)
)
AS
BEGIN
select * from dbo.tb_OrderInfo
END
GO
要不就这样写
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- 管理员查看订餐记录单,2009/10/21 14:37,张亚平
-- =============================================
CREATE PROCEDURE p_adm_MealOrders
(
@userID nvarchar(256)='', --用户ID
@startDate datetime='2009/01/01 00:00:00',--开始日期
@endDate datetime = null, --结束日期----------我希望结束日期是getdate(),怎么设置?
@colName varchar(50)='', --排序字段
@direction bit = 0 --排序方向(1升0降)
)
AS
BEGIN
if @endDate is null
select @endDate = getdate()
select * from dbo.tb_OrderInfo
END
GO
2、在调用的时候
exec p_adm_MealOrders @endDate=getdate(),