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

vs.net Óë Sql server °²×°

ÔÚÏȰ²×°ÁËvs.net 2008 ºóÔõô°²×° Sql server 2005¡£ËÑÁ˺ܶàÎÄÕ£¬¿ÉÊÇ»¹ÊÇûÓп´µ½Ôõô²ÅÄܹ»°²×°ÉÏ¡£

×ÜÊÇÔÚ°²×°sql serverµÄ¿Í»§¶Ë£¨management studio£©Ê±ºò±¨´í£¬×°ÄǸöÊý¾Ý¿â server ÒýÇæµÄʱºòûÓÐÎÊÌâ¡£°Ñ.net frameworkÐ¶ÔØÁËÒ»ºó£¬»¹ÊÇ×°²»ÉÏ¡£ºÃÏñ˵ÒѰ²×°µÄ°æ±¾±È´ý°²×°µÄ°æ±¾¸ß£¬Éý¼¶Ê§°Ü¡£¸ã²»Çå³þµ½µ×ÒªÐ¶ÔØ×°vsʱºò×°µÄÄÇЩ×é¼þ¡£

ÓÐûÓиßÊÖ¸ø¸ö¿ÉÒÔÓõķ½°¸°¡£¬ÐèÒªÏÈÐ¶ÔØÄÇЩ¸ö×é¼þ£¡£¡Ð»ÁË
×î¼Ñ·½·¨¾ÍÊÇÐ¶ÔØvs.net 2008 È»ºó°²×°Sql server 2005 ÔÚ°²×°vs.net 2008 
ÒòΪÔÚvs.net 2008 ÀïÃæ¼¯³ÉÁËÐí¶àSql server ³ÌÐò ÊÖ¶¯Ð¶ÔØÂé·³

ÎÒµÄûÓгöÏÖ´ËÀàÎÊÌ⣡



ÖØ×öϵͳ¿´¿´

ÒýÓÃ
ÖØ×öϵͳ¿´¿´

ºÇºÇ ...ͦÎÞÓï



End_rbody_60319948//-->
¸Ã»Ø¸´ÓÚ2009-10-11 08:53:15±»¹ÜÀíԱɾ³ý



¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[0]
ÒýÓÃ
¾Ù±¨
¹ÜÀí
TOP








cedar_zhao
(cedar_zhao)

µÈ¡¡¼¶£º



#6Â¥ µÃ·Ö£º0»Ø¸´ÓÚ£º2009-10-10 21:54:47


Çë²é¿´ÄãµÄϵͳºÍsqlserver2005°æ±¾ÊÇ·ñ¼æÈÝ£¬xpÖ»Äܰ²×°¿ª·¢°æ±¾µÄ»òÕ߸öÈ˰汾µÄ
²»Äܰ²×°ÆóÒµ°æµÄ  server ¿ÉÒÔ°²×°ÆóÒµ°æµÄ

°²×°³ÌÐòÏȰ²×°µÍ°æ±¾µÄ£¬ºó°²×°¸ß°æ±¾µÄ£»Èç¹ûÊÇÏàͬ°æ±¾µÄ£¬ÏÖ×°VS£¬ÔÙ°²×°SQL¡£
Èç¹û°²×°³öÏÖÁËÎÊÌ⣬ֻÐèÒª´Ó×¢²á±íÖÐÐ¶ÔØ¶ÔÓ¦µÄ³ÌÐòµ½HKEY_CURRENT_USERºó¾Í¿ÉÒÔÖØÐ°²×°ÁË£¬Ð¶ÔØVSÐèÒª´óÁ¿Ê±¼ä£¬SQL¿ÉÒÔÈÌÊÜ£»Èç¹ûÊÇÐ¶ÔØVS£¬²»ÈçÖØÐ°²×°——Ì«·Ñʱ¼äÁË£¬³ý·ÇÊÇΪÁËѧϰÈçºÎÐ¶ÔØ¡£

jiefen

×°Íêvs£¬×°vs sp1£¬ÔÙ×°sql


Ïà¹ØÎÊ´ð£º

ÇóSQL£¿

´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e 
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......

SQLÓï¾äÎÊÌ⣬¸ßÊÖ°ïæ£¡£¡

½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿

21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......

sqlÎļþ£¨Êý¾Ýº¬ÖÐÎÄ£©DOSÃüÁî´°¿ÚÎÞ·¨µ¼ÈëÎÊÌâ

ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8

ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£

½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë

ÇëÎÊÎÊÌâÔÚÄÄ£¿
×°¸öÖÐÎÄÈí¼þ¼´¿É.

ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ ......

Sql È¡Êý¾ÝÎÊÌâ

declare @test table(
title varchar(100),--±êÌâ
num decimal(18,6), --ÊýÁ¿
unitqty decimal(18,6) --µ¥Î»
)
insert into @test values('a',100,50)
insert into @test values('b&# ......

PL/SQLÎÊÌâ

PL/SQLÀïÃæµÄTABLE---¡·QUERY½çÃæ

ÓÐSQL|OUTPUT|STATISTICSÈý¸öÒ³Ãæ

ΪʲôÎÒÔÚSQLÀïÃæÓÃSELECTÓï¾ä»òÕßUPDATEºó£¬OUTPUTºÍSTATISTICSÒ³Ãæ¶¼Ã»ÈκÎÊý¾Ý£¿

ÊÇҪʲôÇé¿öÏ£¬Õâ2¸öÒ³ÃæÒ²»áÓÐÊý¾Ý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ