Sybase用法總結

--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