SQL ³£ÓÃµÄ Ôö¡¢É¾¡¢¸Ä¡¢²é »¹ÊÇÀμÇÓÚÐÄ àÞ
¼¸¸ö¼òµ¥µÄ»ù±¾µÄsqlÓï¾ä
Ñ¡Ôñ£ºselect * from table1 where ·¶Î§
²åÈ룺insert into table1(field1,field2) values(value1,value2)
ɾ³ý£ºdelete from table1 where ·¶Î§
¸üУºupdate table1 set field1=value1 where ·¶Î§
²éÕÒ£ºselect * from table1 where field1 like ’%value1%’
ÅÅÐò£ºselect * from table1 order by field1,field2 [desc]
×ÜÊý£ºselect count ( *) as totalcount from table1
ÇóºÍ£ºselect sum(field1) as sumvalue from table1
ƽ¾ù£ºselect avg(field1) as avgvalue from table1
×î´ó£ºselect max(field1) as maxvalue from table1
×îС£ºselect min(field1) as minvalue from table1
³õѧÕß±ØÐëÕÆÎÕµÎ
Ïà¹ØÎĵµ£º
1. SQLÐÐתÁдúÂë
-
-
±íÀïÃæÓÐÕâôһ×éÊý¾Ý:
code price
'MCU0-3' 15
'MCU0-3' 20
'MCU0-3' 22
'MCU ......
½ñÌìµ÷ÊÔ·þÎñÆ÷£¬´´½¨ÁËÒ»¸öеÄÊý¾Ý¿âÓû§£¬Ïë¸øËû·ÖÅäЩȨÏÞ£¬¹ÜÀíÆäÖеÄÒ»¸öÊý¾Ý¿â¡£µ«ÊǵÈÒ»Çж¼´´½¨ºÃÁË£¬È´·¢ÏÖËûÁ¬µÇ½¶¼Ã»°ì·¨µÇ½¡£Ææ¹Ö£¬dbaµÄ½ÇÉ«¶¼¸øÁË»¹ÊDz»ÐС£
²é¿´ÎÊÌ⣬ÕÒ³ö½â¾ö·½°¸£º
ÆóÒµ¹ÜÀíÆ÷(2000)»òÕßmangement studioÁ¬½ÓÄãµÄʵÀý--ÓÒ¼üʵÀý--ÊôÐÔ--°²È«ÐÔÀïÃæ¿´¿´Éí·ÝÑé֤ģʽÊÇ·ñΪ"sql server ......
Æô¶¯Êý¾Ý¿âÓʼþ¹¦ÄÜ
sp_configure 'show advanced', 1;
GO
RECONFIGURE;
GO
sp_configure 'Database Mail XPs', 1;
GO
RECONFIGURE;
GO
-- ÅäÖÃÊý¾Ý¿âÓʼþ
-- Ìí¼ÓÓʼþÕË»§
execute msdb.dbo.sysmail_add_account_sp
@account_name = 'ÓÊÏäÕ ......
Êý¾Ý¿âÖеÄËùÓÐÊý¾Ý´æ´¢ÔÚ±íÖС£Êý¾Ý±í°üÀ¨ÐкÍÁС£Áоö¶¨Á˱íÖÐÊý¾ÝµÄÀàÐÍ¡£Ðаüº¬ÁËʵ¼ÊµÄÊý¾Ý¡£
ÀýÈ磬Êý¾Ý¿âpubsÖеıíauthorsÓоŸö×ֶΡ£ÆäÖеÄÒ»¸ö×Ö¶ÎÃûΪΪau_lname£¬Õâ¸ö×ֶα»ÓÃÀ´´æ´¢×÷ÕßµÄÃû×ÖÐÅÏ¢¡£Ã¿´ÎÏòÕâ¸ö±íÖÐÌí¼ÓÐÂ×÷Õßʱ£¬×÷ÕßÃû×־ͱ»Ìí¼Óµ½Õâ¸ö×ֶΣ¬²úÉúÒ»ÌõмǼ¡£
ͨ¹ý¶¨Òå×ֶ䪎 ......
Ò»¡¢»ù´¡
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname
3¡¢ËµÃ÷£º±¸·Ýsql server
--- ´´½¨ ±¸·ÝÊý¾ÝµÄ device
USE master
EXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssql7backup\MyNwind_1.dat'
--- ¿ªÊ¼ ±¸·Ý
BACKUP DATABASE pubs TO testBack
4¡¢Ë ......