Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

sql ²éѯÌõ¼þ×Ö¶ÎΪtext»òntext µÄ½â¾ö·½°¸

sql ²éѯÌõ¼þ×Ö¶ÎΪtext»òntextµÃ½â¾ö·½°¸ÒÔ¼°varchar(max)¡¢nvarchar(max)
1¡¢ÔÚMS SQL2005¼°ÒÔÉϵİ汾ÖУ¬¼ÓÈë´óÖµÊý¾ÝÀàÐÍ£¨varchar(max)¡¢nvarchar(max)¡¢varbinary(max) £©¡£´óÖµÊý¾ÝÀàÐÍ×î¶à¿ÉÒÔ´æ´¢2^30-1¸ö×Ö½ÚµÄÊý¾Ý¡£
Õ⼸¸öÊý¾ÝÀàÐÍÔÚÐÐΪÉϺͽÏСµÄÊý¾ÝÀàÐÍ varchar¡¢nvarchar ºÍ varbinary Ïàͬ¡£
΢ÈíµÄ˵·¨ÊÇÓÃÕâ¸öÊý¾ÝÀàÐÍÀ´´úÌæÖ®Ç°µÄtext¡¢ntext ºÍ image Êý¾ÝÀàÐÍ£¬ËüÃÇÖ®¼äµÄ¶ÔÓ¦¹ØÏµÎª£º
varchar(max)-------text;
nvarchar(max)-----ntext;
varbinary(max)----image.
ÓÐÁË´óÖµÊý¾ÝÀàÐÍÖ®ºó£¬ÔÚ¶Ô´óÖµÊý¾Ý²Ù×÷µÄʱºòÒª±ÈÒÔǰÁé»îµÄ¶àÁË¡£±ÈÈ磺֮ǰtextÊDz»ÄÜÓÑlike’µÄ£¬ÓÐÁËvarchar(max)Ö®ºó¾ÍûÓÐÕâЩÎÊÌâÁË£¬ÒòΪvarchar(max)ÔÚÐÐΪÉϺÍvarchar(n)ÉÏÏàͬ£¬ËùÒÔ£¬¿ÉÒÔÓÃÔÚvarcahrµÄ¶¼¿ÉÒÔÓÃÔÚvarchar(max)ÉÏ¡£
 ËùÒÔÇëʹÓà varchar(max)¡¢nvarchar(max) ºÍ varbinary(max) Êý¾ÝÀàÐÍ£¬¶ø²»ÒªÊ¹Óà text¡¢ntext ºÍ image Êý¾ÝÀàÐÍ¡£
2¡¢Èç¹ûÐèÒª´¦ÀíÒѾ­´æÔÚµÄtextÀàÐÍ µÄ²éѯ ÔòÐèÒª½øÐÐ×Ö¶Îת»»Ï where cast(text as varchar)
3¡¢ÊµÀýÈçÏ£¬ÆäÖÐi_itemΪntext
select * from IP_Investigate
where I_InvestigateID in (select IS_ID from IP_InvestigateStatus
where IS_Name like 'tomcat%') and cast(i_item as varchar)='1'
update IP_Investigate
set i_order=5
where I_InvestigateID in (select IS_ID from IP_InvestigateStatus
where IS_Name like 'tomcat%') and cast(i_item as varchar)='5'


Ïà¹ØÎĵµ£º

Sql server ʱ¼ä¶Î²éѯ µÄÏà¹Ø·Ñ½âÎÊÌâ

sql server ʱ¼ä¶Î²éѯ¡£
==========================================
select g.borrowTime  from t_apartment_goodsborrow g
where g.borrowTime >= '2010-03-11 9:50:43'
2010-03-11 9:52:54
----------------------------------------------------------------------------
select g.borrowTime  ......

ÁíÀà¼òµ¥µÄSQLÊý¾Ý¿â¸ÄÃû·½·¨

°ÑOldÊý¾Ý¿â¸ÄΪNewÊý¾Ý¿â
1.´ò¿ª“ÆóÒµ¹ÜÀíÆ÷”ÕÒµ½ OldÊý¾Ý¿â£­£­¡·ÓÒ¼ü£­£­¡·ËùÓÐÈÎÎñ£­£­¡··ÖÀëÊý¾Ý¿â
2.µ½C:\Program Files\Microsoft SQL Server\MSSQL\DataÏÂÕÒµ½Old_Data.mdfºÍOld_log.ldf°ÑOld_Data»»³ÉÄãÏëÒªµÄÃû×ÖÀýÈçNew.mdf¡¢New.ldf
3.µ½ÆóÒµ¹ÜÀíÆ÷£¬ÕÒµ½ Êý¾Ý¿â £­£­¡·ÓÒ¼ü£­£­¡·ËùÓÐÈÎÎñ£­£­¡ ......

Sql service error 1069½â¾ö·½·¨

µ±ÐÞ¸ÄÁ˵ǼÃÜÂëʱ£¬µ±Æô¶¯mssqlserverµÄʱºò»á³öÏÖerror 1069, means logon error. ÕâÊÇÓÉÓÚÒ»ÏÂ2¸öÔ­Òò1.sqlserverµÄÃÜÂëûÓÐͬ²½µÄÔ­Òò£¬ÐèÒªÔÚadministrator tools ->services-> right click mssqlserver -> property-> logon tab -> change passward to new one . 2.sqlserverµÄÆô¶¯Óû§²»¶Ô£¬ÐèÒªÔÚa ......

SQL´¥·¢Æ÷

Ò»¸ö¼òµ¥µÄСʵÀý¾ÍÃ÷°×~£¡
 user±í
ÔÚÕâÕűíÖн¨Á¢´¥·¢Æ÷  
 Create   trigger   tiggername  
 on   user     
 for   delete     
 as   
 begin ......

Sql Server »ñµÃ¸÷ÖÖÐÎʽµÄÈÕÆÚ

SQL codeDECLARE @dt datetime
SET @dt=GETDATE()
DECLARE @number int
SET @number=3
--1£®Ö¸¶¨ÈÕÆÚ¸ÃÄêµÄµÚÒ»Ìì»ò×îºóÒ»Ìì
--A. ÄêµÄµÚÒ»Ìì
SELECT CONVERT(char(5),@dt,120)+'1-1'
--B. ÄêµÄ×îºóÒ»Ìì
SELECT CONVERT(char(5),@dt,120)+'12-31'
--2£®Ö¸¶¨ÈÕÆÚËùÔÚ¼¾¶ÈµÄµÚÒ»Ìì»ò×îºóÒ»Ìì
--A. ¼¾¶ÈµÄµÚÒ»Ìì
SE ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ