Build your professional network on facebook via our app Go to app
 
 1 of 6 in Topic  Next >>
Topic : SQL Server Programming
  Rate : 
Associated with other topics :
 
Industry : IT Services
Functional Area : Application Software
Activity: Question posted: 03 24 2010 02:36:23 +0000, 0 answers, 220 views, last activity 07 06 2010 20:18:08 +0000
 
Share
 
 
 
 

I want to create my function that can retrieve data from Table in sql server 2008 on the basis of several parameters which I pass to that function as argument?

And I also want to make that function in such a way that if parameters contains a value except null then this parameter should add to select query in such a way that

select * from Table where

If(param1.value!=null)

param1=value of param1

.....

and it is upto the all parameters which I send in function as arguments and in last I want a select qry which would be like

select * from Table where Param1=Param1.value and Param3=Param3.value and Param5=Param5.value

in above qry Param2 and Param4 having NULL values.

 
 
Leading Recruitment Firm
Leading Recruitment Firm
Viewers also viewed
Dynamic Management Views   The dynamic management views (DMV’s) in SQL Server 2005 are designed...
 
11 referals 6 comments, 1828 views
Retaining sales is more difficult than creating one due to the market competition which arises.
 
0 referals 27 arguments, 612 views
A few days back I read a post by Manish Kumar which said we should build what we think should...
 
1691 referals 11 votes, 389 views
more...  
Unanswered Questions (16)
 
0 referals 0 answers, 0 views
Hi,  I need some information ..  How can you understand and control costs? and  Is there an...
 
1 referals 1 answers, 31 views
More From Author
Somebody tell me the entire procedure to get certified for Microsoft's MCPD?
No. I don't think so because It is very similar to a glass fill half of water and some says that the glass is half empty and others says that the glass is half full so its up to you to take these helpful features to make yourself dependent or make...
more...