1 of 6 in Topic
Next >>
| Topic : SQL Server Programming |
|
|
|
|
Activity:
Question posted: 03 24 2010 02:36:23 +0000,
0 answers, 220 views, last activity
07 06 2010 20:18:08 +0000
|
|
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.
0 Answers for "How I create my function in sql server 2008?"
Found the question
"How I create my function in sql server 2008?"
interesting?
Refer to your connections and communities
Viewers also viewed
|
|
|
|
|
|
Unanswered Questions (16)
|
|
Sponsored Jobs
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... |
