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Êý¾Ý¿âÖÐËùÓп⡢±í¡¢×Ö¶ÎÃûµÄ·½·¨
2009Äê03ÔÂ12ÈÕ ÐÇÆÚËÄ ÏÂÎç 12:51
1.»ñÈ¡ËùÓÐÊý¾Ý¿âÃû:
SELECT Name from Master..SysDatabases ORDER BY Name
2.»ñÈ¡ËùÓбíÃû:
SELECT Name from DatabaseName..SysObjects Where XType='U' ORDER BY Name
XType='U':±íʾËùÓÐÓû§±í;
XType='S':±íʾËùÓÐϵͳ± ......
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 2008 Administration Instant Reference
SQL Server 2005 Êý¾Ý¿â»ù´¡ÓëÓ¦Óü¼Êõ
Microsoft SQLServer 2005 Integration Services Step by Step
SQLServer 2005 Bible
SQL Server 2005 Êý¾Ý¿â·þÎñ¼Ü¹¹Éè ......
¿ÉÒÔÓÃÀ©Õ¹´æ´¢¹ý³Ìxp_dirtree»ñÈ¡ÎļþÁÐ±í£¬ÓÃopenrowsetµ¹ÈëÊý¾Ýµ½¶þ½øÖÆ×ֶΡ£
openrowsetµÄÓ÷¨¿ÉÒԲο¼msdn
http://technet.microsoft.com/zh-cn/library/ms190312.aspx
Èç¹ûÎļþºÜ¶à£¬½¨Ò黹ÊÇÓóÌÐòµ¹ÈëÁË
if (object_id ('t_bulkResult' ) is not null )
drop table t_bulkResult ......
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 ( ......