SQL Select IntoÓï¾ä
SQL Select IntoÓï¾ä
The SELECT INTO Statement
SELECT INTO Óï¾ä
The SELECT INTO statement is most often used to create backup copies of tables or for archiving records.
SELECT INTOÓï¾ä³£ÓÃÀ´¸øÊý¾Ý±í½¨Á¢±¸·Ý»òÊÇÀúÊ·µµ°¸¡£
Syntax
Óï·¨
SELECT column_name(s) INTO newtable [IN externaldatabase] from source
Make a Backup Copy
ÖÆ×÷Ò»¸ö±¸·Ý
The following example makes a backup copy of the "Persons" table:
ÏÂÃæµÄÀý×ÓÖлáΪ"Persons"±íÖÆ×÷Ò»¸ö±¸·Ý
SELECT * INTO Persons_backupfrom Persons
The IN clause can be used to copy tables into another database:
IN×Ó¾ä¿ÉÒÔÓÃÀ´½«¶à¸öÊý¾Ý±í¿½±´µ½ÁíÒ»¸öÊý¾Ý¿âÉÏ£º
SELECT Persons.* INTO Persons IN 'Backup.mdb'from Persons
If you only want to copy a few fields, you can do so by listing them after the SELECT statement:
Èç¹ûÄã½ö½öÏ뿽±´ÆäÖеÄÒ»²¿·Ö£¬¿ÉÒÔÔÚSELECTºóÃæÁоٳöËüÃÇ£º
SELECT LastName,FirstName INTO Persons_backupfrom Persons
You can also add a WHERE clause. The following example creates a "Persons_backup" table with two columns (FirstName and LastName) by extracting the persons who lives in "Sandnes" from the "Persons" table:
Ä㻹¿ÉÒÔ¼ÓÉÏWHERE×Ӿ䡣ÔÚÏÂÃæµÄ¾ÙÀýÖлὨÁ¢Ò»¸ö"Persons_backup"±í£¬ÀïÃæ°üº¬ÁËÔÚ"Persons"±íÖÐסÔÚ"Sandnes"µÄ¸öÈËÐÕ(LastName)ÓëÃû(FirstName)ÐÅÏ¢¡£
SELECT LastName,Firstname INTO Persons_backupfrom PersonsWHERE City='Sandnes'
Selecting data from more than one table is also possible. The following example creates a new table "Empl_Ord_backup" that contains data from the two tables Employees and Orders:
Ñ¡Ôñ¶à¸ö±í½øÐб¸·ÝÒ²ÊÇ¿ÉÒԵġ£ÏÂÃæµÄ¾ÙÀý¾Í½¨Á¢ÁËÒ»¸öеıí"Empl_Ord_backup"ÀïÃæµÄÊý¾Ý¾ÍÓÐEmployeesºÍOrdersÕâÁ½ÕűíµÄÄÚÈÝ£º
SELECT Employees.Name,Orders.ProductINTO Empl_Ord_backupfrom EmployeesINNER JOIN OrdersON Employees.Employee_ID=Orders.Employee_ID
Ïà¹ØÎĵµ£º
VS2010ÒѾ·¢²¼¼¸Ììʱ¼äÁË£¬Ò»Ð©ÐµÄÌØÐÔÌرðÒýÈËעĿ£¬±ÈÈ磺 ÐÔÄܵÄÎȶ¨ºÍÌáÉý£¬±íÏÖÔÚWPF GUIºÍWPFÎı¾³ÊÏÖ¡£ Windows Azure ToolsÄ£°å¡£ ¶àÏÔʾÆ÷Ö§³Ö£¬Êä³ö´°¿Ú£¬Ààͼ´°¿Ú£¬´úÂ붨Òå´°¿ÚµÈÌṩ¸¨ÖúÐÅÏ¢µÄ´°¿Ú·ÅÖÃÔÚ¸±ÏÔʾÆ÷ÖС£ ¶Ô²¢ÐмÆË㿪·¢µÄ´óÁ¿Ö§³Ö¡£ °üº¬ÁËSharePointµÄÏîÄ¿Ä£°åºÍµ÷ÊÔÖ§³Ö ......
Ê×ÏÈ˵Ã÷Ò»µã£ºVC³ÌÐòÖÐÓÃADOÁ¬½ÓSQL Server 2005 ºÍÁ¬½Ó SQL Server 2000µÄÓï¾äºÍÁ¬½Ó×Ö·û´®ÊÇÍêÈ«Ò»ÑùµÄ£¬ÏÂÃæµÄ´úÂëÊÊÓÃÓÚÁ½¸öÊý¾Ý¿âµÄÁ¬½Ó¡£
ÁíÒ»µã˵Ã÷£ºÈç¹ûÄãÒÔÇ°°²×°¹ýSQL Server 2000£¬ºóÔÚûÓÐжÔصÄÇé¿öÏÂÓÖ°²×°ÁË2005£¬ÄÇôÄã֮ǰÔÚ2000ÖÐÉèÖõÄÓû§ÃûºÍÃÜÂëÔÚ2005Öлᱣ³Ö£¬¼´Ê¹Äã°²×°2005ʱδÉèÖÃÈκÎÓû§Ãû ......
תÖÁhttp://mbtk.blog.sohu.com/150003773.html £¬²¢²¹³äһЩÏà¹Ø֪ʶ¡£
DBCC ErrorLog £ºÈç¹ûºÜÉÙÖØÆðmssqlserver·þÎñ£¬ÄÇô·þÎñÆ÷µÄÈÕÖ¾»áÔö³¤µÃºÜ¿ì£¬¶øÇÒ´ò¿ªºÍ²é¿´ÈÕÖ¾µÄËÙ¶ÈÒ²»áºÜÂý¡£Ê¹ÓÃÕâ¸öÃüÁ¿ÉÒԽضϵ±Ç°µÄ·þÎñÆ÷ÈÕÖ¾£¬Ö÷ÒªÊÇÉú³ÉÒ»¸öеÄÈÕÖ¾¡£¿ÉÒÔ¿¼ÂÇÉèÖÃÒ»¸öµ÷¶ÈÈÎÎñ£¬Ã¿ÖÜÖ´ÐÐÕâ¸öÃüÁî×Ô¶¯½Ø¶Ï·þÎ ......
sql replace Ìæ»»×Ö¶ÎÖв¿·ÝÖ¸¶¨ÄÚÈÝ
´´½¨Êý¾Ý¿â½Ì³Ì
create database cnnet;
´´½¨Êý¾Ý±í
CREATE TABLE `cnnet`.`test` (
`id` INT( 4 ) NOT NULL AUTO_INCREMENT ,
`url` VARCHAR( 50 ) NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM
²å¼¸ÌõÊý¾Ý:
INSERT INTO `test` (`id`, `url`) VALUES
(1, 'www.1aa.cm' ......