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
Ïà¹ØÎĵµ£º
//ÕâÊÇÌí¼Ó
private void button1_Click(object sender, EventArgs e)
{
string s = "Persist Security Info=False;Integrated Security=SSPI;database=IIntegration;server=(local)";
&n ......
SqlserverµÃµ½ºº×ÖÆ´ÒôÊ××Öĸ´æ´¢¹ý³Ì:
create function [dbo].[fun_getPY]
(
@str nvarchar(4000)
)
returns nvarchar(4000)
as
begin
declare @word nchar(1),@PY nvarchar(4000)
set @PY=''
while len(@str)>0
begin
set @word=left(@str,1)
--Èç¹û·Çºº×Ö×Ö·û£¬·µ»ØÔ×Ö·û
& ......
SQLServerÖÐÓÐÁ½¸öÀ©Õ¹´æ´¢¹ý³ÌʵÏÖScanfºÍPrintf¹¦ÄÜ£¬Ç¡µ±µÄʹÓÃËüÃÇ¿ÉÒÔÔÚÌáÈ¡ºÍÆ´½Ó×Ö·û´®Ê±´ó·ù¶È¼ò»¯SQL´úÂë¡£
1¡¢xp_sscanf£¬ÓÃËü¿ÉÒÔ·Ö½â¸ñʽÏà¶Ô¹Ì¶¨µÄ×Ö·û´®£¬Õâ¶ÔÓÚÑá¾ëʹÓÃÒ»¶ÑsubstringºÍcharindexµÄÅóÓÑÀ´Ëµ²»´í¡£±ÈÈçǰ¼¸ÌìµÄÒ»¸öÌû×ÓÖÐÌá³öµÄÈçºÎ·Ö½âipµØÖ·£¬Ïà¶Ô¼òÁ·ÇÒͨÓõĴúÂëÓ¦¸ÃÊÇÏÂÃæÕâÑù
------- ......
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 ( ......
HOLDLOCK ½«¹²ÏíËø±£Áôµ½ÊÂÎñÍê³É£¬¶ø²»ÊÇÔÚÏàÓ¦µÄ±í¡¢ÐлòÊý¾ÝÒ³²»ÔÙÐèҪʱ¾ÍÁ¢¼´ÊÍ·ÅËø¡£HOLDLOCK µÈͬÓÚ SERIALIZABLE¡£
NOLOCK ²»Òª·¢³ö¹²ÏíËø£¬²¢ÇÒ²»ÒªÌṩÅÅËüËø¡£µ±´ËÑ¡ÏîÉúЧʱ£¬¿ÉÄÜ»á¶ÁȡδÌá½»µÄÊÂÎñ»òÒ»×éÔÚ¶ÁÈ¡ÖÐ¼ä»Ø¹öµÄÒ³Ãæ¡£ÓпÉÄÜ·¢ÉúÔà¶Á¡£½öÓ¦ÓÃÓÚ SELECT Óï¾ä¡£
PAGLOCK ÔÚͨ³£Ê¹Óõ¥¸ö±íËøµ ......