Procedure,Function SQL server - VB.NET

ducletanducletan Member Posts: 4
edited 2010-12-09 in SQL General
Help me:
create procedure sp1
@giatri bit,
@output nvarchar(max) OUTPUT
as
begin
if @giatri
set @output='OK '
else
set @output='Failse '
end

create Function F1
@giatri bit,
returns nvarchar(max)
as
begin
declare @output nvarchar(max)
if @giatri
set @output='OK '
else
set @output='Failse '

return @output
end

In VB.NET

sp1 return: 'O' or 'F' (first char)
F1 return 'OK ' or 'Failse '

Thanks
Sign In or Register to comment.