SQL 2008 Çå³ýÈÕÖ¾Îļþ
ÓÒ»÷ÒªÇå³ýÈÕÖ¾µÄÊý¾Ý¿â Ñ¡ÔñÊôÐÔ
ÔÚÊý¾Ý¿âÊôÐÔÖÐ Ñ¡ÔñÑ¡Ïî ÔÚÓұ߻ָ´Ä£Ê½ÏÂÀÁбí¿òÖÐ Ñ¡Ôñ¼òµ¥ µ¥»÷È·¶¨ ·µ»Ø
ÓÒ»÷ÒªÇå³ýÈÕÖ¾µÄÊý¾Ý¿â Ñ¡ÔñÈÎÎñ-ÊÕËõ-Êý¾Ý¿â µ¥»÷È·¶¨
Íê³ÉÊÕËõ ÈÕÖ¾Îļþ´óС±äΪ0
Ïà¹ØÎĵµ£º
ÎÒÃÇÒª½¨Á¢¶à¼¶¹ØÏµ£¬Ê×ÏÈÐèÒªÁ½¸ö±í.
µÚÒ»¸ö±í±íʾֱÊô½á¹¹£¬±ÈÈç˵ÎÒÃǹ«Ë¾ÓÐÒ»¸ö²¿ÃÅ¡£¶øÕâ¸ö²¿ÃÅÏ»¹ÓÐ3¸öС×飬ÄÇô3¸öС×éÊôÓÚÕâ¸ö²¿ÃÅ.µÚ¶þ¸ö±í±íʾ¶à²ã½á¹¹,¾ÍÏóµÚÒ»±íÀïÃæËù±íʾµÄ£¬ÕâÈý¸öС×éͬʱ»¹ÊôÓÚ¹«Ë¾.¶øÕâ¸ö¹«Ë¾Í¬Ê±ÊôÓÚÕâ3¸öС×éµÄ¸¸¼¶µÄ¸¸¼¶µÄ²¿ÃÅ¡£¼ÙÈçÎÒ ......
-- Ò»£º ´¦Àíδ²éµ½µÄ¿ÕÖµ
select
case when exists(select EndPrice from T_stock where BOMSN='0109')
then (select EndPrice from T_stock where BOMSN='0109')
else 0 end
--¶þ£º¸üÐÂ×Ö¶ÎÖµ
--strNum ÊýÁ¿
--strId ÐòºÅ
update T_buy_Pro set Co ......
µÚÒ»£ºÒªÉèÖÃSQL ServerµÄTCP/IP·þÎñ
1) ´ò¿ªSQL Server Configuration Manager”,Ë«»÷“SQL Server 2005ÍøÂçÅäÖÔ£¬µã»÷“*** µÄÐÒé” (×¢Ò⣺***´ú±íʵÀýÃüÃû£¬ÀýÈ磺accpDBµÄÐÒé)
2) Ñ¡ÔñÓұߴ°¿ÚÖеēTCP/IP”ÐÒ飬ÓÒ¼üµ ......
ʹÓÃSQLÓï¾ä´´½¨Êý¾Ý¿â
±¾ÎÄת×Ô£ºhttp://www.cppblog.com/twzheng/archive/2008/07/07/55508.html
ÓÃCREATE DATABASE´´½¨Êý¾Ý¿âµÄÓï·¨¸ñʽ£º
CREATE DATABASE database_name /*Ö¸¶¨Êý¾Ý¿âÃû*/
[ON× ......