asked
Question about parameters to a SP
I'm used to writing stored procedures like this: CREATE PROCEDURE MyProc @FirstName VARCHAR(50), @LastName VARCHAR(50) AS BEGIN --do stuff END But I've also seen this same code written like this: CREATE PROCEDURE MyProc ( @FirstName VARCHAR(50), @LastName VARCHAR(50) ) BEGIN --do stuff END Is it better to use paratheses, or not?
It makes no difference; it's purely a question of preference. Parentheses are required for functions, so some people find using them for procedures more consistent, but I really don't think it matters much at all. Go with whatever the coding standard at your current gig dictates.
