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
- 1 Answers
- 2871 Views
- Aviva, I also Faced
- E-Mail Answers
Answer / amey
sql will throw error for not getting value to parameter.
reference object is null.
| Is This Answer Correct ? | 1 Yes | 0 No |
How do I setup a sql server database?
How to create new tables with "select ... Into" statements in ms sql server?
Do you know the policy based administration feature of sql server 2008?
Can we use custom code in ssrs?
What are the security related catalog views? : sql server security
Is sql server 2016 free?
What is the difference between online clustering and Offline clustering?
How to list all stored procedures in the current database using ms sql server?
What all db objects can be found in MSDB database of a SQL Server instance?
What are the elements of dbms?
How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????
How to execute a stored procedure in ms sql server?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
