Varchar, Varbinary, XML columns in YUkon

Question

Post reply

Varchar, Varbinary, XML columns in YUkon

Kishore-132325

Hall of Fame

Points: 3784
More actions
April 19, 2005 at 1:25 am

#85537

Hi Folks,
SQL Server 2005 is cuming with new datatypes :
Varchar(max), varbinary(max) and XML. I do a product testing for a comapny where I am asked to create sql scripts which will include these new datatypes in it with maximum limits. In Yukon they allow a max of 2GB for these varbinary and varchar.
What kind of data I can use to check these columns in Yukon. I have Yukon - Beta3 installed on my machine. Any thoughts ?
--Kishore

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 1

Just use a very long string for varchar(max). For instance:

DECLARE @Foo VARCHAR(MAX)

SET @Foo = REPLICATE('foo', 10000)

UPDATE dbo.foobar

SET varchar_max_column = @Foo

> I have Yukon - Beta3 installed on my machine.

There is no Beta 3 of SQL Server 2005, and apparantly there will never be. I assume you have the December-CTP (which said Beta 3 in some places, such as some splash screens). I would definately recommend downloading the April-CTP released yesterday and doing any testing with that.

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/