Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

SQL Server 2008 ¶Ô T SQL ÓïÑÔµÄÔöÇ¿

Microsoft SQL Server 2008 ¶Ô T-SQL ÓïÑÔ½øÐÐÁ˽øÒ»²½ÔöÇ¿¡£ÎªÁËÈÿª·¢ÈËÔ±¾¡¿ìÁ˽âÕâЩ±ä»¯£¬ÎÒÃÇÕë¶Ô 2007 Äê 6 Ô CTP °æ±¾µÄ SQL Server 2008 ÖÐµÄ T-SQL ÓïÑÔµÄÐÂÔö¹¦ÄܽøÐÐÁË·ÖÎöºÍ³¢ÊÔ¡£±¾ÎÄÃèÊö×Ô SQL Server 2008 CTP1 ÒÔÀ´ÕâЩÓïÑÔÔöÇ¿ºÍ±ä»¯¡£
¡¡¡¡±¾ÎÄ°üº¬ÈçÏÂÄÚÈÝ£º
¡¡¡¡· T-SQL Ðй¹ÔìÆ÷
¡¡¡¡· FORCESEEK ±íÌáʾ
¡¡¡¡· GROUPING SETS
¡¡¡¡· ¼æÈÝÐÔ¼¶±ð
¡¡¡¡· Óû§×Ô¶¨Òå±íÊý¾ÝÀàÐÍ
¡¡¡¡· ±íÖµ²ÎÊý
¡¡¡¡· MERGE Óï¾ä
¡¡¡¡±¾ÎÄÊÊÓÃÓÚ£ºMicrosoft)R) SQL Server(TM) 2008 Developer Edition June 2007 CTP
¡¡¡¡1¡¢T-SQL Ðй¹ÔìÆ÷
¡¡¡¡T-SQL Ðй¹ÔìÆ÷(Row Constructors)ÓÃÀ´ÔÚ INSERT Óï¾äÖÐÒ»´ÎÐÔ²åÈë¶àÐÐÊý¾Ý¡£ÀýÈ磺
CREATE TABLE #a
(
¡¡¡¡Column1 nvarchar(max),
¡¡¡¡Column2 nvarchar(max)
);
GO
INSERT INTO #a
VALUES (
('1', '1'),
('2', '2')
);
SELECT * from #a;
GO
DROP TABLE #a;
GO
¡¡¡¡¾­¹ýÔöÇ¿ºóµÄ INSERT Óï¾äµÄÓï·¨½á¹¹ÈçÏ¡£
[ WITH <common_table_expression> [ ,...n ] ]
INSERT
¡¡¡¡[ TOP ( expression ) [ PERCENT ] ]
¡¡¡¡[ INTO ]
¡¡¡¡{ <object> | rowset_function_limited
¡¡¡¡¡¡[ WITH ( <Table_Hint_Limited> [ ...n ] ) ]
¡¡¡¡}
{
¡¡¡¡[ ( column_list ) ]
¡¡¡¡[ <OUTPUT Clause> ]
¡¡¡¡{ VALUES ( ( { DEFAULT | NULL | expression } [ ,...n ] ) [ ,...n ] )
¡¡¡¡| derived_table
¡¡¡¡| execute_statement
¡¡¡¡| <dml_table_source>
¡¡¡¡| DEFAULT VALUES
¡¡¡¡}
}
[; ]
<object> ::=
{
¡¡¡¡[ server_name . database_name . schema_name .
¡¡¡¡¡¡| database_name .[ schema_name ] .
¡¡¡¡¡¡| schema_name .
¡¡¡¡]
¡¡¡¡¡¡¡¡table_or_view_name
}
<dml_table_source> ::=
¡¡¡¡SELECT <select_list>
¡¡¡¡from ( <dml_statement_with_output_clause> )
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡[AS] table_alias [ ( column_alias [ ,...n ] ) ]
¡¡¡¡¡¡¡¡[ WHERE <search_condition> ]
¡¡¡¡[ OPTION ( <query_hint> [ ,...n ] ) ]
¡¡¡¡2. FORCESEEK Ìáʾ
FORCESEEK ÊÇÒ»¸öеıíÌáʾ(Table Hints)£¬ËüÓÃÀ´Ö¸¶¨ SQL Server ²éѯÓÅ»¯³ÌÐòÈçºÎ¸ü¸ßЧµÄÖ´Ðвéѯ¡£¸ÃÌáʾָʾÓÅ»¯³ÌÐò¶Ô²éѯÒýÓõıíºÍÊÓͼͨ¹ýË÷Òý¼ìË÷À´×÷ΪΨһµÄ²éѯִÐзÃÎ


Ïà¹ØÎĵµ£º

SQL SERVER ÊÓͼ Garin Zhang

ÊÓͼ
SET¡¡NOCOUNT ON;
SET Northwind;
GO
IF OBJECT_ID('dbo.ViewName') IS NOT NULL
    DROP VIEW dbo.ViewName;
GO
CREATE VIEW dbo.Viewname
AS
SELECT * from customer AS C
WHERE EXISTS
    (SELECT * from dbo.Orders AS O
     WHERE O.CustomerI ......

Sql server 2000 µÄµÈ´ýÏìӦʱ¼ä

     Ç°Ò»¶Îʱ¼äÔÚά»¤Ò»¸öÀÏÏîÄ¿µÄʱºò·¢ÏÖ£¬ÔÚÖ´ÐÐÒ»¸ö½Ï´óµÄ´æ´¢¹ý³Ìʱ£¬×ÜÊDZ¨“³£¹æÍøÂç´íÎó£¬Çë¼ì²éÄúµÄÍøÂçÎĵµ”¡£ÔÚºóÐøµÄά»¤¼ì²éÖз¢ÏÖ£¬ÊÇÊÂÎﳬʱµ¼ÖÂÖ´ÐÐÖÐÖ¹µÄ¡£
     ÏÂÃæÊǵ÷Õû¹ý³Ì£º
      Ò»¡¢°ÑSQL SERVERµÄµÈ´ýÏìӦʱ¼ ......

Éî¶È¶Ô±ÈOracleÓëSQL Server——µÚÈý²¿·Ö

Æô¶¯ÓëÅäÖòÎÊý ¸ü¸ÄϵͳԪÊý¾ÝºÍ²ÎÊýÅäÖà ¶¯Ì¬ÊÓͼ ´æ´¢µÄÎïÀíºÍÂß¼­½á¹¹ Æô¶¯ºÍ¹Ø±Õ
topÆô¶¯ÓëÅäÖòÎÊý
ÔÚSQL Server°²×°µÄʱºò£¬Í¬Ê±Ò²»áÍùWindows×¢²á±íÀïÃæÌí¼ÓһЩ¼Ç¼£¬ÕâЩע²á±í¼üÖµÖ¸¶¨ÁËʵÀýËùÐèÒªµÄ¸÷ÖÖ²ÎÊý¡£±ÈÈ磬ÓеÄ×¢²á±í¼üÖµÖ¸¶¨ÁË´íÎóÈÕÖ¾µÄ±£´æĿ¼£¬ÁíÍâµÄÖ¸¶¨ÁËĬÈϵı¸·ÝĿ¼µÈµÈ¡£SQL ServerÔÚÔ ......

SQL »ù±¾²Ù×÷ ɾ³ý ÐÞ¸Ä Ë¢ÐÂ

SQLµÄ²Ù×÷£º
E.g.
judging-±íÃû
userid, name, password-±íÖеĹؼü×Ö
Ìí¼Ó£º
string sql = "insert into judging (userid,name,password) values('" + userid.Text.Trim() + "','" + name.Text.Trim() + "','" + password.Text.Trim() + "')";
 
ɾ³ý£º
string sql = "delete from judging where userid=" + ......

SQL ServerÖÐtimestamp£¨Ê±¼ä´Á£©


SQL ServertimestampÊý¾ÝÀàÐÍÓëʱ¼äºÍÈÕÆÚÎ޹ء£SQL ServertimestampÊǶþ½øÖÆÊý×Ö£¬Ëü±íÃ÷Êý¾Ý¿âÖÐÊý¾ÝÐ޸ķ¢ÉúµÄÏà¶Ô˳Ðò¡£ÊµÏÖtimestampÊý¾ÝÀàÐÍ×î³õÊÇΪÁËÖ§³Ö SQL Server »Ö¸´Ëã·¨¡£Ã¿´ÎÐÞ¸Äҳʱ£¬¶¼»áʹÓõ±Ç°µÄ @@DBTS Öµ¶ÔÆä×öÒ»´Î±ê¼Ç£¬È»ºó @@DBTS ¼Ó1¡£ÕâÑù×ö×ãÒÔ°ïÖú»Ö¸´¹ý³ÌÈ·¶¨Ò³Ð޸ĵÄÏà¶Ô´ÎÐò£¬µ«ÊÇtimest ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ