I watch necessarily your article

As long as that found here is such a decision :

------------------------------------------------------

create table #customers (

id int,

customer varchar(50)

)

insert into #customers values (1,'John')

insert into #customers values (2,'Lyss')

insert into...

How to convert the output of the query to string:

---------------------------------------------------------------------

/*create table #customers (

id int,

customer varchar(50)

)

insert into #customers values (1,'John')

insert into #customers values (2,'Lyss')

insert into #customers values (3,'Jack')

insert into #customers values...

When querying A

(SQLServer2005, SQLServer2005_SSMSEE) displays:

"

<customers><customers id="6"><customers customer="Victoria"/>

</customers><customers id="2"><customers customer="Lyss"/>

</customers><customers id="1"><customers customer="John"/>

</customers><customers id="3"><customers customer="Jack"/>

</customers><customer

"

This may be the result of installation of incomplete version

(SQLServer2005, SQLServer2005_SSMSEE)

What Kit you can recommend?

This will not help. I need to buy a new computer.

SELECT id as 'data()',

customer as 'data()'

FROM #customers AS customesra

ORDER BY customer DESC

FOR XML PATH(''),ROOT('customers')

I cannot view the full XML string.

Originally the question was a breadboard model of the program,

Instead of about a ready product.

Some features of work of a breadboard model are found out.

On seen sql2008 with c# is...

Meanwhile I shall not understand in what here put.

Originally worked stably.

Originally the question was a breadboard model of the program,

Instead of about a ready product.

Some features of work of a...

Much seems wild when you collide(face) for the first time

Have You it in view of?

/*use master --model ...

------------------------ In more detail -------------------------------

/*

use model

IF OBJECT_ID('mytest') IS NOT NULL

DROP TABLE dbo.mytest

CREATE TABLE...

declare @a numeric(13,8)

declare @b-2 numeric(13,8)

set @a=100

set @b-2=1000

select cast(@a*@b as numeric(14,8))

declare @var char, @C char

set @C = 'I'

set @var = 'E'

if (ascii(@c) ascii('I')) OR (ascii(@var) ascii('E'))

begin

select 'not OK'

end

else

...

Hi

-- ...

As that so

DECLARE @pcx TABLE(code int, model varchar(50))

INSERT INTO @pcx VALUES (1,1111)

INSERT INTO @pcx VALUES (2,2222)

INSERT INTO @pcx VALUES (3,3333)

INSERT INTO @pcx VALUES (4,1111)

INSERT INTO @pcx VALUES (5,3333)

DECLARE ...

Thank Lynn.

Copy query take advantage SQL Management Studio

and will see the data.

Probably, itself I shall execute this query.

I think, that on a forum should be present the standard test...