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

SqlServerÊý¾Ý¿âµÄÓï¾ä¼°Ò»Ð©²Ù×÷ÕûÀí

ÁÙ½üÄêÖÕ£¬ÔÚ¹¤×÷Ö®Óà¶Ô¹¤×÷ºÍѧϰÖÐÓöµ½µÄÎÊÌâÒÔ¼°³£ÓõÄһЩ֪ʶµã×öÁËЩÕûÀí£¬ÒÔ±¸ºóÓᣱ¾ÎÄÉæ¼°µÄÄÚÈÝΪÊý¾Ý¿â,ËãÊǶԿª·¢×ܽá(1)---Êý¾Ý¿âÒ»ÎĵIJ¹³ä¡£
1 ¶ÔÓÚÖ÷¼üÉèÖÃÁËIdentityµÄ±í£¬ÔÚɾ³ý±íÖÐÊý¾ÝºóÔÙÍù±íÖвåÈëÊý¾Ý£¬IdentityÁв»ÊÇ´Ó1ÆðʼÁË£¬Èç¹ûÏëɾ³ýÊý¾ÝºóIndentityÁÐÈÔ´Ó1Æðʼ£¬¿ÉÒÔÓÃÏÂÃæ´úÂëÀ´É¾³ýÊý¾Ý¡£
truncate table tablename
DBCC CHECKIDENT(tablename,RESEED,1)
2 ÅжÏÖ¸¶¨±íÔÚÊý¾Ý¿âÖÐÊÇ·ñ´æÔÚ
if exists(select name from sysobjects where name='tablename' and type='u')
3 ÅжÏÖ¸¶¨ÁÐÔÚÖ¸¶¨±íÖÐÊÇ·ñ´æÔÚ
if exists(select * from sys.columns,sys.tables
where sys.columns.object_id = sys.tables.object_id
and sys.tables.name='tablename' and sys.columns.[name]='columnname')
4 ÔÚ±àд´úÂëÉú³ÉÆ÷Ö®ÀàµÄ³ÌÐòµÄʱºò£¬Í¨³£ÐèҪȡ³öÊý¾Ý¿âÖÐËùÓеıíÃûÒÔ¼°±íÖÐ×ֶεÄһЩ»ù±¾ÐÅÏ¢£¬Èç×ֶγ¤¶È¡¢×Ö¶ÎÀàÐÍ¡¢ÃèÊöµÈ¡£ÊµÏÖÉÏÃæÒªÇóµÄsqlÓï¾äÈçÏ£º
--È¡Êý¾Ý¿âÖбíµÄ¼¯ºÏ
select * from sysobjects where xtype='u' order by name
--È¡±íÖÐ×ֶεÄһЩ»ù±¾ÐÅÏ¢
select
sys.columns.name, --×Ö¶ÎÃû
sys.types.name as typename, --×Ö¶ÎÀàÐÍ
sys.columns.max_length, --×ֶ㤶È
sys.columns.is_nullable, --ÊÇ·ñ¿É¿Õ
(select
count(*)
from
sys.identity_columns
where
sys.identity_columns.object_id = sys.columns.object_id
and
sys.columns.column_id = sys.identity_columns.column_id
) as is_identity ,--ÊÇ·ñ×ÔÔö
(select
value
from
sys.extended_properties
where
sys.extended_properties.major_id = sys.columns.object_id
and
sys.extended_properties.minor_id = sys.columns.column_id
) as description --×¢ÊÍ
from
sys.columns, sys.tables, sys.types
where
sys.columns.object_id = sys.tables.object_id
and
sys.columns.system_type_id=sys.types.system_type_id
and
sys.tables.name='tablename'
order by sys.columns.column_id
5 ÔÚ´æ´¢¹ý³ÌÖÐʹÓÃÊÂÎñ
create procedure procname
as
begin tran
--Ö´ÐÐsqlÓï¾ä
if @@ERROR!=0
begin


Ïà¹ØÎĵµ£º

¶ÁÈ¡sqlserverͼƬimageÊý¾ÝÉú³ÉͼƬÎļþ

//test.java
import java.io.BufferedOutputStream;
import java.io.DataOutputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
imp ......

SQLServerÅúÁ¿µ¹ÈëĿ¼Îļþ ÊÕ²Ø


¿ÉÒÔÓÃÀ©Õ¹´æ´¢¹ý³Ì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 ......

SQLServerÖеÄScanfºÍPrintf ÊÕ²Ø

SQLServerÖÐÓÐÁ½¸öÀ©Õ¹´æ´¢¹ý³ÌʵÏÖScanfºÍPrintf¹¦ÄÜ£¬Ç¡µ±µÄʹÓÃËüÃÇ¿ÉÒÔÔÚÌáÈ¡ºÍÆ´½Ó×Ö·û´®Ê±´ó·ù¶È¼ò»¯SQL´úÂë¡£
1¡¢xp_sscanf£¬ÓÃËü¿ÉÒÔ·Ö½â¸ñʽÏà¶Ô¹Ì¶¨µÄ×Ö·û´®£¬Õâ¶ÔÓÚÑá¾ëʹÓÃÒ»¶ÑsubstringºÍcharindexµÄÅóÓÑÀ´Ëµ²»´í¡£±ÈÈçÇ°¼¸ÌìµÄÒ»¸öÌû×ÓÖÐÌá³öµÄÈçºÎ·Ö½âipµØÖ·£¬Ïà¶Ô¼òÁ·ÇÒͨÓõĴúÂëÓ¦¸ÃÊÇÏÂÃæÕâÑù
------- ......

ÓÃCASE WHENʵÏÖsqlserverÊý¾Ý¿âµÄ·ÖÀà»ã×ܹ¦ÄÜ

/*ÓÃCASE WHENʵÏÖsqlserverÊý¾Ý¿âµÄ·ÖÀà»ã×ܹ¦ÄÜ*/
/*Àý1£ºÍ³¼Æ¸öÊý*/
/*±í½á¹¹
id  cityid  major
1   1         A
2   1         B
3   2        ......

SQLServerϵͳ´æ´¢¹ý³Ì

sp_databases --Áгö·þÎñÆ÷ÉϵÄËùÓÐÊý¾Ý¿â
sp_server_info --Áгö·þÎñÆ÷ÐÅÏ¢£¬Èç×Ö·û¼¯£¬°æ±¾ºÍÅÅÁÐ˳Ðò
sp_stored_procedures--Áгöµ±Ç°»·¾³ÖеÄËùÓд洢¹ý³Ì
sp_tables --Áгöµ±Ç°»·¾³ÖÐËùÓпÉÒÔ²éѯµÄ¶ÔÏó
sp_start_job --Á¢¼´Æô¶¯×Ô¶¯»¯ÈÎÎñ
sp_stop_job --Í£Ö¹ÕýÔÚÖ´ÐеÄ×Ô¶¯»¯ÈÎÎñ
sp_password --Ìí¼Ó»òÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ