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 / amey
sql will throw error for not getting value to parameter.
reference object is null.
| Is This Answer Correct ? | 1 Yes | 0 No |
How to list all field names in the result set using mssql_field_name()?
what is denormalization? : Sql server database administration
What is difference between unique and primary key?
What is the difference between a Application Server and a Database
What is the difference between value type and reference type?
Does a specific recovery model need to be used for a replicated database? : sql server replication
what is curser.
How to concatenate two character strings together?
What is the difference between join and inner join?
If a stored procedure is taking a table data type, how it looks?
What is an identity column in insert statements?
What is the use of MOVE keyword in restore command
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)