if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tb]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tb]
GOCREATE TABLE [dbo].[tb] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[item] [varchar] (30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
) ON [PRIMARY]
GO
drop table [dbo].[tb]
GOCREATE TABLE [dbo].[tb] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[item] [varchar] (30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
) ON [PRIMARY]
GO
as
declare @sign varchar(1)
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tb]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
set @sign='0' --已經存在
else
set @sign='1'select @signgo
能返回BOOL类型变量吗?
--是不是说错了,是指boolean类型吧
bit类型就是 ,1代表true 0 代表false
后者自己定义规则:用char(1),'1'表示true'0'表示false
请问该如何写?create proc Test
@field varchar(10),
@returnValue bit output
as
if exists (select 1 from 表 where 字段=@field)
set @returnValue = 1
else
set @returnValue = 0
go