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
- 2880 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 many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
Explain full-text query in sql server?
What are the steps you will take to improve performance of a poor performing query?
What is the difference between for auto and for nested?
How To delete duplicate record from a particular table?
How many partitions a clustered index has by default in sql server 2012?
What is the beast way to write CTE in SQL Server ?
Differentiate between truncate vs delete in mssql?
What is a select query statement in ms sql server?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
How to stop log file growing too big?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
-
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)
