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

sqlserverÖÐÅжϱíÊÇ·ñ´æÔÚ

ÔÚsqlserver(Ó¦¸Ã˵ÔÚĿǰËùÓÐÊý¾Ý¿â²úÆ·)Öд´½¨Ò»¸ö×ÊÔ´Èç±í£¬ÊÓͼ£¬´æ´¢¹ý³ÌÖж¼ÒªÅжÏÓë´´½¨µÄ×ÊÔ´ÊÇ·ñÒѾ­´æÔÚ
ÔÚsqlserverÖÐÒ»°ã¿Éͨ¹ý²éѯsys.objectsϵͳ±íÀ´µÃÖª½á¹û£¬²»¹ý¿ÉÒÔÓиü·½±ãµÄ·½·¨
ÈçÏ£º
    if   object_id('tb_table') is not null 
        print 'exist'
    else
        print'not exist'
ÈçÉÏ£¬¿ÉÓÃobject_id()À´¿ìËÙ´ïµ½ÏàͬµÄÄ¿µÄ£¬tb_table¾ÍÊÇÎÒ½«Òª´´½¨µÄ×ÊÔ´µÄÃû³Æ£¬ËùÒÔÒªÏÈÅжϵ±Ç°Êý¾Ý¿âÖв»´æÔÚÏàͬµÄ×ÊÔ´
object_id()¿É½ÓÊÜÁ½¸ö²ÎÊý£¬µÚÒ»¸öÈçÉÏËùʾ£¬´ú±í×ÊÔ´µÄÃû³Æ£¬ÉÏÃæµÄ¾ÍÊDZíµÄÃû×Ö£¬µ«ÍùÍùÎÒÃÇҪ˵Ã÷ÎÒÃÇËùÒª´´½¨µÄÊÇʲôÀàÐ͵Ä×ÊÔ´£¬
ÕâÑùsql¿ÉÒÔÃ÷È·µØÔÚÒ»ÖÖÀàÐ͵Ä×ÊÔ´ÖвéÕÒÊÇ·ñÓÐÖØ¸´µÄÃû×Ö£¬ÈçÏ£º
    if   object_id('tb_table','u') is not null 
        print 'exist'
    else
        print'not exist'
µÚ¶þ¸ö²ÎÊý "u" ¾Í±íʾtb_tableÊÇÓû§´´½¨µÄ±í£¬¼´£ºUSER_TABLEµØÊ××Öĸ¼òд
²éѯsys.objectsÖпɵõ½¸÷ÖÖ×ÊÔ´µÄÀàÐÍÃû³Æ(TYPEÁÐ)£¬ÕâÀïÖ®¾Ù¼¸¸öÖ÷ÒªµÄÀý×Ó
u  -----------  Óû§´´½¨µÄ±í£¬Çø±ðÓÚϵͳ±í(USER_TABLE)
s  -----------  ϵͳ±í(SYSTEM_TABLE)
v  -----------  ÊÓͼ(VIEW)
p  -----------  ´æ´¢¹ý³Ì(SQL_STORED_PROCEDURE)
¿ÉʹÓÃselect distinct type ,type_desc from sys.objects »ñµÃÈ«²¿ÐÅÏ¢
±¾ÎÄÀ´×ÔCSDN²©¿Í£¬×ªÔØÇë±êÃ÷³ö´¦£ºhttp://blog.csdn.net/fulianglove/archive/2008/08/07/2783381.aspx


Ïà¹ØÎĵµ£º

SQLSERVERÊý¾Ý¿â¿ª·¢µÄ¶þʮһÌõ¾ü¹æ

SQL SERVERÊý¾Ý¿â¿ª·¢µÄ¶þʮһÌõ¾ü¹æ
Èç¹ûÄãÕýÔÚ¸ºÔðÒ»»ùÓÚSQL SERVER µÄÏîÄ¿£¬»òÕ߸ոսӴ¥SQL SERVER£¬Äã¿ÉÄܽ«ÃæÁÙһЩÊý¾Ý¿âÐÔÄܵÄÎÊÌâ¡£ÕâÆªÎÄÕ»áÌṩһЩÓÐÓõľ­Ñé-----¹ØÓÚÈçºÎÐγɺõÄÉè¼Æ¡£
Ò»¡¢Á˽âÄãÓõŤ¾ß
²»ÒªÇáÊÓÕâÒ»µã£¬ÕâÊDZ¾ÎÄ×î¹Ø¼üµÄÒ»Ìõ¡£Ò²ÐíÄãÒ²¿´µ½ÓкܶàµÄSQL SERVER³ÌÐòԱûÓÐÕÆÎÕÈ«²¿µÄT- ......

18¾ä»°ÈëÃÅSQLServer XML


/*
sql xml ÈëÃÅ:
    --by jinjazz
    --http://blog.csdn.net/jinjazz
   
    1¡¢xml:        ÄÜÈÏÊ¶ÔªËØ¡¢ÊôÐÔºÍÖµ
   
    2¡¢xpath:    ѰַÓïÑÔ£¬ ......

SQLServer»ñÈ¡ExcelÖÐËùÓÐSheet

EÅ̸ùĿ¼Ð½¨Ò»¸öExcelÎļþaa.xlsºó²âÊÔÈçÏ´úÂë
use tempdb
go
if (object_id ('udf_getExcelTableNames' ) is not null )
    drop function dbo .udf_getExcelTableNames
go
create function udf_getExcelTableNames (@filename varchar (1000 ))
returns @t table (id int , name varchar ( ......

SqlServer ÓαêÀý×Ó

 
Declare @Id int
Declare @Name varchar(20)
Declare Cur Cursor For Select Id,Name from T_User  
Open Cur
Fetch next from Cur Into @Id,@Name
While @@fetch_status=0    
Begin
    Update T_User Set [Name]=@Name,Id=@Id
    ......

Ëø³õ̽(sqlserver 2005)

HOLDLOCK ½«¹²ÏíËø±£Áôµ½ÊÂÎñÍê³É£¬¶ø²»ÊÇÔÚÏàÓ¦µÄ±í¡¢ÐлòÊý¾ÝÒ³²»ÔÙÐèҪʱ¾ÍÁ¢¼´ÊÍ·ÅËø¡£HOLDLOCK µÈͬÓÚ SERIALIZABLE¡£
NOLOCK ²»Òª·¢³ö¹²ÏíËø£¬²¢ÇÒ²»ÒªÌṩÅÅËüËø¡£µ±´ËÑ¡ÏîÉúЧʱ£¬¿ÉÄÜ»á¶ÁȡδÌá½»µÄÊÂÎñ»òÒ»×éÔÚ¶ÁÈ¡ÖÐ¼ä»Ø¹öµÄÒ³Ãæ¡£ÓпÉÄÜ·¢ÉúÔà¶Á¡£½öÓ¦ÓÃÓÚ SELECT Óï¾ä¡£
 PAGLOCK ÔÚͨ³£Ê¹Óõ¥¸ö±íËøµ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ