SQL Server Êý¾Ý¿â
a.Êý¾Ý¿â»ù´¡
i.¸ÅÄ±í¼°Ïà¹Ø²Ù×÷¶ÔÏóµÄ¼¯ºÏ£¨Ö÷Êý¾ÝÎļþmdf£¬¶þ¼¶Êý¾ÝÎļþndf£¬ÈÕÖ¾ldf£©
ii.×é³É£ºÏµÍ³£º master(¼Ç¼ÁËËùÓеķþÎñÆ÷ϵͳÐÅÏ¢)
,model£¨¼Ç¼ÁËËùÓÐÁÙʱ¼Ç¼£¬Á´½Ó¶Ï¿ªÊ±£¬Êý¾Ý¶ªÊ§£©
Tempdb£¨Êý¾ÝÄ£°å¿â£¬º¬´´½¨¿âʱµÄȱʡÊý¾Ý£©
,msdb £¨µ÷¶È¿â£¬´úÀí³ÌÐòµ÷¶È¾¯±¨ºÍ×÷Òµ£©
Óû§£ºpubs,northwind,user
b.½¨¿â
crate database data1
on
(
Name=da_dat,filename=’f:\data1.mdf’,
Size=10,
Maxsize=50,
Filegrowth=5
)
Log on
(
Name=’da_log’,filename=’f:\data1.ldf’,
Size=5,
Maxsize=25,
Filegrowth=5
)
C.Ð޸Ŀâ
i.Ìí¼Ó alter database data1
add file
(
Name=file2,filename=’f:\grpfile2.ndf’,size=5,maxsize=25,filegrowth=1
)
ii.ɾ³ý£» drop database
iii;ÖØÃüÃû£»sp_rename
iiii;²é¿´Êý¾Ý¿â£»sp_helpdb
D.Êý¾ÝÍêÕûÐÔ (±£Ö¤Êý¾ÝµÄÒ»ÖÂÐÔºÍÕýÈ·ÐÔ)
a. ʵÌåÐÔ£¨±£Ö¤Äܱ»Ö÷¼üÊôÐÔ±êʶ£©
b. ÓòÍêÕûÐÔ £¨±£Ö¤Ä³Ò»·¶Î§ÄÚµÄÖµ²ÅÄܱ»´æ´¢£©
c. ÒýÓÃÍêÕûÐÔ £¨±£Ö¤Ö÷£¬Íâ¼üÆ¥Å䣩
d. Óû§×Ô¶¨Òå £¨Óû§Ö¸¶¨µÄÒ»×é¹æÔò £©
E£®Ô¼Êø
a. null£»²»ÊÇ09»ò¿Õ°×£¬±íʾûÊäÈëÈκÎÖµ
b. Ö÷¼ü£»Ò»¸ö±íÖ»ÄÜÓÐÒ»¸ö£¨primary key£©
c. Ψһ£»unique£¨Ò»¸ö±í¿ÉÒÔÓжà¸öΨһԼÊø£¬ÔÊÐí¿ÕÖµ£©
d. Íâ¼ü£» foreign key
e. ¼ì²é£»
f. ȱʡ£»Ä¬ÈÏÖµ£¨default£©
F.Êý¾ÝÓÐЧÐÔ
a.¼¶ÁªÐÞ¸ÄÓÚɾ³ý
Àý£º
Use xx
Create table tbuser
(
userID int identity(1000,1) not null primary key,
username varchar
Ïà¹ØÎĵµ£º
1.×Ö·û´®º¯Êý
³¤¶ÈÓë·ÖÎöÓÃ
datalength(Char_expr) ·µ»Ø×Ö·û´®°üº¬×Ö·ûÊý,µ«²»°üº¬ºóÃæµÄ¿Õ¸ñ
substring(expression,start,length) ²»¶à˵ÁË,È¡×Ó´®
right(char_expr,int_expr) ·µ»Ø×Ö·û´®ÓÒ±ßint_expr¸ö×Ö·û
×Ö·û²Ù×÷Àà
upper(char_expr) תΪ´óд
lower(char_expr) תΪСд
space(int_expr) Éú³Éint_exp ......
MSDN: http://msdn.microsoft.com/en-us/library/bb386976.aspx £¨Ó¢ÎÄ£©
http://msdn.microsoft.com/zh-cn/library/bb386976.aspx £¨ÖÐÎÄ£©
ScottGu µÄLINQ ϵÁУº
Part 1: Introduction to LINQ to SQL
Part 2: Defining our Dat ......
ÄÚÈÝת×Ô£ºhttp://david.btbbt.blog.163.com/blog/static/205989372009973357418/
µÇ¼Զ³ÌSQL·þÎñÆ÷
Ò» ¿´ping ·þÎñÆ÷IPÄÜ·ñpingͨ¡£
¡¡¡¡Õâ¸öʵ¼ÊÉÏÊÇ¿´ºÍÔ¶³Ìsql server 2000·þÎñÆ÷µÄÎïÀíÁ¬½ÓÊÇ·ñ´æÔÚ¡£Èç¹û²»ÐУ¬Çë¼ì²éÍøÂ磬²é¿´ÅäÖ㬵±È»µÃÈ·±£Ô¶³Ìsql server 2000·þÎñÆ÷µÄIPƴдÕýÈ·¡£
¡¡¡¡¶þ ÔÚDos»òÃüÁîÐÐ ......
¼òµ¥µØ˵£¬¾ÍÊÇ´ÓCDMÉú³ÉPDMµÄʱºò£¬releationshipÔ¼ÊøÎÞЧ£¬²»ÄÜÉú³ÉÍâ¼üÔ¼ÊøµÄ´úÂë¡£Éú³É»ùÓÚoracleµÄpdmûÎÊÌ⣬ms sql serverÓÐÎÊÌâ
ÕâÀïµÄÊÇsql server 2005
Power DesignerÊÇ15.0.0.2613
¿´Æð來ÊÇPDµÄbug,½â決辦·¨ÊÇÔÚPDM畫ÃæÖÐ點選Model->References...
會Ìø³öÒ ......