According to SQL Server 2000 Books Online:data_typeIs any system-supplied or user-defined data type. A variable cannot be of text, ntext, or image data type. For more information about system data types, see Data Types. For more information about user-defined data types, see sp_addtype.but you can try1.
DECLARE @Var1 varchar( 8000 ), @Var2 varchar( 8000 )
SELECT @Var1 = SUBSTRING( t.txtCol, ( 0 * 8000 ) + 1, 8000 ),
@Var2 = SUBSTRING( t.txtCol, ( 1 * 8000 ) + 1, 8000 )
FROM tbl AS tor2. do it in your application
DECLARE @Var1 varchar( 8000 ), @Var2 varchar( 8000 )
SELECT @Var1 = SUBSTRING( t.txtCol, ( 0 * 8000 ) + 1, 8000 ),
@Var2 = SUBSTRING( t.txtCol, ( 1 * 8000 ) + 1, 8000 )
FROM tbl AS tor2. do it in your application
解决方案 »
免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货