Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
4
Reply
stored procedure for filters
Santosh Sasupalli
Aug 31 2016 6:59 AM
223
Reply
i have a task
@state varchar(50),
@location varchar(50)
as
begin
end
if he pass state="",location="" then select all institutes in country
if he pass state value then select institutes in that state
if he pass location also value then select institutes in that particular location
how to write query
please help me
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
Checking Query in SQL
Optimize redundant sproc calls