Parameter Size in Stored Procedures

• snoop123

  SSC Veteran

  Points: 228

  More actions

  February 11, 2011 at 10:32 am

  #234344

  Hi All,

  I have few stored procedures in my server which were developed long back .I found few stored procedure parameters whose data type(Size ) is not equal to the data type size in the column.

  Will this have any performance issues?

  Example: per say my Table1 (Name varchar(32),Address(64))

  But the stored procedure: create procedure @name varchar (16), @Address varchar(32)

  Does using less data type size have any effect on the performance issues (Hash Collisions?)

  Thanks in Advance.

• GSquared

  SSC Guru

  Points: 260824

  More actions

  February 11, 2011 at 10:34 am

  #1285811

  Please don't double-post in multiple forums on the same site.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon