how many no of arguments can be passed in procedures and
functions
Answer / ranjan&
According to MSDN--> A Function and Procedure can have a
maximum of 2,100 parameters.
| Is This Answer Correct ? | 13 Yes | 2 No |
What are the steps you can take to avoid “deadlocks”?
What are a scheduled jobs?
What is a Lock and let me know Different types of locks?
What is difference between unique and primary key?
I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?
What are four major operators that can be used to combine conditions on a where clause?
What is the purpose of sql profiler in sql server?
How to make remote connection in database?
What are the methods used to protect against sql injection attack?
What does the automatic recovery do?
Explain insert into select statement?
how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.
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)