Sql 2000 Êý¾Ý¿â±¸·ÝʵÀý
Êý¾Ý¿â±¸·ÝʵÀý/**
**Êý¾Ý¿â±¸·ÝʵÀý
**Öì¶þ 2004Äê5ÔÂ
**±¸·Ý²ßÂÔ:
**Êý¾Ý¿âÃû:test
**±¸·ÝÎļþµÄ·¾¶e:\backup
**ÿ¸öÐÇÆÚÌìÁ賿1µã×öÒ»´ÎÍêÈ«±¸·Ý,Ϊ±£ÏÕÆð¼û,±¸·Ýµ½Á½¸öͬÑùµÄÍêÈ«±¸·ÝÎļþtest_full_A.bakºÍtest_full_B.bak
**ÿÌì1µã(³ýÁËÐÇÆÚÌì)×öÒ»´Î²îÒ챸·Ý,·Ö±ð±¸·Ýµ½Á½¸öÎļþtest_df_A.bakºÍtest_df_B.bak(²ÉÓø½¼Óµ½Ô±¸·ÝµÄ·½Ê½)
**ÿһ¸öСʱ×öÒ»´ÎÊÂÎñÈÕÖ¾±¸·Ý,·Ö±ð±¸·Ýµ½Á½¸öÎļþtest_log_A.bakºÍtest_log_B.bak(²ÉÓø½¼Óµ½Ô±¸·ÝµÄ·½Ê½)
**/
--µÚÒ» ÍêÈ«±¸·Ý²¿·Ö
--ÐÂÔö×÷Òµ
EXEC sp_add_job @job_name = 'ÍêÈ«±¸·Ý'
--ÐÂÔö×÷Òµ²½Öè1,°ÑÊý¾Ý¿â±¸·Ýµ½test_full_backup_A.bak
EXEC sp_add_jobstep @job_name = 'ÍêÈ«±¸·Ý',
@step_name = 'Setp1',
@subsystem = 'TSQL',
@command = 'BACKUP DATABASE Test TO DISK=''e:\backup\test_full_A.bak'' WITH INIT',
@on_fail_action=3, --ʧ°Üºóתµ½ÏÂÒ»²½
@on_success_action=3,-- ³É¹¦ºóתµ½ÏÂÒ»²½
@retry_attempts = 5,
@retry_interval = 5
--ÐÂÔö×÷Òµ²½Öè2,°ÑÊý¾Ý¿â±¸·Ýµ½test_full_B.bak
EXEC sp_add_jobstep @job_name = 'ÍêÈ«±¸·Ý',
@step_name = 'Setp2',
@subsystem = 'TSQL',
@command = 'BACKUP DATABASE Test TO DISK=''e:\backup\test_full_B.bak'' WITH INIT',
@retry_attempts = 5,
@retry_interval = 5
--µ÷¶È
EXEC sp_add_jobschedule @job_name = 'ÍêÈ«±¸·Ý',
@name = 'Schedule_1',
@freq_type = 8, -- °´ÖÜ
@freq_interval = 1, --ÿÐÇÆÚÌìÖ´ÐÐ
@freq_recurrence_factor=1,
&n
Ïà¹ØÎĵµ£º
Ò»¡¢ ¼òµ¥²éѯ
¡¡¡¡¼òµ¥µÄTransact-SQL²éѯֻ°üÀ¨Ñ¡ÔñÁÐ±í¡¢from×Ó¾äºÍWHERE×Ӿ䡣ËüÃÇ·Ö±ð˵Ã÷Ëù²éѯÁС¢²éѯµÄ±í»òÊÓͼ¡¢ÒÔ¼°ËÑË÷Ìõ¼þµÈ¡£
¡¡¡¡ÀýÈ磬ÏÂÃæµÄÓï¾ä²éѯtesttable±íÖÐÐÕÃûΪ“ÕÅÈý”µÄnickname×ֶκÍemail×ֶΡ£
¡¡¡¡SELECT nickname,email
¡¡¡¡from testtable
¡¡¡¡WHERE name='ÕÅÈý'
......
¹Ø¼ü×Ö: oracle & sql server
Êý¾ÝÀàÐͱȽÏ
ÀàÐÍÃû³Æ
Oracle
SQLServer
±È½Ï
×Ö·ûÊý¾ÝÀàÐÍ CHAR CHAR ¶¼Êǹ̶¨³¤¶È×Ö·û×ÊÁϵ«oracleÀïÃæ×î´ó¶ÈΪ2kb£¬SQLServerÀïÃæ×î´ó³¤¶ÈΪ8kb
±ä³¤×Ö·ûÊý¾ÝÀàÐÍ VARCHAR2 VARCHAR OracleÀïÃæ×î´ó³¤¶ÈΪ4kb£¬SQLServerÀïÃæ×î´ó³¤¶ÈΪ8kb
¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¹Ì¶¨³¤¶È×Ö· ......
SQL ServerÊý¾Ý¿â²éѯËÙ¶ÈÂýµÄÔÒòÓкܶ࣬³£¼ûµÄÓÐÒÔϼ¸ÖÖ£º
1¡¢Ã»ÓÐË÷Òý»òÕßûÓÐÓõ½Ë÷Òý(ÕâÊDzéѯÂý×î³£¼ûµÄÎÊÌ⣬ÊdzÌÐòÉè¼ÆµÄȱÏÝ)
2¡¢I/OÍÌÍÂÁ¿Ð¡£¬ÐγÉÁËÆ¿¾±Ð§Ó¦¡£
3¡¢Ã»Óд´½¨¼ÆËãÁе¼Ö²éѯ²»ÓÅ»¯¡£
4¡¢ÄÚ´æ²»×ã
5¡¢ÍøÂçËÙ¶ÈÂý
6¡¢²éѯ³öµÄÊý¾ÝÁ¿¹ý´ó(¿ÉÒÔ²ÉÓöà´Î²éѯ£¬ÆäËûµÄ·½·¨½µµÍÊý¾ÝÁ¿)
7¡¢Ëø»òÕß ......
CareGroup Ò½ÁÆ×éÖ¯¸ºÔð±£»¤2TB µÄ²¡ÈËÐÅÏ¢ºÍÏà¹ØÊý¾ÝµÄÒþ˽¼°ÍêÕûÐÔ¡£¸Ã×é֯λÓÚ²¨Ê¿¶Ù£¬ÊÇBeth Israel Deaconess ҽѧÖÐÐÄ£¨¹þ·ðҽѧԺµÄ½ÌѧҽԺ£©ÒÔ¼°ÁíÍâÈý¼ÒµØÇøÒ½ÔºµÄĸ¹«Ë¾¡£CareGroup ²ÉÓÃMicrosoft® SQL Server™ 2005£¬½«ÆäÊý¾Ý´æ´¢ÓÚ30¸öʵÀýµÄ390¸öÊý¾Ý¿âÖС£¸Ã×é֯ϣÍû½«Êý¾Ý¿âÉý¼¶µ½SQL Server 200 ......
Ôʼ±í£º
name course score
-----------------------------------------
ÕÅÈý ÓïÎÄ 80
ÕÅÈý & ......