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
Mention the differences between sql server and mysql.
Can we use where clause with group by?
What happens if ntwdblib.dll is missing on your machine?
Does windows server 2016 come with sql server?
How to create a login account in ms sql server to access the database engine using "create login" statements?
What is transaction server isolation?
What is pessimistic concurrency?
How do you implement session management in SQL Server mode?
Explain the disadvantages of cursors?
How can we delete a table in sql server?
What is a primary key?
what is datawarehouse?
Where the sql logs gets stored?
What is order of B+tree?
Explain the steps to use transact-sql cursor?