MS SQL 语言问题，麻烦大家帮我看下这段代码错了哪里？谢谢！

来源：百度知道编辑：UC知道时间：2024/06/17 20:12:24

CREATE TABLE [dbo].[t_Control_Usr](
[ID] [int] IDENTITY(1,1) NOT NULL,
[Dir] [varchar](100) COLLATE Chinese_PRC_CI_AS NULL,
[FileName] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ControlID] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[UsrID] [varchar](50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]

GO
USE [oil2]
GO
/****** 对象: StoredProcedure [dbo].[QueryAudit] 脚本日期: 12/13/2008 22:10:51 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO

CREATE PROCEDURE [dbo].[QueryAudit]
@Dir VARCHAR(100),
@FileName VARCHAR(50),
@USRID VARCHAR(50),
@ControlID VARCHAR(50)
AS

SELECT COUNT(*) FROM t_Control_Usr WHERE Dir=@Dir
and FileName=@FileName
and UsrID=@USRID
and ControlID=@ControlID

Create PROCEDURE [dbo].[AddAudit]
@Dir VARCHAR(100),
@FileName VARCHAR(50),
@USRID VARCHAR(50),
@ControlID VARCHAR(50)

两个
CREATE PROCEDURE
之间([QueryAudit]和[AddAudit]之间)要加一个
go

CREATE PROCEDURE [dbo].[QueryAudit]
@Dir VARCHAR(100),
@FileName VARCHAR(50),
@USRID VARCHAR(50),
@ControlID VARCHAR(50)
AS

SELECT COUNT(*) FROM t_Control_Usr WHERE Dir=@Dir
and FileName=@FileName
and UsrID=@USRID
and ControlID=@ControlID

go -------------------------------这里

Create PROCEDURE [dbo].[AddAudit]
@Dir VARCHAR(100),
@FileName VARCHAR(50),
@USRID VARCHAR(50),
@ControlID VARCHAR(50)
AS
INSERT INTO t_Control_Usr(Dir,FileName,UsrID,ControlID) VALUES(@Dir,@FileName,@UsrID,@ControlID)

有关C语言指针问题,麻烦大家帮我看下麻烦大家帮我看下是什么问题！！麻烦大家帮我看下? 麻烦大家帮我看下内存麻烦大家帮我看一下C语言程序麻烦大家帮我看下我电脑是不是有问题了我也不太懂一个SQL查询的问题(急用,大家帮下我) 一道C语言问题!!!!请大家帮我看下!非常谢谢!!! 麻烦大家帮我看下这个配置和价格冒险岛麻烦大家帮我看下？