sql server programming: SQL Server - SQL query variable -- sql server programming

SQL Server - SQL query variable

Mike
6/4/2005 8:45:10 PM

sql server programming:

Running SQL Server 2000 SP 3

I am trying build a SQL server query. See below for partial SQL:

SET @sExec = 'SELECT DISTINCT Price_Quote_Package.Price_Quote_Package_SID,
Price_Quote.Price_Quote_SID, Price_Quote_Package.Price_Quote_Package_Name,
Custom_Pricing_Customer_Registration.Customer_Name AS CustName,
Price_Quote_Package.Recorded_Existing_Customer_ID,
Price_Quote.VP_Approved_Flag, Price_Quote.Pricing_Analyst_ID,
Price_Quote.Recorded_Consol_Active_Order_Value '

When I run run the process to see what the @sExec variable contains, the
@sExec contains the foolowing:
'SELECT DISTINCT Price_Quote_Package.Price_Quote_Package_SID,
Price_Quote.Price_Quote_SID, Price_Quote_Package.Price_Quote_Package_Name,
Custom_Pricing_Customer_Registration.Customer_Name AS CustName, Pric

Is there a limitation with the @sExec variable or with the widow displaying
the variable?

Thanks.

Re: SQL Server - SQL query variable

Hari Prasad
6/5/2005 11:11:43 AM

Hi,

By default Query analyzer can display only 256 characters. This can be
changed
by giving a higher value , say 2500 or higher

In Query analyzer -> Tools menu -> Options -> Results -> Maximum Characters
Per Column -> click OK

After this execute the same query.

Thanks
Hari
SQL Server MVP

[quoted text, click to view]