Viewing 7 posts - 1 through 7 (of 7 total)
I don't know if it can help you, but instead of using for xml, on SQL 2000 you can format the html by using:
declare @tsql nvarchar(4000)
set @tsql=''
Select @tsql = @tsql...
May 31, 2016 at 7:09 am
Hi
This is the same that I posted, please see here:
like brian.healy had posted you can use xml
select SUBSTRING((SELECT (',' + id) FROM teste ORDER BY id FOR XML PATH('') ),...
September 28, 2012 at 3:16 am
Arnold Lieberman (7/19/2012)
stuff((select ',' + IDfrom teste
for XML path(''),TYPE).value('(./text())[1]','NVARCHAR(MAX)'
),
1,
1,
'')
This copes with any string length.
ok... i loved the for XML path.
The stuff it's...
July 19, 2012 at 9:23 am
nice, but lookout to the substring length, as i have to lookout for the nvarchar max length.
July 19, 2012 at 4:10 am
Thanks.
You are right.
Back to identity and do all the job not to show the id column without a mask.
July 3, 2012 at 10:28 am
I can't use a calculated field, must be only one column, and must be key.
I tested in 2 sessions 5000 inserts, each, without lock and I had 4000 errors
Then i...
July 3, 2012 at 9:50 am
I had the same problem.
I need to create custom ids for each table, it's a direct order from the boss.
Until know i got this function to format the IDs (i...
July 3, 2012 at 5:16 am
Viewing 7 posts - 1 through 7 (of 7 total)