Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
multiplex77
Starting Member
24 Posts |
 Posted - 2007-02-25 : 22:18:40
|
| Hi all,I read that ntext is deprecated in SQL 2005 and that nvarchar(max) should be used instead. But will nvarchar(max) work on a SQL 2000 database? I can't seem to find the answer on the web. Thanks for the help. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-02-25 : 22:19:51
|
no. this is not available in SQL 2000.
KH |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-02-25 : 22:43:48
|
| ntext is still available in v2005 but it is advised to use nvarchar(max).The intention is to drop it - but ms have said that about other things which are still there.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-02-26 : 06:11:51
|
| Is "ntext" less ANSI than nvarchar(max)? |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-02-26 : 06:16:48
|
| I don't think ansi has a blob datatype. It has a varchar so I guess nvarchar(max) would be considered more standard.Think ansi isn't keeping up with extensions now so it's not really an issue (except using the ansi coalesce rather than the non standard isnull of course)..==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-02-26 : 06:29:53
|
| Thanks Nigel. It just seems to me that ntext() has been around for a while, and would have done fine as a datatype, and "nvarchar(max)" is just the sort of thing that a programmer would dream up on the spur of the moment and 10 years later folk will be saying "Who on earth came up with that"!Kristen |
|
|
|
|
|
|
Can I use nvarchar(max) in SQL 2000?