Stored Procedure Parameters
-
Comments posted to this topic are about the item Stored Procedure Parameters
-
Nice, easy one to start the week on, thanks, Steve
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex” -
Good question, thanks Steve.
...
-
good to know however i hope i never have to push those limits
---------------------------------------------------------------------------------------
The more you know, the more you know that you dont know -
AKA - "Way more than anybody should ever even consider!!!".
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/ -
The real question is at what point do you have to consider you're seriously doing something wrong design wise?
- ZZartin - Monday, February 18, 2019 8:25 AM
Lol perhaps at parameter 1025
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html -
Good to know, but I think if I need more than 10, I'm gong to pass an array or memory table or pretty much anything else
- Steve Jones - SSC Editor - Saturday, February 16, 2019 11:17 AM
I got it right! But I didn't see any reference on
https://docs.microsoft.com/en-us/sql/t-sql/statements/create-procedure-transact-sql?view=sql-server-2017Any technical explanation behind "2100".
ThanksSaurabh.D
- Saurabh.D - Wednesday, February 20, 2019 4:34 AM
It is right there near the top.
One or more parameters can be declared; the maximum is 2,100.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/ -
I don't want to have to optimize the proc that meets that limit. Nope. Just...Nope.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply