what are the limitations of parameters in a storedprocedure
- 1 Answers
- 3073 Views
- I also Faced
- E-Mail Answers
Answer / karthik
According to MSDN, SQL Server limits the number of parameters per stored procedure to 2,100
| Is This Answer Correct ? | 0 Yes | 0 No |
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
explain different types of joins? : Sql server database administration
What causes index fragmentation?
two tables are there.1st table EMP has two columns ID and name and contains data 1,A 2,B 3,C 2nd table EmpSal has 2 columns ID and Salary Contains data -1,1000 2,5000 3,3000 Find name of employee having maximum salary ?
how many bits ip address consist of? : Sql server database administration
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
What are constraints? Explain different types of constraints?
26 Answers Emsang, Kendriya Vidyalaya(Kvs), Polaris, Wipro,
how to invoke a trigger on demand? : Sql server database administration
What is 1nf 2nf and 3nf?
What is sql profiler. What are the default templates with it? : sql server database administration
Where are sql server user names and passwords stored in sql server?
What do you mean by an execution plan? How would you view it?
-
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)
