Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2005 > SQL Server 2005
|
SQL Server 2005 General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 9th, 2010, 04:32 AM
Registered User
 
Join Date: Dec 2010
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Procedure,Function SQL server - VB.NET

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
 
Old December 9th, 2010, 05:50 PM
Friend of Wrox
 
Join Date: Jun 2008
Posts: 1,649
Thanks: 3
Thanked 141 Times in 140 Posts
Default

And what is the question?





Similar Threads
Thread Thread Starter Forum Replies Last Post
Stored Procedure Not Returning Same Value As Inline Sql VB.Net 2008 slbibs ADO.NET 6 March 11th, 2010 04:16 AM
ASP.NET 1.1,VB.NET,crystal reports, SQl server gvi Crystal Reports 1 September 11th, 2008 02:55 AM
ASP.NET & SQL Server 2K Stored Procedure kwilliams ASP.NET 2.0 Basics 7 May 10th, 2006 12:55 AM
VB.Net to SQL Server 2000 everest VB.NET 4 April 26th, 2004 08:55 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.