¼¸ÌõÓÐÓõÄSqlÓï¾ä
1. Sql ÑÓʱºòÖ´ÐÐ
a. ÈýÊ®ÃëºóÖ´ÐÐ WAITFOR DELAY ºóÃæµÄÓï¾ä
WAITFOR DELAY '00:00:30'
b. 10:00·Ö¿ªÊ¼Ö´ÐкóÃæµÄ´úÂë
WAITFOR TIME '10:00';
2. ÊÕËõÊý¾Ý¿â£¬Ê¹Æä¿ÕÓà¿Õ¼äΪ0%
DBCC SHRINKDATABASE (DataBaseName,0)
3. È¡µÃÊý¾Ý¿âÎļþËùÔÚµÄÅÌ·û
declare @dirverName varchar(50)
declare @bakUpPath varchar(255)
select top 1 @dirverName = filename from sysfiles
set @dirverName = substring(@dirverName,0,4)
set @bakUpPath = @dirverName + 'DataBaseName.bak'
4.½«Êý¾Ý±¸·Ýµ½Ö¸¶¨Â·¾¶£¬ÈôÓö±¸·ÝÎļþÒѾ´æÔÚÔò¸²¸Ç
BACKUP DATABASE DataBaseName TO DISK=@bakUpPath with INIT,Skip
Ïà¹ØÎĵµ£º
Ò»¡¢×Ö·ûת»»º¯Êý
1¡¢ASCII()
·µ»Ø×Ö·û±í´ïʽ×î×ó¶Ë×Ö·ûµÄASCII ÂëÖµ¡£ÔÚASCII£¨£©º¯ÊýÖУ¬´¿Êý×ÖµÄ×Ö·û´®¿É²»ÓÑ’À¨ÆðÀ´£¬µ«º¬ÆäËü×Ö·ûµÄ×Ö·û´®±ØÐëÓÑ’À¨ÆðÀ´Ê¹Ó㬷ñÔò»á³ö´í¡£
2¡¢CHAR()
½«ASCII Âëת»»Îª×Ö·û¡£Èç¹ûûÓÐÊäÈë0 ~ 255 Ö®¼äµÄASCII ÂëÖµ£¬CHAR£¨£© ·µ»ØNULL ¡£
3¡¢LOWER()ºÍ ......
MMC ²»ÄÜ´ò¿ªÎļþ C:\Program Files\Microsoft SQL Server\80\Tools\BINN\SQL Server Enterprise Manager.MSC¡£¿ÉÒÔÔÒòÊÇÎļþ²»´æÔÚ£¬²»ÊÇÒ»¸öMMC¿ØÖÆ̨£¬»òÕßÓúóÀ´MMC°æ±¾´´½¨£¬Ò²ÐíҲûÓзÃÎÊ´ËÎļþµÄ×㹻ȨÏÞ¡£
½â¾ö·½·¨£º
ÖØд´½¨´ËÎļþ£¬ÔËÐжԻ°¿òÖÐÊäÈë:mmc
1) ¿ØÖÆ̨-->Ìí¼Ó/ɾ³ý¹ÜÀíµ¥Ôª-->Ìí¼ ......
2009-11-18 12:51:46
ÏÞ¶¨´¦Àí¼Ç¼µÄµ¥Î»£¬rowcount=100±íʽÿ´Î´¦Àí100ÌõÊý¾Ý¡£Êµ¼Ê´¦ÀíµÄ¼Ç¼ÊýÓÉrowcountºÍwhere×Ó¾ä¾ö¶¨¡£Èç¹û·ûºÏwhereµÄ¼Ç¼Êý´óÓÚrowcount,ÔòÓÐrowcount¾ö¶¨£¬Èç¹ûСÓÚrowcount£¬ÔòÓÉwhere¾ö¶¨¡£
create table tb(id int identity(1,1),num int)
insert into tb
values(1)
while @@ ......
ÀýÈç²éÕÒ¹ØÓÚ¶Ôlibrary ....µÈ´ýʼþÓй±Ï×µÄSQL
select sql_text from V$sqlarea where (address,hash_value) in
(select sql_address,sql_hash_value from v$session where event like 'library%');
´ËÓï¾äÖ»ÄÜÔËÐÐÓÚ10g°æ±¾ÒÔÉÏ£¬ÒòΪ10gÖÐv$sessionÊÓͼ°üº¬Á˵ȴýʼþµÄÐÅÏ¢ÁË£¬9iÖÐûÓÐ ......
/*ͳ¼ÆÿÌìÊý¾Ý×ÜÁ¿ÈýÖÖ·½·¨£º
select convert(char(10),happentime ,120) as date ,count(1) from table1
group by convert(char(10),happentime ,120) order by date desc
s ......