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
What is server-level principal?
How to transfer a table from one schema to another?
What are the purposes and advantages stored procedure?
How to drop an existing user defined function in ms sql server?
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
what method you can use to reduce the overhead of Reporting Services data sources?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
Explain concepts of analysis services?
What is the cartesian product of the table?
how many bits ip address consist of? : Sql server database administration
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
Do you know what is openxml in sql server?
Can we use where and having clause together?
What is explicit mode in sql server?
what is a check constraint?