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

SQLÖд洢¹ý³ÌÖÐSQLÓï¾äµÄµ¥ÒýºÅºÍË«ÒýºÅÎÊÌâ

    Ö£ÖØÉùÃ÷һϣ¬ÕâÆªÈÕÖ¾ÊÇÎÒCopyµÄ£¬²»ÊÇ×Ô¼ºÐ´µÄ£¬ÎÒ»¹Ã»ÄÇôǿ£¡(×Ðϸ¿´Ò»Ï£¬ÓÐÓá£)
¹ØÓÚSQLÓï¾äÖеÄË«ÒýºÅ¡¢µ¥ÒýºÅ£º
£¨1£©ÏÈÀ´¿´Ò»¸ö×î¼òµ¥µÄSQLÓï¾ä
            Insert Into users(username) values("СÍõ")
    ´ó¼ÒÀ´¿´Ò»Ï£¬ÕâÊÇÒ»¸ö±ê×¼µÄSQLÓï¾ä£¬ÒòΪusernameÊÇÎı¾ÐÍ×ֶΣ¬ËùÒÔ×Ö¶ÎÖµÁ½±ßÒª¼ÓË«ÒýºÅ£¬±íʾСÍõÊÇÒ»¸ö×Ö·û´®¡£
    £¨2£©¿ÉÊÇÔÚASPÖУ¬ÎÒÃÇͨ³£ÕâÑùд
            strSql="Insert Into users(username) values('СÍõ')"
    ´Ëʱ£¬Ç°ºóµÄË«ÒýºÅ±íʾÖмäÊÇÒ»¸ö×Ö·û´®¡£¶øÐ¡ÍõÁ½±ßµÄµ¥ÒýºÅÊÇÒòΪ·¢ÉúÁËÒýºÅǶÌ×£¬ËùÒÔÄÚ²ãÒýºÅ¸ÃΪÁ˵¥ÒýºÅ¡£
    £¨3£©Êµ¼Ê²åÈëʱ£¬ÒòΪСÍõͨ³£ÊÇ´Ó±íµ¥ÖлñÈ¡µÄ±äÁ¿£¬²»¹ýÒòΪ±äÁ¿²»ÄÜÖ±½ÓдÈë×Ö·û´®£¬±ØÐëͨ¹ýÁ¬½Ó·ûºÍ×Ö·û´®Á¬½ÓÔÚÒ»Æð£¬ËùÒÔҪд³ÉÈçÏÂÐÎʽ£º
           myusername=Request.Form("username")
           ……
           strSql="Insert Into users(username) values('" & myusername & "')"
    ºÜ¶àÈË´Ëʱ¾ÍºýÍ¿ÁË£¬ÎªÊ²Ã´ÆäÖÐÓÖÓе¥ÒýºÅ£¬ÓÖÓÐË«ÒýºÅ°¡¡£¼òµ¥µÄ¿´ÉÏÃæµÄʽ×Ó£¬ÆäʵÊÇÓÉÈçÏÂÈý²¿·Ö×é³ÉµÄ£º
          ×Ö·û´®³£Êý£º"Insert Into users(username) values('"
          ×Ö·û´®±äÁ¿£ºmyusername
          ×Ö·û´®³£Êý£º"')"
    Ö±½ÓÀí½âÉÏÃæµÄʽ×Ó¿ÉÄܱȽÏÀ§ÄÑ£¬ÏÖÔÚÎÒÃDZäÁ¿myusernameµÄÖµ´úÈë¾ÍÄÜ¿´Çå³þÁË¡£¼ÙÈçmyusername="СÍõ"£¬´úÈ룺
           strSql="Insert Into users(username) values('" & "СÍõ" & "')"
    È»ºóÒÀ´ÎÖ´ÐÐÆäÖеÄÁ¬½ÓÔËËã·û£¬½á¹ûΪ£º
           strSql="Insert Into users(username) values('СÍõ')"
    Õâ¾ÍÊÇ£¨2£©ÖÐÌá


Ïà¹ØÎĵµ£º

SQLÑ­»·ÓαêµÄʹÓÃ

½ñÌì¸ãµÄ£¬°ïͬʲéѯÊý¾Ý£¬ÏÈд¸ö´¥·¢Æ÷£¬½ØÈ¡http://www.chinaroyalgroup.cn/aspnet_client/system_web/2_0_50727/dispbbs.asp?boardid=1&id=836ÀïµÄÓòÃû
IF EXISTS (SELECT name from sysobjects
      WHERE name = 'gs_MySub' AND type = 'P')
   DROP PROCEDURE gs_MySub ......

ÊÖ¹¤ÍêÈ«Ð¶ÔØSQL SERVER2000Êý¾Ý¿â

ÔÚ½øÐвÙ×÷֮ǰ£¬½¨Ò鱸·ÝºÃ×¢²á±íÒÔ¼°ÖØÒªµÄÊý¾Ý¿âÎļþ¡£
£¨1£© ɾ³ýÒÔÏÂ×¢²á±í×ÓÏ
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ Microsoft SQL Server
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer
HKEY_LOCAL_MACHINE\SYSTEM\CurrentC ......

¹ØÓÚSQL SERVER Êý¾Ý²ð·Ö

if object_id('tb') is not null drop table tb
go
create table tb([A] varchar(10),[B] int)
insert tb
select 'bcd',1 union all
select 'bcde',2 union all
select 'cd',3
go
¸öÈË·ÖÎöÕâµÀÌâµÄ˼·ÊÇ£º
ͨ¹ýSubstring() À´Ñ­»··Ö¸î B ÁÐϵÄ×Ö·û´®¡£¡£
--ÏëµÃµ½µÄ½á¹û£º
/**
a    b& ......

sql server ¹ØÓÚ Êý¾Ý»ã×Ü·ÖÎö

CUBE ºÍ ROLLUP Ö®¼äµÄÇø±ðÔÚÓÚ£º
CUBE Éú³ÉµÄ½á¹û¼¯ÏÔʾÁËËùÑ¡ÁÐÖÐÖµµÄËùÓÐ×éºÏµÄ¾ÛºÏ¡£
ROLLUP Éú³ÉµÄ½á¹û¼¯ÏÔʾÁËËùÑ¡ÁÐÖÐÖµµÄijһ²ã´Î½á¹¹µÄ¾ÛºÏ¡£
Àý×Ó£º
  if object_id('a')  is not null
drop table a
create table a
(
  bm varchar(20),  --±àÂë
  ck varchar(2), &n ......

SQL server 2005»ùÓÚÒÑ´æÔÚµÄ±í´´½¨·ÖÇø


< type="text/javascript">
< type="text/javascript">
Èç×ªÔØ£¬Çë×¢Ã÷³ö´¦£ºhttp://blog.csdn.net/robinson_0612/archive/2009/11/07/4783702.aspx

     
Ëæ×ŵ±½ñÊý¾Ý¿âµÄÈÝÁ¿Ô½À´Ô½¿ìµÄ³¯×ÅÔÚ´óÐÍÊý¾Ý¿â»ò³¬´óÐÍÊý¾Ý¿âµÄ·¢Õ¹£¬¶ÔÓÚÊý¾Ý¿âÖеĴóÐͱíÒÔ¼°¾ßÓи÷ÖÖ·ÃÎÊģʽµÄ±íµÄ¿ÉÉìËõÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ