set cnn=Server.createobject("adodb.connection")
cnn.open "driver={SQL Server};Server=æå¡å¨å;uid=sa;pwd="
cnn.execute SQL
on error resume next
if err<>0 then
response.write "é误ï¼"&err.Descripting
else
response.write "æ°æ®å¤ä»½æåï¼"
end if
%>
2ãæ¢å¤
<%
SQL="Restore database æ°æ®åºå from disk='"&Server.MapPath("backup")&"\"&"backuptext.dat"&"'"
set cnn=Server.createobject("adodb.connection")
cnn.open "driver={SQL Server};Server=æå¡å¨å;uid=sa;pwd="
cnn.execute SQL
on error resume next
if err<>0 then
response.write "é误ï¼"&err.Descripting
else
response.write "æ°æ®æ¢å¤æåï¼"
end if
%>
注ï¼ä»¥ä¸è¯å¥æ¯ææ°æ®å¤ä»½å°ç£ççbackupç®å½ä¸ï¼æ件å为backuptext.datã
2ãASPä¸è½ä¿®æ¹SQLæ°æ®åºç»æåï¼
çï¼ALTER TABLE
å称
ALTER TABLE â æ´æ¹è¡¨å±æ§
è¯æ³
ALTER TABLE table [ * ]
ADD [ COLUMN ] column type
ALTER TABLE table [ * ]
ALTER [ COLUMN ] column { SET DEFAULT value | DROP DEFAULT }
ALTER TABLE table [ * ]
RENAME [ COLUMN ] column TO newcolumn
ALTER TABLE table
RENAME TO newtable
ALTER TABLE table
ADD table constraint definition
Inputs
table
è¯å¾æ´æ¹çç°å表çå称ï¼
column
ç°åææ°çåå称ï¼
type
æ°åçç±»åï¼
newcolumn
ç°ååçæ°å称ï¼
newtable
表çæ°å称ï¼
table constraint definition
表çæ°ç约æå®ä¹ï¼
New table constraint for the table
è¾åº
ALTER
ä»è¢«æ´åçåæ表è¿åçä¿¡æ¯ï¼
ERROR
å¦æä¸ä¸ªåæ表ä¸åå¨è¿åçä¿¡æ¯ï¼
æè¿°
ALTER TABLE åæ´ä¸ä¸ªç°å表çå®ä¹ï¼ADD COLUMN å½¢å¼ç¨ä¸ CREATE TABLEä¸æ ·çè¯æ³å表ä¸å¢å ä¸ä¸ªæ°å/å段ãALTER COLUMN å½¢å¼å
è®¸ä½ ä»å/å段ä¸è®¾ç½®æè
å é¤ç¼ºçï¼å¼ï¼ã注æ缺çï¼å¼ï¼åªå¯¹æ°æå
¥çè¡ææãRENAME åå¥å¯ä»¥å¨ä¸å½±åç¸å
³è¡¨ä¸ä»»ä½æ°æ®çæ
åµä¸æ´æ¹ä¸ä¸ªè¡¨æè
å/å段çå称ãå æ¤ï¼è¡¨æå/å段å¨æ¤å½ä»¤æ§è¡åä»å°æ¯ç¸å尺寸åç±»åãADD table constraint definition åå¥ç¨ä¸ CREATE TABLEä¸æ ·çè¯æ³å表ä¸å¢å ä¸ä¸ªæ°ç约æã