February 16, 2019 at 11:17 am
Comments posted to this topic are about the item Stored Procedure Parameters
February 17, 2019 at 11:40 pm
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”
February 18, 2019 at 12:03 am
Good question, thanks Steve.
...
February 18, 2019 at 6:31 am
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
February 18, 2019 at 7:11 am
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/
February 18, 2019 at 8:25 am
The real question is at what point do you have to consider you're seriously doing something wrong design wise?
February 18, 2019 at 9:12 am
ZZartin - Monday, February 18, 2019 8:25 AMThe real question is at what point do you have to consider you're seriously doing something wrong design wise?
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
February 18, 2019 at 10:21 pm
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 🙂
February 20, 2019 at 4:34 am
Steve Jones - SSC Editor - Saturday, February 16, 2019 11:17 AMComments posted to this topic are about the item Stored Procedure Parameters
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-2017
Any technical explanation behind "2100".
ThanksSaurabh.D
February 20, 2019 at 7:54 am
Saurabh.D - Wednesday, February 20, 2019 4:34 AMSteve Jones - SSC Editor - Saturday, February 16, 2019 11:17 AMComments posted to this topic are about the item Stored Procedure ParametersI 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".
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/
February 26, 2019 at 3:08 pm
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