¹úÍâ¿Õ¼äSqlÊý¾ÝÂÒÂëÎÊÌâ
¹úÍâ¿Õ¼äòËƶÔÖÐÎıȽϸÐð Èç¹ûÊý¾ÝÀàÐÍÉè¼ÆΪ varchar ÀàÐ͵Ļ° ´æ´¢µÄÊý¾Ý»ù±¾ÉÏÊÇ "£¿£¿£¿£¿"
ºÜ¼òµ¥ ½« varchar ÀàÐÍ Éè¼ÆΪ nvarchar ÀàÐÍ
create table cs
(
txt1 nvarchar(50) null
)
insert into cs (txt1 ) values ('²âÊÔ') -- Èë¿âʱÊý¾Ýʱ £¿£¿£¿£¿
insert into cs (txt1) values (N'²âÊÔ') -- »ù±¾ÉϾͽâ¾öÁËÎÊÌâ
Èç¹ûÍøÕ¾ Ìí¼ÓÊý¾ÝµÄ»° ÓòÎÊý²éѯ»ù±¾ÉÏÊÐûÓÐÎÊÌâµÄ
ÆäËûµÄÎÒûÓÐÊÔ£¡
²»Ò»¶¨È«²¿ÓÐÓã¡
Ïà¹ØÎĵµ£º
Ò»¸öʾÀýËÀËø
ÈÃÎÒÃÇ´ÓÕâÑùÒ»¸öʾÀý¿ªÊ¼ËµÆð£¬ËüÔÚ SQL Server 2000 ºÍ 2005 Öж¼ÄÜÒýÆðËÀËø¡£ÔÚ±¾ÎÄÖУ¬ÎÒʹÓà SQL Server 2005 µÄ×îРCTP£¨ÉçÇø¼¼ÊõÔ¤ÀÀ£¬Community Technology Preview£©°æ±¾£¬SQL Server 2005 Beta 2£¨7 Ô·¢²¼£©Ò²Í¬ÑùÊÊÓá£Èç¹ûÄúûÓÐ Beta 2 »ò×îÐ嵀 CTP °æ±¾£¬ÇëÏÂÔØ SQL Server 2005 Express µÄ ......
*¸ø¶à¸ö±äÁ¿¸³Öµ
functionÖ»ÄÜʹÓÃ
set (a,b,c)=(select a,b,c from #);
procedureÖ»ÄÜʹÓÃ
select a,b,c into a,b,c from #
*functionÎÞ·¨Ç¶Ì×µ÷ÓôøÓÐinout»òout²ÎÊýµÄprocedure£¬ÏÖÏóΪ£ºÎÞ·¨´´½¨¡£
½ñÌìµÄ½øÕ¹½áÂÛÊÇ£º
function¿ÉÒÔµ÷ÓÃÈκÎprocedure£¬µ«±ØÐëÉùÃ÷Ϊmodifies sql data£¬Í¬Ê±±ØÐë·µ»Øtable ......
²¿ÃŽṹ
Id name parentId
-----------------
1 ÈËʲ¿ 0
2
¿ª·¢²¿ 1
3 ·þÎñ²¿ 1
Óû§½á¹¹
Id name departId
--------------------
101
ÕÅÈý 2
102 ÀîËÄ 2
103 ÍõÎå 3
ÏëµÃµ½
ID name
parentId
-------------------
1 ÈËʲ¿ 0
2 ¿ª·¢²¿ 1
101
ÕÅ ......
ʹÓÃHIBERNATEµÄSQL²éѯ²¢½«½á¹û¼¯×Ô¶¯×ª»»³ÉPOJO
ÎÄÕ·ÖÀà:Java±à³Ì
ÔÚijЩ³¡ºÏÏ£¬ÎÒÃÇ¿ÉÄÜÏëʹÓÃHIBERNATEµÄ¿ò¼ÜÌṩµÄSQL²éѯ½Ó¿Ú£¬Õâʱ£¬ÓÉÓÚ±íºÍʵÌ嶼¿ÉÄÜûÓÐ×öÓ³É䣬HIBERNATE²»Äܰѽá¹û¼¯×ª»»
³ÉÄãÏëÒªµÄList<POJO>£¬±¾ÎÄÌÖÂÛÈçºÎÔÚÕâÖÖÇé¿öÏÂÈÃHIBERNATEÖ±½Ó·µ»ØÄãÏëµÄ½ ......
Àí½âSQL SERVERÖÐËùÓÐÕߺͼܹ¹µÄÇø±ð
SQL SERVER2005½éÉÜÁ˼ܹ¹£¬¼Ü¹¹Ïà¶ÔÓÚÒÔÇ°°æ±¾ÖеĶÔÏóËùÓÐÕß¡£±¾ÎĽ«½âÊÍÕâÁ½ÕßµÄÇø±ð£¬²¢Ï£ÍûÄܽ⿪ÄãÖÁ½ñÈԶԼܹ¹Ò»µãÀ§»ó¡£
¶ÔÏóËùÓÐÕß
ÒªÀí½âËùÓÐÕߺͼܹ¹Ö®¼äµÄÇø±ð£¬ÈÃÎÒÃÇÏÈ»¨µãʱ¼äÀ´¸´Ï°Ò»Ï¶ÔÏóµÄËùÓÐȨ¡£ÔÚSQL SERVER2000»òÒÔÇ°°æ±¾Öд´½¨Ò»¸ö¶ÔÏ󣬶ÔÏó±ØÐëÒªÓÐÒ»¸öËù ......