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 |
To which devices can a backup be created and where should these devices be located? : sql server management studio
Will count(column) include columns with null values in its count?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
How many types of Joins in SQL Server 2005?
9 Answers CarrizalSoft Technologies, HCL,
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
What is faster join or union?
Can we create clustered index on non primary key column
20 Answers ABC, CTS,
How to create a user name in a database?
what are acid properties? : Sql server database administration
Explain try...catch with sql server?
What is lock escalation and what is its purpose?
How to start and end transact-sql statements?
Oracle (3253)
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)