Prevent Text, nText, Image DataTypes Friday, Nov 16 2007 

Actually I was happy when I found how to append characters in text data type, but It doesn’t solve the problem. I have told by Gary that Text, nText, and Image data type will be removed from SQLServer data type in the future. The replacements are max specifier in varchar, nvarchar, and varbinary data type. For example, varchar(max) to replace text, nvarchar(max) to replace ntext and varbinary(max) to replace image. I also have checked it, varchar(max) has the same maximum characters as text data type. They only could save less than 2^31 character. If you want to check it too, you could check it by below codes.

(2^31 is 2,147,483,648 )

Declare @Parm1 varchar(max)
select @Parm1 = replicate(‘a’, 2147483647)
select @Parm1

If you specify the number of replicated strings the same as 2^31, you’ll get the following error.

Arithmetic overflow error converting expression to data type int.

So, if you ask me what SQLServer data type which has undefined number of characters, I will answer you they don’t have. ngupil

scholar google Friday, Nov 16 2007 

Google ternyata sudah meluncurkan sarana untuk mencari jurnal :) Ga tau sayanya yg ketinggalan atau gimana, tapi sangat terbantu sekali. Saya kebetulan sedang mencari jurnalnya Coppersmith & Winograd tentang algoritma tercepat untuk perkalian matriks. Setelah saya cari di citeseer, saya tidak ketemu juga, kemudian saya berpindah ke portal dan situs” lainnya termasuk IEEExplorer, saya harus bayar ternyata :( .

(more…)