[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.sqlserver.programming

PROBLEM IN A QUERY

santiago

3/28/2007 8:36:00 AM

I WAS TRYING TO RUN A QUERY GIVEN BELOW TO GET ALL THE CUSTOMERIDs IN
A COMMA SEPRATED LIST
--------------------------------------
DECLARE @CID AS VARCHAR(8000)
SET @CID =''

SELECT @CID=@CID+ CUSTOMERID + ',' FROM CUSTOMERS
PRINT @CID

SELECT LEN(@CID)

OUTPUT =546
----------------------------------------

BUT I WAS ONLY ABLE TO GET 546 CHARACTERS .

ALL THE CUSTOMER IDS WERE NOT PRESENT IN THE LIST.

I CANNOT UNDERSTAND THE REASON FOR IT. PLZ HELP
3 Answers

Uri Dimant

3/28/2007 8:49:00 AM

0

Is it SQL Server 2005?
If you have CustomerID =NULL you get nothing, check it out. Do you run it
from QA?
By default as I remember QA shows 255 characters , go to
Tools ---Options--Results Tab to change the value







"santiago" <paramvir.deol@gmail.com> wrote in message
news:1175070941.720662.40140@y80g2000hsf.googlegroups.com...
>I WAS TRYING TO RUN A QUERY GIVEN BELOW TO GET ALL THE CUSTOMERIDs IN
> A COMMA SEPRATED LIST
> --------------------------------------
> DECLARE @CID AS VARCHAR(8000)
> SET @CID =''
>
> SELECT @CID=@CID+ CUSTOMERID + ',' FROM CUSTOMERS
> PRINT @CID
>
> SELECT LEN(@CID)
>
> OUTPUT =546
> ----------------------------------------
>
> BUT I WAS ONLY ABLE TO GET 546 CHARACTERS .
>
> ALL THE CUSTOMER IDS WERE NOT PRESENT IN THE LIST.
>
> I CANNOT UNDERSTAND THE REASON FOR IT. PLZ HELP
>


masri999

3/28/2007 9:47:00 AM

0

On Mar 28, 1:35 pm, "santiago" <paramvir.d...@gmail.com> wrote:
> I WAS TRYING TO RUN A QUERY GIVEN BELOW TO GET ALL THE CUSTOMERIDs IN
> A COMMA SEPRATED LIST
> --------------------------------------
> DECLARE @CID AS VARCHAR(8000)
> SET @CID =''
>
> SELECT @CID=@CID+ CUSTOMERID + ',' FROM CUSTOMERS
> PRINT @CID
>
> SELECT LEN(@CID)
>
> OUTPUT =546
> ----------------------------------------
>
> BUT I WAS ONLY ABLE TO GET 546 CHARACTERS .
>
> ALL THE CUSTOMER IDS WERE NOT PRESENT IN THE LIST.
>
> I CANNOT UNDERSTAND THE REASON FOR IT. PLZ HELP

What is the out put of PRINT @CID ?
TRY DATALENGTH(@CID)

Anith Sen

3/29/2007 9:45:00 PM

0

Apart from the issue with the characters, you may also want to check the SQL
statement you are using. It uses an invalid syntax, undocumented and risky
to use in production mode systems.

--
Anith