SQLÓï¾ä´´½¨Êý¾Ý¿â
1.create database dataname
ÕâÊÇ´´½¨Êý¾Ý¿â×î¼òµ¥µÄ·½·¨£®Êý¾Ý¿âµÄ¸÷¸öÊôÐÔ¶¼ÊÇĬÈÏ£®ÈçÊý¾Ý¿âÎļþÓëÈÕÖ¾Îļþ´æ´¢Ä¿Â¼£®Êý¾Ý¿â´óСµÈ£®
ÏÂÃæ½éÉÜϳ£Óþö¶¨Êý¾Ý¿âÊôÐÔµÄ×Ӿ䣮
on:¼òµ¥Àí½âΪ¶¨Òå´æ´¢Êý¾Ý¿âÎļþµÄλÖ㬿´ÏÂÃæ´úÂ룮
filename:Êý¾Ý¿âµÄÂß¼±ðÃû
size:Êý¾Ý¿â³õʼ´óС
maxsize:Êý¾Ý¿â³õ´óÈÝÁ¿
filegrowth:Êý¾Ý¿âÿ´ÎÔö¼ÓµÄÈÝÁ¿£®
log on:¼òµ¥Àí½âΪ¶¨Òå´æ´¢Êý¾Ý¿âÈÕÖ¾ÎļþµÄλÖã®
¿´´´½¨´úÂ룺
create database Accounting
on(name='AccountingName',
filename='F:\×ܽá\Sql\´´½¨ºÍÐÞ¸ÄÊý¾Ý±í\Accounting.mbdf',
size=10mb,
maxsize=50mb,
filegrowth=5mb)
log on(name='AccountingLog',
filename='F:\×ܽá\Sql\´´½¨ºÍÐÞ¸ÄÊý¾Ý±í\Accounting.log',
size=10mb,
maxsize=50mb,
filegrowth=5mb)
ÉÏÃæËµµ½ÁË¡¡filegrowth:Êý¾Ý¿âÿ´ÎÔö¼ÓµÄÈÝÁ¿¡¡½áºÏ´úÂëÀ´Ëµ£®¾ÍÊdzõʼÊý¾Ý¿â´óСΪ10mb.µ±Êý¾Ý¿âÈÝÁ¿Òª³¬³öʱ£®Ëû»á×Ô¶¯Ôö¼Ó5mb£®Õâ»á¾ÍÊÇ15mb´óС£®×î´óµ½50mb
create database song on
(name=ktvdata,filename='D:\database\ktvdata.mdf',
size=8MB,maxsize=9MB,filegrowth=100KB)
log on
(name=ktvdata_log,filename='D:\database\ktvdata.ldf',
size=9MB,maxsize=10MB,filegrowth=100KB)
go
2. ʹÓÃALTER DATABASEÓï¾äÐÞ¸ÄÊý¾Ý¿â
Àý4-3¡¡½«Á½¸öÊý¾ÝÎļþºÍÒ»¸öÊÂÎñÈÕÖ¾ÎļþÌí¼Óµ½testÊý¾Ý¿âÖС£
³ÌÐòÇåµ¥ÈçÏ£º
ALTER DATABASE Test
ADD FILE
(NAME = Test1, FILENAME='c:\Program Files\Microsoft SQL Server\MSSQL\Data\test1.ndf', SIZE =
5MB, MAXSIZE = 100MB, FILEGROWTH = 5MB),
(NAME = Test2, FILENAME='c:\Program Files\Microsoft SQL Server\MSSQL\Data\test2.ndf', SIZE =
3MB, MAXSIZE = 10MB, FILEGROWTH = 1MB)
GO
ALTER DATABASE Test
ADD LOG FILE ( NAME = testlog1, FILENAME='c:\Program Files\Microsoft SQL
Server\MSSQL\Data\testlog1.ldf', SIZE = 5MB, MAXSIZE = 100MB, FILEGROWTH = 5MB)
GO
3¡¢ÖØÃüÃûtestΪdemo
sp_renamedb 'test','demo'
4. ɾ³ýÊý¾Ý¿â£º drop database song
go
Ïà¹ØÎĵµ£º
¾ÛºÏº¯Êý
MAX(×Ö¶Î)
Çóij×Ö¶ÎÖеÄ×î´óÖµ
MIN(×Ö¶Î)
Çóij×Ö¶ÎÖеÄ×îСֵ
AVG(×Ö¶Î)
Çóij×Ö¶ÎÖÐµÄÆ½¾ùÖµ
SUM(×Ö¶Î)
Çóij×Ö¶ÎÖеÄ×ܺÍ
COUNT(×Ö¶Î)
ͳ¼ÆÄ³×ֶηǿռͼÊý
COUNT
......
http://www.thecloud.cn/study/program/java/597.html
hibernate3µÄHQL ÊÇÃæÏò¶ÔÏóµÄÓï·¨,ÒѾ֧³Ö update ,delete fromÓï¾ä,µ«
Ŀǰ»¹²»Ö§³Öinsert intoÓï¾ä.
×öÏîÄ¿ÓÐʱºòµÄÈ·ÐèҪдÔÉúµÄsqlÀ´·½±ãweb¿ª·¢.
ÏÂÃæÊÇÎÒ×Ô¼º¹Äµ·³öÀ´µÄ·½·¨,Ï£Íû¶ÔÎÒºÍÅóÓÑÓÐËù°ïÖú.
ÔÚDaoÀïдһ¸ö·½·¨,ÈÃÎÒÃÇÔÚactionÀïµ÷ÓÃËü...
&nbs ......
Transact-SQL
ÓïÑÔʹÓõÄÁ÷³Ì¿ØÖÆÃüÁîÓë³£¼ûµÄ³ÌÐòÉè¼ÆÓïÑÔÀàËÆÖ÷ÒªÓÐÒÔϼ¸ÖÖ¿ØÖÆÃüÁî¡£
4.6.1 IF…ELSE
ÆäÓï·¨ÈçÏ£º
IF <Ìõ¼þ±í´ïʽ>
<ÃüÁîÐлò³ÌÐò¿é>
[ELSE [Ìõ¼þ±í´ïʽ]
<ÃüÁîÐлò³ÌÐò¿é>]
ÆäÖÐ<Ìõ¼þ±í´ïʽ>¿ÉÒÔÊǸ÷ÖÖ±í´ïʽµÄ×éºÏ£¬µ«±í´ïʽµÄÖµ±ØÐëÊÇÂß¼Öµ“Õæ&rdq ......
ÎÒÃÇÒª×öµ½²»µ«»áдSQL£¬»¹Òª×öµ½Ð´³öÐÔÄÜÓÅÁ¼µÄSQLÓï¾ä¡£
£¨1£©Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
OracleµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving
table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏÂ,Äã±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í¡£È ......
SQL ServerµÄÐÔÄÜÖ÷Ҫȡ¾öÓÚ´ÅÅÌI/OЧÂÊ£¬Ìá¸ßI/OЧÂÊijÖÖ³ÌÐòÉϾÍÒâζ×ÅÌá¸ßÐÔÄÜ¡£SQL Server 2008ÌṩÁËÊý¾ÝѹËõ¹¦ÄÜÀ´Ìá¸ß´ÅÅÌI/O¡£
Êý¾ÝѹËõÒâζ׿õСÊý¾ÝµÄÓдÅÅÌÕ¼ÓÃÁ¿£¬ËùÒÔÊý¾ÝѹËõ¿ÉÒÔÓÃÔÚ±í£¬¾Û¼¯Ë÷Òý£¬·Ç¾Û¼¯Ë÷Òý£¬ÊÓͼË÷Òý»òÊÇ·ÖÇø±í£¬·ÖÇøË÷ÒýÉÏ¡£
Êý¾ÝѹËõ¿ÉÒÔÔÚÁ½¸ö¼¶±ðÉÏʵÏÖ£ºÐм¶±ðºÍÒ³¼¶±ð¡£Ò³¼¶±ðѹ ......