Parameter Sizing

Provides intelligent code completion for SQL Server editors.

Moderators: David Atkinson, Anu Deshpande, Luke Jefferson, Paul Stephenson

Parameter Sizing

Postby warthenr » Tue Sep 21, 2010 2:39 pm

Along with the unused variables, it would be great to have the script check if all the variable sizes are large enough to hold the results. For example given the following

Table A
(
B varchar (20)
)

Declare @bvar varchar(10)

select top 1 @bvar = B from A

It would show an error for bvar since bvar is not large enough to hold the results of column B.
warthenr
 
Posts: 14
Joined: Tue Oct 02, 2007 3:28 pm

Return to SQL Prompt 5 EAP

Who is online

Users browsing this forum: No registered users and 0 guests

cron