SQL Server Óï¾ä
Êý¾Ý¿â£º
1¡¢ ´´½¨Êý¾Ý¿âµÄÓï·¨£º
if exists (select * from sysdatabases where name='DT_name') /*ÅжÏÊÇ·ñ´æÔÚ£¬ÊÇÔòɾ³ý*/
drop database DT_name
create database database_name
on primary /* Ö¸¶¨Ö÷ÒªÎļþ×飬ÆäÖеÚÒ»¸öÖ÷ÒªÎļþ */
(
name = data1, /* Ö÷Êý¾ÝÎļþµÄÂß¼Ãû */
filename =‘µØÖ·\data1.mdf’; /* Ö÷Êý¾ÝÎļþµÄÎïÀí µØÖ·¡¢Ãû³Æ */
size = 10MB, /* ³õʼ´óС*/
maxsize = 100MB, /* ×î´ó´óС */
filegrowth = 10% /* Ôö³¤ÂÊ */
),
filegroup group_NAME /* ·ÇÖ÷ÒªÎļþ×é */
(
name = data2,
filename =‘µØÖ·\data2.ndf’£»
size = 10MB,
maxsize = 100MB,
filegrowth = 10%
)...
log on /*Ö¸¶¨ÊÂÎñÈÕÖ¾Îļþ*/
(
name = data3, /* ÈÕÖ¾ÎļþµÄÂß¼Ãû */
filename =‘µØÖ·\data3.ldf’; /* ÈÕÖ¾ÎļþµÄÎïÀí µØÖ·¡¢Ãû³Æ */
size = 5MB,
maxsize = 100MB,
filegrowth = 5%
)...
2¡¢ ÐÞ¸ÄÓï¾ä£º
alter database database_name +
1) Ìí¼ÓÎļþ£ºadd [log|] file (...)
2) ÐÞ¸ÄÎļþ£ºmodify file(name =‘ÎļþÃû’£¬ÐÞ¸ÄÄÚÈÝ)
3) ɾ³ýÎļþ£ºremove [log|] file “file_name”
4) Îļþ×飺
j Ìí¼Ó£ºadd filegroup Îļþ×éÃû³Æ go alter database Êý¾Ý¿â add file (...)
k ɾ³ý£ºremove filegroup Îļþ×éÃû³Æ ( ×¢Ò⣺³ý·ÇÎļþ×é²»°üº¬ÈκÎÊý¾ÝÎļþ£¬
·ñÔòÎÞ·¨É¾³ý )
񡜧
1¡¢ ´´½¨±í£º
create table table_name
(
ÁÐÃû#1 Êý¾ÝÀàÐÍ£¬
...
ÁÐÃû#n Êý¾ÝÀàÐÍ£¬
)
1) Ö÷¼üÔ¼Êø£ºprimary key
2) Íâ¼üÔ¼Êø£ºforeign key
j [Constraint constraint_name]
Foreign key(Íâ¼üÁÐÃû) references Ö÷±íÃû(Ö÷¼üÁÐ)
k ±íÒѾ´æÔÚµÄÇé¿öÔÚ:
ALTER TABLE table_name
ADD FOREIGN KEY (Íâ¼üÁÐÃû)
REFERENCES table_primary(Ö÷¼üÁÐ)
Ïà¹ØÎĵµ£º
±¾ÎÄÑÝʾÁË SQL Server 2008 ·ÖÇø±íʵÀý;
1. ´´½¨²âÊÔÊý¾Ý¿â £»
2. ´´½¨·ÖÇøº¯Êý;
3. ´´½¨·ÖÇø¼Ü¹¹;
4. ´´½¨·ÖÇø±í;
5. ´´½¨·ÖÇøË÷Òý ;
6. ·ÖÇøÇл» ;
7. ²éѯÄÄЩ±íʹÓÃÁË·ÖÇø±í£»
-- ×÷³ÉÕß leno
-- ÈÕÆÚ: 2009-06-06 23:50:01.700
-- ......
ÏÂÃæÌá³öÁË10ÌõºÍDB2 SQLÐÔÄÜÏà¹ØµÄ10ÌõÒòËØ£º
1¡¢ÌṩÊʵ±µÄͳ¼ÆÐÅÏ¢
¶ÔDB2ÓÅ»¯¹ÜÀíÆ÷£¨otimizer£©¶øÑÔ£¬ÈçºÎ¸ü¼ÓÓÐЧµÄÖ´ÐÐSQLÓï¾äÊÇÓÉ´æÔÚÓÚDB2 catalogÖеÄͳ¼ÆÐÅÏ¢¾ö¶¨µÄ£¬ÓÅ»¯Æ÷ÀûÓÃÕâЩÐÅÏ¢¾ö¶¨×îÓÅ»¯µÄ·¾¶¡£
Òò´Ë£¬ÎªÁ˱£³ÖϵͳÄܹ»×ö³ö×î¼ÑÑ¡Ôñ£¬ÐèÒª¾³£µÄÔËÐÐRunstatsÃüÁÀ´±£³Öϵͳͳ¼ÆÐÅÏ¢µÄ¼°Ê±ÓÐЧ¡£Ô ......
ÏÈÕ¾ÔÚÓ¦ÓóÌÐòµÄ½Ç¶È˵˵ËüÃǵIJ»Í¬¡£
1¡¢ Ö±½ÓÆ´ SQL
¾ÍÏñ´ó¼ÒÁ˽âµÄÄÇÑù£¬Ö±½ÓÆ´ SQL ´øÀ´ÁË SQL ×¢Èë¹¥»÷£¬´øÀ´ÁËÆ´Ê±Ð©ÐíµÄÐÔÄÜËðʧ£¬µ«ÊÇÆ´²»ÓÃÌí¼Ó SqlParameter £¬»áÉÙдºÜ¶à´úÂë——ºÜ¶àÈËϲ»¶Ö±½ÓÆ´£¬Ò²Ðí¾ÍÒòΪÕâµã¡£ÕâÖÖ×ö·¨»á°ÑÄãÆ´ºÃµÄ SQL ÔÑùÖ±½Ó·¢Ë͵½ DB ·þÎñÆ÷È¥Ö´ÐС££¨×¢ÒâÀàËÆ &rdquo ......
SQL ²é¿´ËùÓбíÃû£º
select name from sysobjects where type='U'
²éѯ±íµÄËùÓÐ×Ö¶ÎÃû£º
Select name from syscolumns Where ID=OBJECT_ID('±íÃû')
select * from information_schema.tables
select * from information_schema.views
select * from information_schema.columns
ACCESS
²é¿´ËùÓбíÃû£º
se ......