if a parameter is not send to a stored procedure what type
of identifier is to be used in Stp and if that parameter is
not feed to the a query inside the Stp how to validate with
out useing IF condition
Answer Posted / amey
sql will throw error for not getting value to parameter.
reference object is null.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to modify an existing stored procedure in ms sql server?
What is store procedure? How do they work? When do you use?
What is sql server used for?
What are the tools available in market as an alternative to sql server reporting services?
what changed between the previous version of sql server and the current version? : Sql server database administration
What are statistics?
Explain the steps needed to create a scheduled job?
Why I have to use stored procedures?
What is indexing and its types?
What should be the fill factor for indexes created on tables? : sql server database administration
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
why would you call update statistics? : Sql server database administration
How to find table changes in sql server?
Can group by be used without aggregate functions?
Explain primary key, foreign key and unique key?