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

sql²éѯËùÓд洢¹ý³ÌÄÚÈÝ ÀûÓÃÓαêºÍÁÙʱ±í


Use Êý¾Ý¿â
DECLARE @ProcName varchar(50)
Create Table #tmpName(Content varchar(2000))
Create Table #tmp(ProcName varchar(2000),Content1 varchar(8000))
--¶¨ÒåÒ»¸öÓαê
DECLARE SearchProc CURSOR FOR
--²éѯÊý¾Ý¿âÖд洢¹ý³ÌµÄÃû³Æ£¬¾¡Á¿È¥³ýϵͳPROC£¬¿ÉÒÔ¸ù¾Ýcrdateʱ¼ä×Ö¶ÎÀ´Ñ°ÕÒ·ÇϵͳPROC
select name from sysobjects where type='P' and name not like 'dt_%'
OPEN SearchProc
FETCH NEXT from SearchProc
INTO @ProcName
WHILE @@FETCH_STATUS >=0
BEGIN
    Print @ProcName
    Insert Into #tmpName(Content) Exec sp_helptext @ProcName
    Insert Into #tmp(ProcName,Content1) select @ProcName,#tmpName.Content from #tmpName
    --Ìî³äÍê¾ÍÇå¿ÕÒ»ÏÂÁÙʱ±í
    Truncate table #tmpName
    FETCH NEXT from SearchProc
    INTO @ProcName
END
CLOSE SearchProc
DEALLOCATE SearchProc
GO
select ProcName from #tmp where Content1 like '%²éÕÒÄÚÈÝ%' group by ProcName
select ProcName,Content1 from #tmp where Content1 like '%²éÕÒÄÚÈÝ%'
select ProcName,Content1 from #tmp where procname='´æ´¢¹ý³ÌÃû³Æ'
--ɾ³ýÁÙʱ±í
Drop Table #tmpName
Drop Table #tmp


Ïà¹ØÎĵµ£º

SQL 2005 ´´½¨Ô¼Êø

²Î¼û¡¶SQL Sever 2005 Êý¾Ý¿â»ù´¡¼°Ó¦Óü¼Êõ½Ì³ÌÓëʵѵ¡· ÖÜÆæ
 
SQL ServerÖÐÓÐÎåÖÖÔ¼ÊøÀàÐÍ£¬·Ö±ðÊÇCHECKÔ¼Êø¡¢DEFAULTÔ¼Êø¡¢PRIMARY KEYÔ¼Êø¡¢FOREIGN KEYÔ¼ÊøºÍUNIQUEÔ¼Êø¡£
 
1.       CHECKÔ¼Êø£º
CHECKÔ¼ÊøÓÃÓÚÏÞÖÆÊäÈëÒ»Áлò¶àÁеÄÖµµÄ·¶Î§£¬Í¨¹ýÂß¼­±í´ïʽÀ´ÅжÏÊý¾ ......

MS SQL Êý¾ÝÀàÐÍ

 
1
bigint     
´Ó -2^63 µ½ 2^63-1 Ö®¼äµÄ integer (ÕûÊý)Êý¾Ý
2
binary       
¶¨³¤µÄbinaryÊý¾Ý£¬×Ϊ8,000×Ö½Ú
3
bit        
integerÊý¾Ý£¬ÖµÎª1»ò0
4
char      ......

Sql2005/08 ±í½á¹¹ SQL Óï¾ä

SELECT
(case when a.colorder=1 then d.name
--+'('+cast(h.value as nvarchar)+')'
else '' end)±íÃû,
a.colorder ×Ö¶ÎÐòºÅ,
a.name ×Ö¶ÎÃû,
isnull(g.[value],'') AS ×Ö¶Î˵Ã÷,
(case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then '¡Ì'else '' end) ±êʶ,
(case whe ......

SQL Server Mobile ѧϰ(Ò»):»·¾³´î½¨

1.SQL Server Mobile ¼ò½é
2.»ñÈ¡ SQL Server Mobile
3.°²×°±Ø±¸Èí¼þ
4.°²×°¿ª·¢»·¾³
5.°²×°·þÎñÆ÷»·¾³
6.ÅäÖà Web ͬ²½Ïòµ¼
7.ʹÓà Internet Explorer ¼ì²é SQL Server Mobile ·þÎñÆ÷´úÀíÅäÖÃ
8.ʹÓÃSQL Server Mobile Êý¾Ý¿â
==========================
1.SQL Server Mobile ¼ò½é
-------------------------- ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ