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

SQL SERVER 2005Á·Ï°¼¯1

ÈëÃÅÆª
//////////////////////////////////////////// ­
%  : ±íʾ0~n¸öÈÎÒâ×Ö·û ­
_  : ±íʾµ¥¸öÈÎÒâ×Ö·û ­
[] :±íʾÔÚÀ¨ºÅÀïÁгöµÄÈÎÒâ×Ö·û ­
[^]:±íʾÈÎÒâ¸öûÓÐÔÚÀ¨ºÅÖÐÁгöµÄ×Ö·û ­
***********************­
ϵͳÊý¾Ý¿â­
MASTERÊý¾Ý¿â:­
  ¼Ç¼×ÅSQL SERVER2005ϵͳÖеÄËùÓÐϵͳ¼¶±ðµÄÐÅÏ¢,°üÀ¨ËùÓеĵǼÕÊ»§ºÍϵͳÅäÖÃÒÔ¼°Ëù°üº¬µÄÊý¾Ý¿â¡¢­
Êý¾ÝÎļþµÄλÖã»ÊÇSQL SERVERÆô¶¯µÄµÚÒ»¸öÈë¿Ú£¬ÊÇËùÓÐϵͳÊý¾Ý¿âÖеÄÖØÖÐÖ®ÖØ£¬Ò»µ«Ë𻵾ÍÎÞ·¨Æô¶¯SQL­
SERVER¡£­
MODELÊý¾Ý¿â£º­
  ÊÇн¨Êý¾Ý¿âµÄÄ£°å¡£­
TEMPDBÊý¾Ý¿â£º­
  ±£´æÁËËùÓеÄÁÙʱ±íºÍÁÙʱ´æ´¢¹ý³Ì¡£­
MSDBÊý¾Ý¿â£º­
  ÌṩÁËSQL SERVER2005´úÀí³ÌÐòµ÷¶È¡¢±¨¾¯¡¢×÷ÒµÒÔ¼°¼Ç¼²Ù×÷Ô±µÈ»î¶¯¡£­
///////////////////////////////////////// ­
use demo ­
go ­
/*´´½¨Óû§×Ô¶¨Òå(newtype)Êý¾ÝÀàÐÍ*/ ­
/*exec sp_addtype newtype ,"char(10)" ­
go*/ ­
/*ɾ³ý×Ô¶¨Òå(newtype)Êý¾ÝÀàÐÍ*/ ­
/*exec sp_droptype newtype ­
go*/ ­
/*¸ü¸Ä±íµÄÊôÐÔ*/ ­
/*alter  table family ­
alter column id  int not null ­
go*/ ­
/*´´½¨Ò»¸ö´æ´¢Ô±¹¤ÐÅÏ¢µÄ±í*/ ­
/*create table employee ­
( ­
  /*Ϊ±íÁвúÉúÒ»¸ö×Ô¶¯Éú³ÉµÄÐòºÅ*/ ­
  id  int identity(1,1), ­
  [name] char(20), ­
  gender  char(4) ­
) ­
go*/ ­
/*²é¿´±íµÄÊôÐÔ*/ ­
execute sp_help employee ­
go ­
//////////////////////////////////////////// ­
use  school ­
go ­
/*create  table student ­
( ­
  id  int not null,--ѧºÅ ­
  [name]  char(20), ­
  gender  char(2),--ÐÔ±ð ­
  age   smallint, ­
  grade  smallint,--Äê¼¶ ­
  class  smallint, ­
  tercher_id  int, ­
  parents_id &n


Ïà¹ØÎĵµ£º

sql server 2005µÄĬÈϵǼÃû

 BUILTIN\Administrators
-- Õâ¸öÊÇAdmin×éµÄȨÏÞ,ĬÈÏÇé¿öϱ¾µØAdmin¶¼Á¥ÊôÓÚÕâ¸ö×é,¾ßÓбȽϴóµÄȨÏÞ,
-- ×÷ΪWindows¼¯³ÉµÇ¼,Èç¹ûʹÓõÄÊǹÜÀíÔ±,¾Í»áʹÓõ½Ëü,
HC811\ASPNET
-- Õâ¸öÊÇASPNETÓ¦ÓõķÃÎÊÕʺÅ×é,
HC811\SQLServer2005MSFTEUser$HC811$MSSQLSERVER
-- Õâ¸öÊÇÈ«ÎÄË÷ÒýµÄ·ÃÎÊÕʺ ......

DB2 SQL ¾«Òª £¨³ÖÐø¸üÐÂÖÐ.......£©

----start
      ·²ÊÇÖªµÀÊý¾Ý¿âµÄÈ˶¼ÖªµÀSQL£¬·²ÊǶÔSQLÓÐÒ»µãÁ˽âµÄÈ˶¼¾õµÃSQLºÜ¼òµ¥£¬·²ÊÇÓÐÕâÖָоõµÄÈ˶¼ÊÇSQLµÃ³õ¼¶Óû§£¬ÒòΪËûѧ»áÁËÔö²éɾ¸Ä¾ÍÒÔΪÕâ¾ÍÊÇSQLµÄÈ«²¿¡£Ä¿Ç°µÄ´ó²¿·ÖÓ¦ÓÃÈí¼þ¶¼ÊÇÒÔÊý¾Ý¿âΪÖÐÐÄ£¬Ëæ×ÅÈí¼þµÄÔËÐУ¬Êý¾ÝÁ¿»áÔ½À´Ô½´ó¡£ÈçºÎÓüò½à¡¢¸ßЧµÄSQLÓï¾ä²Ù×÷Êý¾ÝÏÔµÃÔ½À ......

SQLÒ»¸ö´æ´¢¹ý³Ìµ÷ÓÃÁíÒ»¸ö´æ´¢¹ý³Ì »ñµÃ·µ»ØÖµÎÊÌâ

µÚÒ»ÖÖ·½·¨: ʹÓÃoutput²ÎÊý
USE AdventureWorks;
GO
IF OBJECT_ID ( 'Production.usp_GetList', 'P' ) IS NOT NULL
    DROP PROCEDURE Production.usp_GetList;
GO
CREATE PROCEDURE Production.usp_GetList @product varchar(40)
    , @maxprice money
    , ......

½â¾öͬʱÐÞ¸ÄͬһSQL¼Ç¼µÄÎÊÌâ

ÔÚѰÕÒPowerDesignerÏà¹ØÐÅÏ¢µÄʱºòżȻ·¢ÏÖµÄ.ʹÓÃtimestamp
΢ÈíMSDNÄÚÈÝ:
timestamp (Transact-SQL)
¹«¿ªÊý¾Ý¿âÖÐ×Ô¶¯Éú³ÉµÄΨһ¶þ½øÖÆÊý×ÖµÄÊý¾ÝÀàÐÍ¡£timestamp ͨ³£ÓÃ×÷¸ø±íÐмӰ汾´ÁµÄ»úÖÆ¡£ ´æ´¢´óСΪ 8 ¸ö×Ö½Ú¡£ timestamp Êý¾ÝÀàÐÍÖ»ÊǵÝÔöµÄÊý×Ö£¬²»±£ÁôÈÕÆÚ»òʱ¼ä¡£ ÈôÒª¼Ç¼ÈÕÆÚ»òʱ¼ä£¬ÇëʹÓà datetime ......

SQL 2005 tips

USE tempdb
GO
CREATE TABLE AuctionItems
(
  itemid       INT          NOT NULL PRIMARY KEY NONCLUSTERED,
  itemtype     NVARCHAR(30) NOT NULL,
  whenmade     INT&nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ