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
Ïà¹ØÎĵµ£º
select
convert(char(4),auth,120)+'Äê'+
substring(convert(char(10),auth,120),6,2)+'ÔÂ'+
substring(convert(char(10),auth,120),9,2)+'ÈÕ',
convert(char(4),appr,120)+'Äê'+
substring(convert(char(10),appr,120),6,2)+'ÔÂ'+
substring(convert(char(10),appr,120),9,2)+'ÈÕ'
from a
ÒÔÉÏ´úÂëʵÏֵĹ¦Ä ......
SQL Server 2005Êý¾Ý¿â±¸·ÝºÍ»Ö¸´ÌØÐÔ
SQL Server 2000ÖдæÔÚµÄÐí¶àµÄ±¸·ÝºÍ»Ö¸´ÌØÐÔ¶¼Í¬Ñù±£ÁôÔÚÁËSQL Server 2005ÖУ¬µ«ÊÇÓÐһЩеÄÌá¸ßͬÑùÖµµÃÎÒÃǹØ×¢¡£
¾µÏñ±¸·Ý
SQL Server 2005ÈÃÄã¿ÉÒÔ´´½¨¾µÏñ±¸·Ý¡£¾µÏñ±¸·ÝÔÊÐíÄãΪ±¸·ÝÎļþ´´½¨Á½¸ö»òÕßËĸöͬÑùµÄ¿½±´£¬ÒÔ·À±¸ÆäÖеÄijһ¸ö¼¯ºÏË𻵵ÄÇé¿ö¡£¾µÏñ¾ßÓ ......
ÈçºÎÔÚÒ»¸öûÓÐÖ÷¼üµÄ±íÖлñÈ¡µÚnÐÐÊý¾Ý£¬ÔÚsql2005ÖпÉÒÔÓÃrow_number£¬µ«ÊDZØÐëÖ¸¶¨ÅÅÐòÁУ¬·ñÔòÄã¾Í²»µÃ²»ÓÃselect intoÀ´¹ý¶Éµ½ÁÙʱ±í²¢Ôö¼ÓÒ»¸öÅÅÐò×ֶΡ£
ÓÃÓαêµÄfetch absoluteÓï¾ä¿ÉÒÔ»ñÈ¡¾ø¶ÔÐÐÊýϵÄijÐÐÊý¾Ý,²âÊÔ´úÂëÈçÏÂ:
set nocount on
--½¨Á¢²âÊÔ»·¾³²¢²åÈëÊý¾Ý£¬²¢ÇÒ±íûÓÐÖ÷¼ü
create table t ......
SQLServer2005·Ö½â²¢µ¼ÈëxmlÎļþ ÊÕ²Ø
²âÊÔ»·¾³SQL2005£¬windows2003
DECLARE @idoc int;
DECLARE @doc xml;
SELECT @doc=bulkcolumn from OPENROWSET(
BULK 'D: \test.xml',
SINGLE_BLOB) AS x
EXEC sp_xml_preparedocument @Idoc OUTPUT, @doc
......
±¾ÎÄÀ´×ÔCSDN²©¿Í£ºhttp://blog.csdn.net/jinjazz/archive/2008/07/14/2650506.aspx
½«oledb¶ÁÈ¡µÄexcelÊý¾Ý¿ìËÙ²åÈëµÄsqlserverÖУ¬ºÜ¶àÈËͨ¹ýÑ»·À´Æ´½Ósql£¬ÕâÑù×ö²»µ«ÈÝÒ׳ö´í¶øÇÒЧÂʵÍÏ£¬×îºÃµÄ°ì·¨ÊÇʹÓÃbcp£¬Ò²¾ÍÊÇSystem.Data.SqlClient.SqlBulkCopy ÀàÀ´ÊµÏÖ¡£²»µ«Ëٶȿ죬¶øÇÒ´úÂë¼òµ¥£¬ÏÂÃæ²âÊÔ´úÂëµ¼ÈëÒ»¸ö6 ......