--1.判斷表數據是否為空
declare @total int
declare @tablename varchar(40)
declare @ls_sql varchar(200)
set @tablename = 'DGJK'
set @ls_sql = ""
set @ls_sql = @ls_sql + "select @total = count(1) from " + @tablename + ""
execute(@ls_sql)
if @total <> 0
begin
print "true"
end
else
begin
print "false"
end
--2.判斷數據庫中表是否存在
--方法一
declare @tablename1 varchar(20)
set @tablename1 = 'DGJK'
if exists(select * from sysobjects where name =@tablename1)
begin
print 'true'
end
else
begin
print 'false'
end
--方法二
declare @tablename2 varchar(20)
set @tablename2 = "DGJK"
if object_id(@tablename2) is not null
print '存在'
else
print '不存在'
--3.Sybase bit類型用法
declare @tablename3 varchar(20)
declare @flag bit
set @tablename3 = 'DGJK'
if object_id(@tablename3) is not null
begin
set @flag =1
end
else
begin
set @flag =0
end
declare @total int
declare @tablename varchar(40)
declare @ls_sql varchar(200)
set @tablename = 'DGJK'
set @ls_sql = ""
set @ls_sql = @ls_sql + "select @total = count(1) from " + @tablename + ""
execute(@ls_sql)
if @total <> 0
begin
print "true"
end
else
begin
print "false"
end
--2.判斷數據庫中表是否存在
--方法一
declare @tablename1 varchar(20)
set @tablename1 = 'DGJK'
if exists(select * from sysobjects where name =@tablename1)
begin
print 'true'
end
else
begin
print 'false'
end
--方法二
declare @tablename2 varchar(20)
set @tablename2 = "DGJK"
if object_id(@tablename2) is not null
print '存在'
else
print '不存在'
--3.Sybase bit類型用法
declare @tablename3 varchar(20)
declare @flag bit
set @tablename3 = 'DGJK'
if object_id(@tablename3) is not null
begin
set @flag =1
end
else
begin
set @flag =0
end