SQL×¢Èë¹¥»÷·À·¶¼¼ÇÉ
SQL×¢Èë¹¥»÷·À·¶¼¼ÇÉ
Ò»°ãµÄSQL×¢Èë¹¥»÷¶¼ÊÇͨ¹ý¹¹½¨Ò»Ìõ¸´ÔÓµÄsqlÓï¾ä£¬
ͨ¹ýÍøÒ³Â©¶´À´Ö´ÐÐsqlÓï¾ä£¬´ïµ½¹¥»÷Êý¾Ý¿âµÄÄ¿µÄ¡£
Èçͨ¹ýÎÄÕÂIDÀ´²éѯijһƪÎÄÕµÄÍøÒ³£¬
ͨ³£²ÉÓõÄsqlÓï¾äΪ£º
sql="select top 1 * from articles where articId="&request("id")
ÄÇô¿ÉÒÔ¼òµ¥µØ¹¹½¨Ò»Ìõ¹¥»÷Óï¾ä£º
´«Èëid±äÁ¿µÄֵΪ£º1; select getDate(); --
´Ó¶ø¹¹½¨ÁËÒ»ÌõеÄsqlÓï¾ä£º
select top 1 * from articles where articId=1;
select getDate(); --
ËäÈ»ÕâÌõÓï¾ä²¢²»ÄܶÔÊý¾Ý¿â²úÉúÈκθºÃæÓ°Ï죬
µ«ÊÇÆäËüµÄ¹¥»÷Óï¾äÒ²ÊÇÕâÑùͨ¹ýÌí¼ÓÓï¾ä·Ö¸ô·û;ºÍ×¢ÊÍ·ûºÅ--À´×é³ÉµÄ¡£
ÎÒÃǵķÀ·¶¼¼ÇÉ£¬¶ÔËùÓпÉÒÔÌá½»´«ÈëµÄ±äÁ¿½øÐд¦Àí£º
1¡¢intÀàÐ͵ÄÊý¾Ý£¬ÈçÉÏÀýÖеÄid£¬ÔòʹÓÃÒÔÏ·½·¨´¦Àí£º
<%
on error resume next
id = CInt(request("id"))
%>
2¡¢×Ö·û´®ÀàÐ͵ÄÊý¾Ý£¬Ôò½øÐг£¼ûµÄ±êµã·ûºÅ¹ýÂË´¦Àí£º
<%
str = request("str")
str = replace(str, "´", "") ´½«µ¥ÒýºÅ×Ö·û¹ýÂ˵ô
str = replace(str, ";", "") ´½«·ÖºÅ¹ýÂ˵ô
´...
%>
ÆäËû×Ö·û²»Ò»Ò»Ã¶¾Ù£¬Äã¿ÉÒÔдһ¸ö×Ö·û¹ýÂ˵ĺ¯Êý£¬¹ýÂËһЩÔÚÄãµÄÍøÕ¾µ±ÖÐ
²¢²»³£ÓõÄÓÐΣÏÕÐԵķûºÅ£»Ò²¿ÉÒÔ²ÉÓÃÕýÔò±í´ïʽÀ´½øÐйýÂË£»
Ïà¹ØÎĵµ£º
--> Title : SQL ServerϵͳÊÓͼ
--> Author : wufeng4552
--> Date : 2009-10-28
Ŀ¼ÊÓͼ
Ŀ¼ÊÓͼ·µ»Ø SQL Server Êý¾Ý¿âÒýÇæÊ¹ÓõÄÐÅÏ¢¡£½¨ÒéÄúʹÓÃĿ¼ÊÓͼÕâÒ»×î³£ÓõÄĿ¼ԪÊý¾Ý½çÃæ£¬Ëü¿ÉΪÄúÌṩ×îÓÐЧµÄ·½·¨À´»ñÈ¡¡¢×ª»»²¢ÏÔʾ´ËÐÅÏ¢µÄ×Ô¶¨ÒåÐÎʽ¡£ËùÓÐÓû§¿ÉÓÃĿ¼Ԫ ......
WAITFOR
Ö¸¶¨´¥·¢Óï¾ä¿é¡¢´æ´¢¹ý³Ì»òÊÂÎñÖ´ÐеÄʱ¼ä¡¢Ê±¼ä¼ä¸ô»òʼþ¡£
Óï·¨
WAITFOR { DELAY 'time' | TIME
'time' }
²ÎÊý
DELAY
ָʾ Microsoft® SQL Server™ Ò»Ö±µÈµ½Ö¸¶¨µÄʱ¼ä¹ýÈ¥£¬×¿É´ï 24 Сʱ¡£
'time'
ÒªµÈ´ýµÄʱ¼ä¡£¿ÉÒÔ°´ datetime Êý¾Ý¿É½ÓÊܵĸñʽָ¶¨
time£¬Ò²¿ÉÒÔÓþֲ¿±äÁ¿Ö¸¶ ......
---¸½¼ÓÊý¾Ý¿â
sp_attach_db 'Êý¾Ý¿âÃû','Êý¾Ý¿âȫ·¾¶','Êý¾Ý¿âÈÕ־ȫ·¾¶'
---²é¿´Êý¾Ý¿âÂß¼ÎļþÃû
RESTORE FILELISTONLY from disk = '±¸·ÝÎļþ'
---»¹ÔÊý¾Ý¿â
restore database hzrb from disk = '±¸·ÝÎļþ'
with move 'Ö÷Âß¼Ãû' to '´æ·Åmdf·¾¶' ......
1 :ÆÕͨSQLÓï¾ä¿ÉÒÔÓÃexecÖ´ÐÐ
Select * from tableName
exec('select * from tableName')
exec sp_executesql N'select * from tableName' -- Çë×¢Òâ×Ö·û´®Ç°Ò»¶¨Òª¼ÓN
2:×Ö¶ÎÃû£¬±íÃû£¬Êý¾Ý¿âÃûÖ®Àà×÷Ϊ±äÁ¿Ê±£¬±ØÐëÓö¯Ì¬SQL
declare @fname varchar(20)
set @fname = 'FiledName'
Select @fname fr ......