SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Pr_GetDocuments]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[Pr_GetDocuments]ASSELECT
Document.*,Staff.RealName
FROM
Document
INNER JOIN
Staff
ON
Staff.Staff_ID = UserID and show='yes'
'
END就是想显示show这列里面值为yes的所有记录。
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Pr_GetDocuments]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[Pr_GetDocuments]ASSELECT
Document.*,Staff.RealName
FROM
Document
INNER JOIN
Staff
ON
Staff.Staff_ID = UserID and show='yes'
'
END就是想显示show这列里面值为yes的所有记录。
解决方案 »
- 如何对下面的表进行行转列,现在出错???
- 急,急,急 删除重复数据
- 请教:关于 with rollup 的问题
- 本机telnet 1433可以通,但局域网内其他机器telnet 我的机器的1433不通??
- 今天面试,有这么一道题,请大家讨论!
- 触发器中select 求和也用sum么?请帮忙
- 为什么不能增加一个列并指定它的PRIMARY KEY约束?
- sql语句联接查询问题
- SQLServer 2000 Driver for JDBC]Error establishing socket. 高手们帮帮忙吧!我快崩溃了!我快疯了!!!
- 300分悬赏SQL查询,执行通过就给分(另开帖发分)
- sql server数据备份----在线等
- datepart(yyyy) 的返回类型
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Pr_GetDocuments]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE [dbo].[Pr_GetDocuments]ASSELECT
Document.*,Staff.RealName
FROM
Document
INNER JOIN
Staff
ON
Staff.Staff_ID = UserID and show=''yes''
'
END