我创建一个 view
我想在试图里面加上一个iflag字段
CREATE VIEW dbo.vwOrder
AS
SELECT sBulkOrderID AS Oid, dOrderDate, iTotalQty, SalesGUID
FROM dbo.salBulkOrderMst
union
SELECT sSampleOrderID as Oid ,dOrderDate,iTotalQty,
sSales FROM splSampleOrderMst如果在delphi里面调用
select * from vworder where iflag=0
视图就返回 SELECT sBulkOrderID AS Oid, dOrderDate, iTotalQty, SalesGUID
FROM dbo.salBulkOrderMst 如果select * from vworder where iflag=1
视图就返回 SELECT sSampleOrderID as Oid ,dOrderDate,iTotalQty,
sSales FROM splSampleOrderMst
快点,救命,!
我想在试图里面加上一个iflag字段
CREATE VIEW dbo.vwOrder
AS
SELECT sBulkOrderID AS Oid, dOrderDate, iTotalQty, SalesGUID
FROM dbo.salBulkOrderMst
union
SELECT sSampleOrderID as Oid ,dOrderDate,iTotalQty,
sSales FROM splSampleOrderMst如果在delphi里面调用
select * from vworder where iflag=0
视图就返回 SELECT sBulkOrderID AS Oid, dOrderDate, iTotalQty, SalesGUID
FROM dbo.salBulkOrderMst 如果select * from vworder where iflag=1
视图就返回 SELECT sSampleOrderID as Oid ,dOrderDate,iTotalQty,
sSales FROM splSampleOrderMst
快点,救命,!
解决方案 »
- 求SQL语句
- TreeView如何判断 select的节点是否有子节点?
- 高手救命!!!我想拖动桌面图标到我程序的一个Edit上,在Edit中来显示图标指向的可执行程序名,怎么做?
- 200分:怎样在线程中应用Dll的接口函数呢?{急,在在线等}
- 在win98下报表的字体重叠了,怎么解决?
- 请问直接给DATE类型的数据怎么符值呢?
- 时间的比较
- format的问题
- 五星级问题!100分!做一个文档管理器,如何在数据库中存取带图片的word文档
- 每分钟接收2200条记录。保存成文件。求最佳实现方法。
- 用TWebBrowser中,如何截取javascript弹出窗口的信息内容?
- 程序中怎么调用邮件客户端程序(foxmail,outlook等)怎样发附件啊?
AS
SELECT sBulkOrderID AS Oid, dOrderDate, iTotalQty, SalesGUID,0 as iflag FROM
dbo.salBulkOrderMst
union
SELECT sSampleOrderID as Oid ,dOrderDate,iTotalQty, sSales,1 FROM splSampleOrderMst
AS
SELECT 1 flag, sBulkOrderID AS Oid, dOrderDate, iTotalQty, SalesGUID
FROM dbo.salBulkOrderMst
union all
SELECT 0 flag, sSampleOrderID as Oid ,dOrderDate,iTotalQty,
sSales FROM splSampleOrderMst