ASP.NET

stored procedure problem

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: Nov 2007

Posts: 28

Reputation: u4umang2001 is an unknown quantity at this point

Solved Threads: 0

u4umang2001 u4umang2001 is offline

Offline

Light Poster

stored procedure problem

Feb 13th, 2008

Hi

i am passing three parameters to my stored procedure.

now in stored procedure i want to execute the query on the basis of given condition.

suppose i m passing para1, para2 and para3.

now i want update table1

if(para1='' or para1= null) then
'update table1 set para2='''+@para2+''' and para3='''+@para3+''''
else
'update table1 set para1='''+@para1+''' and para2='''+@para2+''' and para3='''+@para3+''' '

how can i do this???

please help...

Thanks in advance

Thanks & Regards
Umang

•

Join Date: Feb 2008

Posts: 1

Reputation: FeJoMaFe is an unknown quantity at this point

Solved Threads: 0

FeJoMaFe

Offline

Newbie Poster

Re: stored procedure problem

Feb 13th, 2008

Hi u4umang2001,

Right now I don't have near to me sample code, but could you take a look at Dynamic SQL?

See the following URL: http://msdn2.microsoft.com/en-us/library/aa258848.aspx

Hope this helps,

FeJoMeFa

•

Join Date: Feb 2008

Posts: 30

Reputation: dilipv is an unknown quantity at this point

Solved Threads: 4

dilipv

Offline

Light Poster

Re: stored procedure problem

Feb 14th, 2008

hi u4umang2001,

•

if(para1='' or para1= null) then
'update table1 set para2='''+@para2+''' and para3='''+@para3+''''
else
'update table1 set para1='''+@para1+''' and para2='''+@para2+''' and para3='''+@para3+''' '

Your query is little bit simple but you should try first using various article. These articles can be easily found using Google. If you want to learn things, you should try atleast once.
Following is solution for your query.

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
CREATE PROCEDURE sp_myStoredProcedure
   @para1   varchar(100),
   @para2   varchar(100),
   @para3   varchar(100)
AS
   if @para1 IS NULL
        update table1 set para2=@para2 and para3=@para3
   else
        update table1 set para1=@para1 And para2=@para2 And para3=@para3
Go
CREATE PROCEDURE sp_myStoredProcedure
   @para1   varchar(100),
   @para2   varchar(100),
   @para3   varchar(100)
AS
   if @para1 IS NULL
        update table1 set para2=@para2 and para3=@para3
   else
        update table1 set para1=@para1 And para2=@para2 And para3=@para3
Go

Hope this will help you. Don't rely on others, first try yourself if not possible then ask for solution.
Thanks & Regards
Dilip Kumar Vishwakarma
Programmer
.Net Consulting