Parameter Sizing

Provides intelligent code completion for SQL Server editors.

Parameter Sizing

Postby warthenr » Tue Sep 21, 2010 1: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.
Posts: 14
Joined: Tue Oct 02, 2007 2:28 pm

Return to SQL Prompt 5 EAP

Who is online

Users browsing this forum: No registered users and 0 guests