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 are the three command line utilities and what are their primary functions?
How to update multiple rows with one update statement in ms sql server?
Differentiate between delete and truncate.
How do you trace the traffic hitting a sql server?
What are the different types of sub-queries?
What is index fragmentation in ms sql server?
Is it possible for a stored procedure to call itself or recursive stored procedure?
What is single-user mode?
What is amo? : sql server analysis services, ssas
Can sql servers linked to other servers like oracle?
How sql server executes a statement with nested subqueries?
How can I check that whether automatic statistic update is enabled or not?
How many instances per computer are there in sql server 2000?
What are the new features are introduced in sql server 2012 reporting services?
How to turn on the mssql api module in php?