²©¿ÍµÇ¼
Óû§Ãû£º
ÃÜ¡¡Â룺
×¢²á
|
怬
Íü¼ÇÃÜÂ룿
51ctoÊ×Ò³
|
²©¿Í
|
ÂÛ̳
|
ÕÐÆ¸
ÈȵãÎÄÕÂ
IB¿Í×ùÖ÷±à(ËÄ)ÃÀ¹úÎ÷Ãɹ«..
¡¡
°ïÖú
×ªÔØ
:58
·Òë
:0
Ô´´
:7
C#.NET
http://C.blog.51cto.com
>
¸´ÖÆÁ´½Ó
ÑûÇë¼ÓÈë¼¼ÊõȦ
¼ÓÓÑÇéÁ´½Ó
·¢¶ÌÏûÏ¢
Ïà²á
¼¼ÊõȦ
²©¿Í
²©¿Í£º
ÎҵIJ©¿Í
|
·¢±íÎÄÕÂ
|
¹ÜÀí²©¿Í
|
Í˳ö
Ïà²á£º
ÎÒµÄÏà²á
|
ÉÏ´«Í¼Æ¬
|
×î½ü¸üÐÂÏà²á
¼¼ÊõȦ£º
´´½¨¼¼ÊõȦ
|
ÎÒ¼ÓÈëµÄȦ
|
ËÑË÷Ȧ
51ctoÊ×Ò³
²©¿ÍÊ×Ò³
¼¼ÊõÂÛ̳
ÕÐÆ¸ÆµµÀ
¡¡
Ê×Ò³
|
C#.Net
|
SQLServer
|
ºúÑÔÂÒÓï
|
»ù´¡ÖªÊ¶
|
¿ª·¢ÊÖ¼Ç
C#.NET µÄBLOG
²©¿Íͳ¼ÆÐÅÏ¢
Óû§Ãû£ºC#.NET
ÎÄÕÂÊý£º65
ÆÀÂÛÊý£º85
·ÃÎÊÁ¿£º156546
ÎÞÓDZңº
1831
²©¿Í»ý·Ö£º
1829
²©¿ÍµÈ¼¶£º
6
×¢²áÈÕÆÚ£º2005-12-06
ÓÑÇéÁ´½Ó
51CTO²©¿Í¿ª·¢
51CTOÍÆ¼ö²©¿Í
DZÁú
cince
coinking
struggle1=1
cownew
javafans8171
dufei
david_yeung
piluge
±±¾©¿´¿´
mk6yeung
ÖìÂÉçâ
ѧϰ×ÊÁÏ
Msdn Library
Gotdotnet.Com
CSharpHelp.Com
Asp.Net
×óÁÚÓÒÉá
Microsoft
CSCode.com
ÎÄÕÂ
ÎÄÕÂÁбí>>
SQLSERVERÖеÄÈ«½ÇºÍ°ë½Ç
2006-01-19 23:08:28
È«½Ç×Ö·ûºÍ°ë½Ç×Ö·û¶¼ÄÜͨ¹ýSQL SERVERµÄÌõ¼þÅжϡ£
ÀýÈ磺
select * from t_xtgl_user where user_code = 'lyy'¡¡¡¡¡¡(°ë½Ç)
select * from t_xtgl_user where user_code = '£ì£ù£ù' (È«½Ç)
ÉÏÃæÁ½¸ö»°¶¼Äܲ鵽user_codeΪ'LYY'µÄÓû§ÐÅÏ¢¡£
¶øÈ«½Ç×Ö·û¼ÇÔØÈëÊý¾Ý¿âºó£¬¶Ô³ÌÐòºóÃæµÄ×Ö·ûÅжϺͱȽÏÈÝÒײúÉú»ìÂÒ£¬ÌرðÊÇÓëÆäËüÊý¾Ý¿â½»²æ»ìÓã¬Ôì³ÉÒâÏò²»µ½µÄÂé·³¡£
¶ÔÓÚÕâÖÖÇé¿ö£¬ÎÒÃÇ¿ÉÒÔ²ÉÈ¡Á½ÖÖ·½Ê½£º
1¡¢½ûֹʹÓÃÈ«½Ç£¬µ±Óû§Ê¹ÓÃÈ«½Ç×Ö·ûʱ£¬ÌáʾÓû§ÊäÈë·Ç·¨×Ö·û(È«½Ç)£¬ÌáʾÓû§ÖØÐÂÊäÈë¡£
2¡¢ÔÊÐíʹÓÃÈ«½Ç£¬µ±Óû§Ê..
Àà±ð£ºSQLServer
|
ÔĶÁÈ«ÎÄ(1342)
|
»Ø¸´(2)
SQLÓï¾äÐÔÄܵ÷ÕûÔÔò
2006-01-11 14:30:19
SQLÓï¾ä±àдעÒâÎÊÌâ
SQLÓï¾äÐÔÄܵ÷ÕûÔÔò [ ×÷Õß: ʯæçòW ]
Ò»¡¢ÎÊÌâµÄÌá³ö
ÔÚÓ¦ÓÃϵͳ¿ª·¢³õÆÚ£¬ÓÉÓÚ¿ª·¢Êý¾Ý¿âÊý¾Ý±È½ÏÉÙ£¬¶ÔÓÚ²éѯSQLÓï¾ä£¬¸´ÔÓÊÓͼµÄµÄ±àдµÈÌå»á²»³öSQLÓï¾ä¸÷ÖÖд·¨µÄÐÔÄÜÓÅÁÓ£¬µ«ÊÇÈç¹û½«Ó¦ÓÃϵͳÌύʵ¼ÊÓ¦Óúó£¬Ëæ×ÅÊý¾Ý¿âÖÐÊý¾ÝµÄÔö¼Ó£¬ÏµÍ³µÄÏìÓ¦ËٶȾͳÉΪĿǰϵͳÐèÒª½â¾öµÄ×îÖ÷ÒªµÄÎÊÌâÖ®Ò»¡£ÏµÍ³ÓÅ»¯ÖÐÒ»¸öºÜÖØÒªµÄ·½Ãæ¾ÍÊÇSQLÓï¾äµÄÓÅ»¯¡£¶ÔÓÚº£Á¿Êý¾Ý£¬ÁÓÖÊSQLÓï¾äºÍÓÅÖÊSQLÓï¾äÖ®¼äµÄËٶȲî±ð¿ÉÒÔ´ïµ½Éϰٱ¶£¬¿É¼û¶ÔÓÚÒ»¸öϵͳ²»ÊǼòµ¥µØÄÜʵÏ֯书ÄܾͿɣ¬¶øÊÇҪд³ö¸ßÖÊÁ¿µÄSQLÓï¾ä£¬Ìá¸ßϵͳµÄ¿..
Àà±ð£ºSQLServer
|
ÔĶÁÈ«ÎÄ(1342)
|
»Ø¸´(0)
SQLÓï¾äÔÓ¼Ç(¶þ)
2006-01-10 16:21:38
--Óï ¾ä¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¹¦ ÄÜ
--Êý¾Ý²Ù×÷
SELECT¡¡¡¡¡¡--´ÓÊý¾Ý¿â±íÖмìË÷Êý¾ÝÐкÍÁÐ
INSERT¡¡¡¡¡¡--ÏòÊý¾Ý¿â±íÌí¼ÓÐÂÊý¾ÝÐÐ
DELETE¡¡¡¡¡¡--´ÓÊý¾Ý¿â±íÖÐɾ³ýÊý¾ÝÐÐ
UPDATE¡¡¡¡¡¡--¸üÐÂÊý¾Ý¿â±íÖеÄÊý¾Ý
--Êý¾Ý¶¨Òå
CREATE TABLE¡¡¡¡--´´½¨Ò»¸öÊý¾Ý¿â±í
DROP TABLE¡¡¡¡ --´ÓÊý¾Ý¿âÖÐɾ³ý±í
ALTER TABLE¡¡¡¡ --ÐÞ¸ÄÊý¾Ý¿â±í½á¹¹
CREATE VIEW¡¡¡¡ --´´½¨Ò»¸öÊÓͼ
DROP VIEW¡¡¡¡ --´ÓÊý¾Ý¿âÖÐɾ³ýÊÓͼ
CREATE INDEX¡¡¡¡--ΪÊý¾Ý¿â±í´´½¨Ò»¸öË÷Òý
DROP INDEX¡¡¡¡ --´ÓÊý¾Ý¿âÖÐɾ³ýË÷Òý
CREATE PROCEDURE¡¡ --´´½¨Ò»¸ö´æ..
Àà±ð£ºSQLServer
|
ÔĶÁÈ«ÎÄ(1214)
|
»Ø¸´(0)
SQLÓï¾äÔÓ¼Ç
2006-01-10 16:04:17
1.°´ÐÕÊϱʻÅÅÐò:
Select * From TableName Order By CustomerName Collate Chinese_PRC_Stroke_ci_as 2.Êý¾Ý¿â¼ÓÃÜ:
select encrypt('ÔʼÃÜÂë')
select pwdencrypt('ÔʼÃÜÂë')
select pwdcompare('ÔʼÃÜÂë','¼ÓÃܺóÃÜÂë') = 1--Ïàͬ£»·ñÔò²»Ïàͬ3.È¡»Ø±íÖÐ×Ö¶Î:
declare @list varchar(1000),@sql nvarchar(1000)
select @list=@list+','+b.name from sysobjects a,syscolumns b where a.id=b.id and a.name='±íA'
set @sql='select '+right(@list,len(@list)-1)+' from ±íA'
exec (@sql)4.²é¿´Ó²ÅÌ·ÖÇø:
EXEC master..xp_fixe..
Àà±ð£ºSQLServer
|
ÔĶÁÈ«ÎÄ(1044)
|
»Ø¸´(0)
ÈÈÃÅÎÄÕÂ
VS.Net 2005 ÖÐÎÄÕýʽ°æÏÂÔØ
ÔÚASP.NETÖÐʹÓÃSession..
C#½éÉÜ
ÔÙ·¢Ãâ·Ñ²¦´òÊÖ»ú¹Ì¶¨µç..
ASPÊý¾Ý¿âÁ¬½Ó×Ö·û´®´óÈ«
AspxÒ³ÃæjavascriptµÄ¼¸..
Ãâ·Ñ°Î´ò¹úÄÚ¹ú¼Êµç»°¿Í..
¸ß¼¶³ÌÐòÔ±ÃæÊÔ
×îÐÂÆÀÂÛ
СÍõ
£º
ÎÄÕºܲ»´í£¬Ò²»¶Ó²©Ö÷·ÃÎÊÎҵļ¼..
[ÄäÃû]guozf@163.com£º
ÐòÁкŸù±¾²»ÄÜÓÃ
[ÄäÃû]lxny£º
ת£ºSqlserver È«½Ç/°ë½Çת»» ----..
[ÄäÃû]lxny£º
¿ÉÒÔ¼Ó²ÎÊýcollate Chinese_PRC_CS_..
[ÄäÃû]sds£º
sadfsad
51CTOÍÆ¼ö²©ÎÄ
¸ü¶à..
linuxÍøÂçÅäÖᢲâÊÔ¼°¹ÊÕÏ..
ÓÃÖÇÄÜ¿¨¹¹½¨Éí·ÝÑéÖ¤µÄÂí..
RHEL5ϵÁÐÖ®Èý:GNOME×ÀÃæµÄ..
windows Ⱥ¼¯ÕûÀíÆª£¨Ò»£©
Ïê½âjavaÖеÄthis¹Ø¼ü×Ö
iBatis2ѧϰ±Ê¼Ç£ºÓëSpring..
PL/SQLÖÐORA-00942´íµÄ½øÒ»..
iBatis2ѧϰ±Ê¼Ç£º»ù±¾ÔÀí..
½ÌÄã°ÑÎÕ°ÂÔËÉÌ»ú
SOAϵͳµÄ½¨Éè
½«ITÍøÂçÔËά¹ÜÀí½øÐе½µ×
dz̸ÇÀ×¢°ÂÔ˹ھüÓòÃûµÄÎÊÌâ
ÎÒµÄIT֮·
°ÂÔ˽¡¶ùÃÇ ÓÀԶΪÄãÃǼÓÓÍ£¡
ϵͳ·ÖÎöʦͨ¹ý×ܽá
ÎÒºöÈ»ÏëÃ÷°×ÁËΪʲôÁõÏè..