帮我看看这个带输出参数的存储过程哪里写错了？

[zhangfeigreat]

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE up_inquireTableExist
-- Add the parameters for the stored procedure here
@tableName char(6),
@s_exist bit output
AS
IF OBJECT_ID('@tableName','U') IS NOT NULL
@s_exit = 0
ELSE @s_exit = 1
GO

[yuangang1011]

CREATE PROCEDURE up_inquireTableExist 
-- Add the parameters for the stored procedure here 
    @tableName char(6), 
@s_exist bit output 
AS 
    IF OBJECT_ID('@tableName','U') IS NOT NULL 
    Set @s_exit = 0  -- 这里
    ELSE
    Set @s_exit = 1 
GO 

[chowyi]

[Quote=引用楼主 zhangfeigreat 的帖子:]
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE up_inquireTableExist
-- Add the parameters for the stored procedure here
@tableName char(6),
@s_exist bit output
AS
IF OBJECT_ID('@tableName','U') IS NOT NULL
@s_exit = 0
ELSE @s_exit = 1
GO

[/Quote]
把'@tableName'两边的''去掉

[SQL77]

IF OBJECT_ID('@tableName','U') IS NOT NULL 
    @s_exit = 0 
    ELSE @s_exit = 1 

[yuangang1011]

SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
CREATE PROCEDURE up_inquireTableExist 
-- Add the parameters for the stored procedure here 
    @tableName char(6), 
	@s_exist bit output 
AS 
    IF OBJECT_ID('@tableName','U') IS NOT NULL 
    Set @s_exist = 0 
    ELSE
	Set @s_exist = 1 
GO 

[数字化从业者老高]

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE up_inquireTableExist
-- Add the parameters for the stored procedure here
    @tableName char(6),
@s_exist bit output
AS
    IF OBJECT_ID('@tableName','U') IS NOT NULL
    SET @s_exit = 0
    ELSE 
      SET @s_exit = 1
GO 

楼主忘了SET了。

[Yang_]

CREATE PROCEDURE up_inquireTableExist 
-- Add the parameters for the stored procedure here 
    @tableName char(6), 
@s_exist bit output 
AS 
    IF exists ( select 1 from sys.tables where name=@tableName
      set @s_exit = 0 
    ELSE 
      set @s_exit = 1 
GO 

[SQL77]

[Quote=引用 1 楼 yuangang1011 的回复:]
SQL codeCREATE PROCEDURE up_inquireTableExist
-- Add the parameters for the stored procedure here
@tableName char(6),
@s_exist bit output
AS
IF OBJECT_ID('@tableName','U') IS NOT NULL
Set @s_exit = 0 -- 这里
ELSE
Set @s_exit = 1
GO
[/Quote]

UP

[数字化从业者老高]

表名也不对。如果动态的，建议采用动态语句。

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE up_inquireTableExist
-- Add the parameters for the stored procedure here
    @tableName char(6),
@s_exist bit output
AS
    declare @sql varchar(1000)
    SET @sql='
    IF OBJECT_ID('''+@tableName+''',''U'') IS NOT NULL
    SET @s_exit = 0
    ELSE 
       SET @s_exit = 1'
print @sql
exec(@sql)
GO 

[yuangang1011]

建议用动态SQL

[chowyi]

alter PROCEDURE dbo.up_inquireTableExist
@tableName char(6),
@s_exist bit output
AS
begin
IF OBJECT_ID('@tableName','U') IS NOT NULL
select @s_exist =0
ELSE select @s_exist =1
select @S_exist
end

[等不到来世]

CREATE PROCEDURE up_inquireTableExist 
-- Add the parameters for the stored procedure here 
@tableName char(6), 
@s_exist bit output 
AS 
    IF OBJECT_ID(@tableName,'U') IS NOT NULL  --表名变量不用单引号
		set @s_exist = 0       --缺少set
    ELSE 
		set @s_exist = 1 
GO 

[chowyi]

你声明的变量名写错了

[zhangfeigreat]

这个问题解决了
那我在C#或者其它语言中调用这个存储过程，怎么获取这个输出参数@s_exist呢
谢谢

[yuangang1011]

cm.Parameters.AddWithValue("@s_exist", 0);
cm.Parameters["@s_exist"].DbType = DbType.Bit;
cm.Parameters["@s_exist"].Direction = ParameterDirection.Output;
cm.ExecuteNonQuery();

if (int.Parse(cm.Parameters["@BudgetError"].Value.ToString()) == 1)
{
.......
}

参考

[zhangfeigreat]

采用8楼的代码出现了错误：必须声明标量@s_exist

[Rotel-刘志东]

CREATE PROCEDURE up_inquireTableExist 
-- Add the parameters for the stored procedure here 
    @tableName char(6), 
@s_exist bit output 
AS 
    IF exists ( select 1 from sys.tables where name=@tableName
      set @s_exit = 0 
    ELSE 
      set @s_exit = 1 
GO 

[zhangfeigreat]

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER PROCEDURE [dbo].[up_inquireTableExist]
-- Add the parameters for the stored procedure here
@tableName char(6),
@s_exist int output
AS
--下面用动态SQL语句实现
declare @sql varchar(1000)
Set @sql = 'IF OBJECT_ID( ' + @tableName + ','U') IS NOT NULL
Set @s_exist = 1
ELSE
Set @s_exist = 0'
exec(@sql)

我改成上述动态语句，结果出现错误：‘U’附近有语法错误
应该怎么改呢