how many no of arguments can be passed in procedures and
functions
Answer Posted / ranjan&
According to MSDN--> A Function and Procedure can have a
maximum of 2,100 parameters.
| Is This Answer Correct ? | 13 Yes | 2 No |
Post New Answer View All Answers
How do I create a trace in sql server?
How do you improve the performance of a SQL Azure Database?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
What is difference between after and before?
Which joins are sql server default?
What are views used for?
What are different types of replication in sql server?
How do I find query history in sql server?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
Characterize join and name diverse sorts of joins?
What is transaction server auto commit?
Mention what are the core components of ssrs?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
When we should use and scope of @@identity?