Free Jobs
Reference




Dot Net Forums: ASPNET (77) C#.NET (39) VB.NET (8) AJAX (21) Silver Light (1) WCF (10) WPF (1) WWF (1) .NET 3.5 (3) SQL SERVER (38) Other (3)

Topic: How to create toggle functionality in Stored procedure for bit datatype in SQLServer

To get the Posted Questions details daily in your mail Click Here

Share this Post on Facebook/Twitter/Orkut Bookmark and Share





User: dhiraj5079 Post Date: 10 Jun 2011 03:58

Introduction:
Sometimes you may need to create a toggle functionality in Stored procedure for bit datatype in SQLServer



Main Content:

In this post we will be creating that using SQLServer syntax




create PROCEDURE [dbo].[UpdateToggleData]

@sid bigint


AS

BEGIN

    declare @tData bit

    select @tData = (select Plike from  TableLike where ShId = @sid)

    if(@tData = 1)   

 update TableLike  set Plike = ''false'' where ShId = @sid

    if(@likeData = 0)   

 update TableLike  set Plike = ''true'' where ShId = @sid

END


Conclusion:
Thus we can create toggle functionality in Stored procedure



About Writer:
Hi,I am IT Professional From Mumbai


Writer's Link: http://

Writer's Email:







Comments:
Post Comment





Similar Articles Top ArticlesLatest Articles Other Articles by this Author







www.freejobsreference.com Copyright © 2009-2011 | All Rights Reserved
All content of this website is protected by copyright laws and should not be reproduced in any form or by any means without written permission
(Best viewed in IE 8.0+ or Firefox 3.0+ at resolution of 1024 * 768 or higher)