SQL¸½¼ÓÊý¾Ý¿âºó,Êý¾Ý¿âÊÇÖ»¶ÁµÄ
·½·¨Ò»
1.н¨Ò»¸öͬÃûµÄÊý¾Ý¿â
2.ÔÙÍ£µôsql server(×¢Òâ²»Òª·ÖÀëÊý¾Ý¿â)
3.ÓÃÔÊý¾Ý¿âµÄÊý¾ÝÎļþ¸²¸ÇµôÕâ¸öн¨µÄÊý¾Ý¿â
4.ÔÙÖØÆôsql server
5.´Ëʱ´ò¿ªÆóÒµ¹ÜÀíÆ÷ʱ»á³öÏÖÖÃÒÉ£¬ÏȲ»¹Ü£¬Ö´ÐÐÏÂÃæµÄÓï¾ä£¨×¢ÒâÐÞ¸ÄÆäÖеÄÊý¾Ý¿âÃû)
6.Íê³ÉºóÒ»°ã¾Í¿ÉÒÔ·ÃÎÊÊý¾Ý¿âÖеÄÊý¾ÝÁË,Õâʱ,Êý¾Ý¿â±¾ÉíÒ»°ã»¹ÒªÎÊÌâ,½â¾ö°ì·¨ÊÇ,ÀûÓÃ
Êý¾Ý¿âµÄ½Å±¾´´½¨Ò»¸öеÄÊý¾Ý¿â,²¢½«Êý¾Ýµ¼½øÈ¥¾ÍÐÐÁË.
USE MASTER
GO
SP_CONFIGURE 'ALLOW UPDATES',1 RECONFIGURE WITH OVERRIDE
GO
UPDATE SYSDATABASES SET STATUS =32768 WHERE NAME='ÖÃÒɵÄÊý¾Ý¿âÃû'
Go
sp_dboption 'ÖÃÒɵÄÊý¾Ý¿âÃû', 'single user', 'true'
Go
DBCC CHECKDB('ÖÃÒɵÄÊý¾Ý¿âÃû')
Go
update sysdatabases set status =28 where name='ÖÃÒɵÄÊý¾Ý¿âÃû'
Go
sp_configure 'allow updates', 0 reconfigure with override
Go
sp_dboption 'ÖÃÒɵÄÊý¾Ý¿âÃû', 'single user', 'false'
Go
 
Ïà¹ØÎĵµ£º
JavaÊý¾ÝÀàÐÍ
HibernateÊý¾ÝÀàÐÍ
±ê×¼SQLÊý¾ÝÀàÐÍ
(PS:¶ÔÓÚ²»Í¬µÄDB¿ÉÄÜÓÐËù²îÒì)
byte¡¢java.lang.Byte
byte
TINYINT
short¡¢java.lang.Short
short
SMALLINT
int¡¢java.lang.Integer
integer
INGEGER
long¡¢java.lang.Long
long
BIGINT
float¡¢java.lang.Float
float
FLOAT
double¡¢java.lang.Doubl ......
SQL ServerȨÏÞ¹ÜÀí²ßÂÔ
Êý¾Ý¿â½¨Á¢Ö®ºó£¬Êý¾ÝµÄ°²È«¾ÍÏÔµÃÓÈÎªÖØÒª£¬¶ÔÓÚÒ»¸öÊý¾Ý¿â¹ÜÀíÔ±À´Ëµ£¬°²È«ÐÔ¾ÍÒâζ×ÅËû±ØÐë±£Ö¤ÄÇЩ¾ßÓÐÌØÊâÊý¾Ý·ÃÎÊȨÏÞµÄÓû§Äܹ»µÇ¼µ½SQL Server£¬²¢ÇÒÄܹ»·ÃÎÊÊý¾ÝÒÔ¼°¶ÔÊý¾Ý¿â¶ÔÏóʵʩ¸÷ÖÖȨÏÞ·¶Î§ÄڵIJÙ×÷£»Í¬Ê±£¬Ëû»¹Òª·ÀÖ¹ËùÓеķÇÊÚȨÓû§µÄ·Ç·¨²Ù×÷¡£Õý»ùÓÚ´Ë£¬SQL Server 2000ÌṩÁ ......
sqlͳ¼Æ£¹ØÓÚѧÉú³É¼¨(´ð°¸)
http://blog.sina.com.cn/s/blog_61380b320100ej9p.html
´ð°¸£º
1. ¼ÆËãÿ¸öÈ˵Ä×ܳɼ¨²¢ÅÅÃû
select name,sum(score) as allscore from stuscore group by name order by allscore
2. &nbs ......
¼Ó[ ]ÓÃÓÚ¶¨½çÁÐÃû»ò±íÃûµÈÐÅÏ¢£¬ÒÔÇø±ðÒ»Ð©ÌØÊâµÄ²»ºÏÃüÃû¹æÔòµÄ×Ö´®£¬»òÊÇÓëϵͳ±£Áô×ÖÓгåÍ»¡£
Èç"user"ÊÇSQL Server±£ÁôµÄ¹Ø¼ü×Ö£¬ËùÒÔÓÃ"select * from user"²éѯ»áÌáʾÓï·¨´íÎó¡£¼ÓÉÏÖÐÀ¨ºÅ£¬ÒÔÉùÃ÷Æä²»ÊDZ£Áô×Ö¡£
"select * from [user]"
Èç¹û±íÃû²»Êǹؼü×Ö£¬ÈçCompany£¬ÔòÓÃ"select * from Company"ÊÇûÎÊÌâµ ......