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

ÔÚSQL SERVERµÄ±íÖУ¬ÈçºÎʵÏÖ²¿·Ö¼Ç¼µÄ¸´ÖÆ£¿

ÏÖÓÐSQL SERVERµÄÊý¾Ý±í£¨SalesItem£©,SalestemÓÐÒÔÏÂ×Ö¶Î:¿Í»§±àºÅ£¬ÏîÄ¿±àºÅ£¬¿Í»§Æ·ºÅ£¬»õ±Ò£¬µ¥¼Û£¬ÏúÊÛÔ±¡£ÐèÒª´Ó±íÖÐÈ¡³öC145µÄÊý¾Ý£¬ÔÙ°ÑÕâЩÊý¾ÝµÄ¿Í»§±àºÅ¸ÄΪC522£¬ÔÙ±£´æ»Ø±íSalesItemÎÊÌâ²¹³ä£ºÕâÀïÓÐ2²¿·ÖµÄÊý¾Ý£¬C145µÄÊý¾Ý²»±ä£¬»¹ÊÇÓеģ¬C522·ÝµÄÊý¾ÝÊÇ´Ó±íÖÐÈ¡³öC145¿Í»§±àºÅµÄÊý¾Ý£¬ÔÙ°ÑÕâЩÊý¾ÝµÄ¿Í»§±àºÅ¸ÄΪC522£¬ÔÙ±£´æ»Ø±íSalesItem
ÊÇ·ñÐèÒª¸öÁÙʱ±íʲôµÄ£¿
========================================================
´ð°¸£ºÏȰÑÁùÔ·ݵÄÊý¾Ý²é³öÀ´·Åµ½ÁÙʱ±í#a ÖÐ
select *  into #a from SalesItem where  ='C145' and    like 'P3%'
°ÑÁÙʱ±íÖеÄÔ·ݸÄΪC522
update #a set ='C522'
ÔÙ°ÑÁÙʱ±íÀïµÄÊý¾Ý²åµ½Ô­±íÖÐ
insert into  SalesItem  select  * from #a
×îºóɾ³ýÁÙʱ±í
drop table #a


Ïà¹ØÎĵµ£º

sql 2005ÕûºÏbatÄÚÈÝ

@ECHO OFF
ECHO /////////////////////////////////////////////////
ECHO // Microsoft SQL Server 2005 ÕûºÏ¡¢¼¯³ÉSP3
ECHO // Author  : cxygoo
ECHO // Date    : 2008-12-22
ECHO /////////////////////////////////////////////////
ECHO ÔËÐдËÅú´¦Àíǰ£¬µÃ½¨Ä¿Â¼£ºC:\SQL2005,C:\SQL200 ......

SQL °´×é±ð¹ýÂËÖ¸¶¨Ìõ¼þµÄÊ×ÐмǼ

Ô´Ìù£ºhttp://topic.csdn.net/u/20100417/19/ebdc216a-acc9-4e04-80f3-dbada0b4f3fe.html?74846
Êý¾ÝÀàÐÍ£º
Code char(6)
CreateTime datetime
Price float
Status bit
Êý¾ÝÈçÏ£º
Code       CreateTime        Price Status
031002 2008-10-17 ......

Ó¦ÓÃIDS·ÀÖ¹SQL×¢Èë¹¥»÷

Ó¦ÓÃIDS·ÀÖ¹SQL×¢Èë¹¥»÷
http://www.cnhacker.com/Hacker/Skills/200807/t20080731_6187.html
Ŀǰ£¬Õë¶ÔÓ¦Óü°Æäºǫ́Êý¾Ý¿âµÄÓ¦Óü¶ÈëÇÖÒѾ­±äµÃÔ½À´Ô½²þâ±£¬ÈçSQL×¢Èë¡¢¿çÕ¾µã½Å±¾¹¥»÷ºÍδ¾­ÊÚȨµÄÓû§·ÃÎʵȡ£ËùÓÐÕâЩÈëÇÖ¶¼ÓпÉÄÜÈÆ¹ýǰ̨°²È«ÏµÍ³²¢¶ÔÊý¾ÝÀ´Ô´·¢Æð¹¥»÷¡£
ΪÁ˶Ը¶ÕâÀàÍþв£¬ÐÂÒ»¼¶±ðµÄ°²È«ÍÑÓ±¶ø³ö£ ......

SQL´æ´¢¹ý³Ì»ù´¡Óï·¨

Ò».×¢ÊÍ
-- µ¥ÐÐ×¢ÊÍ£¬´ÓÕâµ½±¾ÐнáÊøÎª×¢ÊÍsql Óï·¨£¬ÀàËÆC++£¬c#ÖÐ//
/* … */ ¶àÐÐ×¢ÊÍ£¬ÀàËÆC++£¬C#ÖÐ/* … */
¶þ.±äÁ¿£¨int£¬ smallint£¬ tinyint£¬ decimal£¬float£¬real£¬ money £¬smallmoneysql Óï·¨£¬ text £¬image£¬ char£¬ varchar¡£¡£¡£¡£¡£¡££©
Óï·¨£º
DECLARE
{
{@local_variable data_t ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ