ÔÚ´æ´¢¹ý³ÌÖÐÁ¬½ÓSQLÓï¾ä×Ö·û´®
CREATE PROCEDURE [dbo].[PUB_CORP_SEARCH]
@oi_return INT OUTPUT , -- ²Ù×÷·µ»ØÖµ
@ov_message NVARCHAR(1000) OUTPUT , -- ²Ù×÷·µ»ØÐÅÏ¢
@iv_user VARCHAR(30) , -- ²Ù×÷Óû§
@iv_bankcode VARCHAR(30) , -- ÒøÐдúÂë
@iv_orgcode VARCHAR(20) , -- »ú¹¹´úÂë
@id_workdate DATETIME , -- ²Ù×÷ÈÕÆÚ
@iv_corptype VARCHAR(30) , -- »ñÈ¡ÕʺÅ
@iv_corpcode&n
Ïà¹ØÎĵµ£º
Sql Server ²éѯsqlÖ´Ðи÷¸ö½×¶ÎµÄʱ¼ä
set statistics io on
set statistics time on
set statistics profile on
go
[ÄãµÄsqlÓï¾ä]
go
set statistics io off
set statistics time off
set statistics profile off
ÎÒÔËÐУº
set statistics io on
set statistics time on
set statistics profile on ......
×öÏîÄ¿ÀïÃæµÄÊý¾Ý¿âÉè¼ÆÁËÁ½¸öÀàÐÍ·ÅÒ»¸ö×Ö¶ÎÀïÃæ,ÎÒÓÖҪͨ¹ý·Ö¿ªµÄÀàÐÍÀ´½øÐвéѯ,Í´¿à°¡,
Á½ÖÖ·½·¨;
1,¶ÁÈ¡µ½»º´æÖÐ×Ô¶¨Òådatatable, ´úÂë¾Í²»ÌùÁË.
²»ÐÀÉÍÕâÖÖ×ö·¨,ÒòΪÎÒÒѾ°ÑÒ³ÃæÉϺܶණÎ÷дÁË,¶¼ÊÇÓеÄSqlÓï¾ä,ÕâÑù¸Äһ϶¼Òª¸ÄÁË.
2.Ö±½ÓÔÚSqlÀïÃ潨ÊÓͼ,
lÓÃSUBSTRING(dbo.K_ProductDtl.Caizhi, 0, CH ......
ÏÂÔØsql2005ÍêÒÔºó½âѹ³öÀ´£¬´ó¼Ò¿ÉÒÔ¿´µ½cs_sql_2005_chs_x86Õâ¸öĿ¼£¬½øÈëÕâ¸öĿ¼ÔËÐÐsetup.exeÎļþ£¬°²×°³ÌÐò¾Í¿ªÊ¼ÔËÐÐÁË¡£
Ê×Ïȵ¯³öÀ´µÄÊÇÈí¼þÐí¿ÉÌõ¿î
¹´ÉÏÎÒ½Ó°®Ðí¿ÉÌõ¿îºÍÌõ¼þ£¬µãÏÂÒ»²½
ÕâÀïÁгöÁËSQL2005ÔËÐл·¾³£¬Ö±½Óµã°²×°
³ÌÐò¿ªÊ¼°²×°SQL2005ÔËÐбØÐèµÄ»·¾³£¬ÅäÖÃ×é¼þ
±ØÐèµÄ×é¼þ°²×°ºÃÁË£¬µãÏÂÒ»²½¼ ......
¼¸µÀ¾µäµÄSQL±ÊÊÔÌâÄ¿£¨Óд𰸣©
£¨1£©±íÃû£º¹ºÎïÐÅÏ¢
¹ºÎïÈË ÉÌÆ·Ãû³Æ ÊýÁ¿
A ¼× 2
B ÒÒ &n ......
master..xp_dirtree 'D:\',1,1 µÚÒ»¸ö1ÊÇÉî¶È£¬µÚ¶þ¸ö1ÊÇÎļþ
1. Ö´ÐÐ master..xp_dirtree 'c:\',1,1,ÕâÑù¿ÉÒÔ»ñÈ¡c:\ϵÄËùÓÐÎļþºÍÎļþ¼Ð,²»°üÀ¨×ÓÎļþ¼Ð¼°Îļþ
2. ÏÔʾÔÚtreeviewÖÐ,ÓñêÖ ......