USE [BCMY]
GO/****** Object: StoredProcedure [dbo].[Order_Query] Script Date: 10/15/2011 02:35:10 ******/
SET ANSI_NULLS ON
GOSET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <老季>
-- =============================================
CREATE PROCEDURE [dbo].[WaitForFirFacRec]
-- Add the parameters for the stored procedure here
@flag int = 0 output
AS
BEGIN
Select [Order.OrderNum],[Order.RecDate],[Order.XiadanDate],[SenOrder.RecDate],[SenOrder.StartDate],[SenOrder.HandoverDate]
from [Order] right join [SenOrder]
On SenOrder.OrderNum=Order.OrderNum
where SenOrder.HandoverDate!='1753-01-01 00:00:00.000'
if (@@ROWCOUNT>0)
Set @flag = 1
else
Set @flag = 0
END
GO
GO/****** Object: StoredProcedure [dbo].[Order_Query] Script Date: 10/15/2011 02:35:10 ******/
SET ANSI_NULLS ON
GOSET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <老季>
-- =============================================
CREATE PROCEDURE [dbo].[WaitForFirFacRec]
-- Add the parameters for the stored procedure here
@flag int = 0 output
AS
BEGIN
Select [Order.OrderNum],[Order.RecDate],[Order.XiadanDate],[SenOrder.RecDate],[SenOrder.StartDate],[SenOrder.HandoverDate]
from [Order] right join [SenOrder]
On SenOrder.OrderNum=Order.OrderNum
where SenOrder.HandoverDate!='1753-01-01 00:00:00.000'
if (@@ROWCOUNT>0)
Set @flag = 1
else
Set @flag = 0
END
GO
解决方案 »
- 请教个简单的加班费问题,一个小时4块钱,1个半小时是多少钱?
- sql server 2005 查找所有包含某个表的视图
- 高级嵌套分组查询统计
- 直接在表中复制一行,然后在新行那里改下数据,结果怎么改都好,都提示键入列信息不足或不正确,更新影响到多行
- sql 如何比较一个结果集在另一个结果集中存在
- 请问如何用SQL语句分类统计某个属性的null值和不为null的记录数?
- 开发行业SQL数据库
- 关于安装sql server 2000 sp4 的问题??
- 请高手指教,SQL语句中,如果一个字符串类型的数据(如VarChar(a)),实现a<300,应该怎么做?
- 想学用vc作数据库编程,无从下手,如何是好?
- 怎样用sql判断数据库是否存在。。
- 如何修改sqlserver 2005的服务名称?
-- Add the parameters for the stored procedure here
@flag int = 0 output
AS
BEGIN
Select [Order.OrderNum],[Order.RecDate],[Order.XiadanDate],[SenOrder.RecDate],[SenOrder.StartDate],[SenOrder.HandoverDate]
from [Order] right join [SenOrder]
On SenOrder.OrderNum=[Order].OrderNum
where SenOrder.HandoverDate!='1753-01-01 00:00:00.000'
if (@@ROWCOUNT>0)
Set @flag = 1
else
Set @flag = 0
END
GO
-- Add the parameters for the stored procedure here
@flag int = 0 output
AS
BEGIN
Select [Order].OrderNum,[Order].RecDate,[Order].XiadanDate,[SenOrder].RecDate,[SenOrder].StartDate,[SenOrder].HandoverDate
from [Order] right join [SenOrder]
On SenOrder.OrderNum=[Order].OrderNum
where SenOrder.HandoverDate!='1753-01-01 00:00:00.000'
if (@@ROWCOUNT>0)
Set @flag = 1
else
Set @flag = 0
END
GO
-- Author: <老季>
-- =============================================
CREATE PROCEDURE [dbo].[WaitForFirFacRec]
-- Add the parameters for the stored procedure here
@flag int = 0 output
AS
BEGIN
Select a.OrderNum,Order.RecDate,Order.XiadanDate,b.RecDate,b.StartDate,b.HandoverDate
from [Order] a right join [SenOrder] b
On a.OrderNum=b.OrderNum
where SenOrder.HandoverDate!='1753-01-01 00:00:00.000'
if (@@ROWCOUNT>0)
Set @flag = 1
else
Set @flag = 0
END
GO
-- Author: <老季>
-- =============================================
CREATE PROCEDURE [dbo].[WaitForFirFacRec]
-- Add the parameters for the stored procedure here
@flag int = 0 output
AS
BEGIN
Select a.OrderNum,Order.RecDate,Order.XiadanDate,b.RecDate,b.StartDate,b.HandoverDate
from [Order] a right join [SenOrder] b
On a.OrderNum=b.OrderNum
where b.HandoverDate!='1753-01-01 00:00:00.000'
if (@@ROWCOUNT>0)
Set @flag = 1
else
Set @flag = 0
END
GO
-- Author: <老季>
-- =============================================
CREATE PROCEDURE [dbo].[WaitForFirFacRec]
-- Add the parameters for the stored procedure here
@flag int = 0 output
AS
BEGIN
Select a.OrderNum,Order.RecDate,b.XiadanDate,b.RecDate,b.StartDate,b.HandoverDate
from [Order] a right join [SenOrder] b
On a.OrderNum=b.OrderNum
where b.HandoverDate!='1753-01-01 00:00:00.000'
if (@@ROWCOUNT>0)
Set @flag = 1
else
Set @flag = 0
END
GO
gridview的datafield属性我该怎么填呢?
表头都直接写的是“OrderNum”、”RecDate“、”XiadanDate“等,并没有查询时写的“[Order].OrderNum”,所以在前台gridview里面的datafield属性里直接写”OrderNum“等便可以了。
群里的