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 ʱ¼ä¶Î²éѯ¡£
==========================================
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 ......
°Ñ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.µ½ÆóÒµ¹ÜÀíÆ÷£¬ÕÒµ½ Êý¾Ý¿â ££¡·ÓÒ¼ü££¡·ËùÓÐÈÎÎñ££¡ ......
µ±ÐÞ¸ÄÁ˵ǼÃÜÂëʱ£¬µ±Æô¶¯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 ......
Ò»¸ö¼òµ¥µÄСʵÀý¾ÍÃ÷°×~£¡
user±í
ÔÚÕâÕűíÖн¨Á¢´¥·¢Æ÷
Create trigger tiggername
on user
for delete
as
begin ......
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 ......