청강컴정/DataBase

에러검출

luckey 2009. 3. 4. 12:17
create proc errorPrn
as
begin
    declare @i int
    select * from test
    if @@error = 0
    begin
       set @i = 0
    end
    else
    begin
       set @i = 1
    end
    return @i
end