SQL Server 2005 T SQL ÖеÄOUTPUT×Ó¾äÓï·¨
OUTPUT×Ó¾äÊÇSQL Server 2005 ÖжÔINSERT¡¢UPDATEºÍDELETEÐÂÔöµÄ£¬½ñÌì¿´¼ûÔ°×ÓÀïÓÐÈËÌáÆð(SQL2005Öзµ»ØÐ޸ĺóµÄÊý¾Ý)£¬¾ÍÔÚÕâÀï¼Ç¼һÏÂËüµÄÓï·¨¡£
OUTPUT { DELETED | INSERTED | from_table_name }. {* | column_name } [,...n]
INTO { @table_variable | output_table }
²ÎÊý˵Ã÷£º
DELETED , INSERTED ºÍ´¥·¢Æ÷ÀïµÄÒ»Ñù£¬ÊÇϵͳµÄÐéÄâ±í,ËûÃDZ£´æÁËÒÔ¸üеÄÔʼºÍÐÞ¸ÄÖ®ºóµÄÖµ¡£
ÏÂÃæÊÇÒ»¸öÍêÕûµÄÀý×Ó£º
´´½¨±í£º
CREATE TABLE product(
productId INT IDENTITY PRIMARY KEY,
Name NVARCHAR(50)
)
²åÈëÊý¾Ý£º
INSERT INTO product([Name])VALUES('MP3');
²âÊÔOUTPUT:
DECLARE @ProductChanges TABLE (
DeletedName NVARCHAR(50),
InsertedName NVARCHAR(50)
)
UPDATE product
SET Name='myname'
OUTPUT DELETED.Name,INSERTED.Name
INTO @ProductChanges
WHERE productId=1
SELECT DeletedName,InsertedName
from @ProductChanges
Ö´Ðнá¹û£º
DeletedName InsertedName
1 MP3 myname
Ïà¹ØÎĵµ£º
Êý¾Ý¿âÃæÊÔ³£ÓòâÊÔÌâ(SQL Server)
ÌâÄ¿1
¡¡¡¡ÎÊÌâÃèÊö:
¡¡¡¡Îª¹ÜÀí¸ÚλҵÎñÅàѵÐÅÏ¢£¬½¨Á¢3¸ö±í:
¡¡¡¡S (S#,SN,SD,SA) S#,SN,SD,SA ·Ö±ð´ú±íѧºÅ¡¢Ñ§Ô±ÐÕÃû¡¢ËùÊôµ¥Î»¡¢Ñ§Ô±ÄêÁä
¡¡¡¡C (C#,CN ) C#,CN ·Ö±ð´ú±í¿Î³Ì±àºÅ¡¢¿Î³ÌÃû³Æ
¡¡¡¡SC ( S#,C#,G ) S#,C#,G ·Ö±ð´ú±íѧºÅ¡¢ËùÑ¡Ð޵Ŀγ̱àºÅ¡¢Ñ§Ï°³É¼¨
¡¡¡¡1. Ê¹Ó ......
֮ǰΪÁË·½±ã²Ù×÷¾ÍÔÚSql ServerµÄÆóÒµ¹ÜÀíÆ÷Àï×¢²áÁËÔ¶³Ì·þÎñÆ÷£¬µ«ÊÇÇ°Ò»¶Îʱ¼äÔÚÔ¶³Ì·þÎñÆ÷ÉÏÐÞ¸ÄÁ˸ÃÊý¾Ý¿âµÄÃÜÂ룬ÿ´Îµã»÷¸Ã×¢²á·þÎñÆ÷ϵͳҪµÈºÜ³¤Ê±¼ä£¬ÏóËÀ»úÒ»Ñù£»ÐÞ¸ÄÁ¬½ÓÊôÐÔÒ²Ð޸IJ»ÁË£¬µã»÷ºóҲûÓз´Ó¦£¬ÓÚÊǾÍÏëɾ³ýÖØÐÂ×¢²á£¬¼ÈÈ»ÎÞ·¨ÔÚ¹ÜÀíÆ÷Àïɾ³ý£¬¾ÍÏë´Ó×¢²á±íÀïɾ³ý£¬ÕÒÁ˺þÃÖÕÓÚÕÒµ½ÁË£¬¶ÔÓ¦µÄsql ......
1. еIJúÆ·°æ±¾
³ýSQL Server 2005±ê×¼°æºÍÆóÒµ°æÖ®Í⣬²úÆ·ÏßÖл¹¼ÓÈëÁËSQL Server 2005¼ò»¯°æ£¨SQL Server 2005 Express£©ºÍ¹¤×÷×é°æ£¨SQL Server 2005 Workgroup£©Á½¸öа汾¡£
SQL Server 2005 Express——Æä×÷ÓÃÊÇ´úÌæ΢ÈíSQL Server×ÀÃæÒýÇ棨Microsoft SQL Server Desktop Engine£¬MSDE£©¡£SQL Serve ......
ת×Ô£ºhttp://www.sqlkey.cn/sql-yuju/sql_yuju.html
Ò»¡¢»ù´¡
1¡¢ËµÃ÷£º´´½¨Êý¾Ý¿â
CREATE DATABASE database-name
2¡¢ËµÃ÷£ºÉ¾³ýÊý¾Ý¿â
drop database dbname
3¡¢ËµÃ÷£º±¸·Ýsql server
--- ´´½¨ ±¸·ÝÊý¾ÝµÄ device
USE master
EXEC sp_addumpdevice 'disk', 'testBack', 'c:\mssql7backup\MyNwind_1.d ......
±¾ÖÜ
select * from tb where datediff(week , ʱ¼ä×ֶΠ,getdate()) = 0
ÉÏÖÜ
select * from tb where datediff(week , ʱ¼ä×ֶΠ,getdate()) = 1
ÏÂÖÜ
select * from tb where datediff(week , ʱ¼ä×ֶΠ,getdate()) = -1
------------------------------------------------------------------------------------ ......