SQL Êý¾Ý¿âÖ®Ò»
1. SELECT
ʵÀý105
SELECT ID "±àºÅ",Name ÐÕÃû,
Math_Score 'Êýѧ³É¼¨', //ÔõôÓеÄÓÐAS,ÓеÄûÓÐ
Music_Score AS ÒôÀֳɼ¨,
English_Score AS Ó¢Îijɼ¨
from tb_StuScore
SELECT ±àºÅ, ÉÌÆ·Ãû³Æ,ÊýÁ¿,µ¥¼Û,½ø¼Û,
(µ¥¼Û*ÊýÁ¿) AS ÏúÊÛ¶î,
(µ¥¼Û*ÊýÁ¿-½ø¼Û*ÊýÁ¿) AS ÀûÈó
from tb_xsb
SELECT ID,Name,Math_Score,Music_Score,EngLish_Score
from tb_StuScore
WHERE NOT (EngLish_Score>= 90) OR (Math_Score>=95)
SELECT *
from tb_StuScore
WHERE Math_score LIKE '8_'
SELECT *
from tb_StuScore
WHERE Name LIKE 'Áõ%'
SELECT *
from tb_StuScore
WHERE English_score LIKE '9[5-9]%'
SELECT *
from tb_StuScore
WHERE Math_Score LIKE '[^9][0-9]'
SELECT *
from tb_StuScore
WHERE (Name LIKE 'Áõ%')
AND (
(Math_Score LIKE '[^7]_')
OR (EngLish_score LIKE '9[0-9]')
)
SELECT 'ÐÕÃû£º'+ Name + '£»±àºÅ£º'+
CONVERT(varchar(3),id) AS ѧÉúÐÅÏ¢
from tb_StuScore
SELECT ÐÕÃû,LTRIM(ÐÕÃû) AS È¥³ý×óÃæ¿Õ¸ñ,
RTRIM(ÐÕÃû) AS È¥³ýÓÒÃæ¿Õ¸ñ,
LTRIM(RTRIM(ÐÕÃû)) AS È¥³ý×óÓÒ¿Õ¸ñ
from ¿Í»§ÐÅÏ¢±í
SELECT *
from tb_StuScore
WHERE Music_Score IN (85,95,100)
SELECT *
from tb_StuScore
WHERE Music_Score NOT IN (85,95,100)
SELECT *
from tb_StuScore
WHERE Music_Score > ALL
( SELECT Music_Score
from tb_StuScore
WHER
Ïà¹ØÎĵµ£º
1.Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)¡¡¡¡
¡¡¡¡ SQLSERVERµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬Òò´Ëfrom×Ó¾äÖÐдÔÚ×îºóµÄ±í£¨»ù´¡±ídriving table£©½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏ£¬±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í£¬µ±SQLSERVER´¦Àí¶à¸ö±íʱ£¬»áÔËÓÃÅÅÐò¼°ºÏ²¢µÄ·½Ê½Á ......
--MyDBΪÐÞ¸´µÄÊý¾ÝÃû
USE MASTER
GO
SP_CONFIGURE 'ALLOW UPDATES',1 RECONFIGURE WITH OVERRIDE
GO
ALTER DATABASE MyDB SET EMERGENCY
GO
sp_dboption 'MyDB', 'single user', 'true'
GO
DBCC CHECKDB('MyDB','REPAIR_ALLOW_DATA_LOSS')
GO
ALTER DATABASE MyDB SET ONLINE
GO
sp_configure 'allow updates ......
1¡¢ÎļþºÍÎļþ×éµÄº¬ÒåÓë¹Øϵ
ÿ¸öÊý¾Ý¿âÓÐÒ»¸öÖ÷Êý¾ÝÎļþ.ºÍÈô¸É¸ö´ÓÎļþ¡£ÎļþÊÇÊý¾Ý¿âµÄÎïÀíÌåÏÖ¡£ Îļþ×é¿ÉÒÔ°üÀ¨·Ö²¼ÔÚ¶à¸öÂß¼·ÖÇøµÄÎļþ£¬ÊµÏÖ¸ºÔØƽºâ¡£Îļþ×éÔÊÐí¶ÔÎļþ½øÐзÖ×飬ÒÔ±ãÓÚ¹ÜÀíºÍÊý¾ÝµÄ·ÖÅ䣯·ÅÖá£ÀýÈ磬¿ÉÒÔ·Ö±ðÔÚÈý¸öÓ²ÅÌÇý¶¯Æ÷ÉÏ´´½¨Èý¸öÎļþ£¨Data1.ndf¡¢Data2.ndf&nb ......
ÓÃPL/SQL Deleveloperµ¼³öcsvÎļþ¸ñʽÊý¾Ý£¬ÓÃexcel´ò¿ªÊÇÂÒÂ룬ÓüÇʱ¾´ò¿ªÕý³££¬Ôõô»ØÊ£¿
ÂíÉÏGoogle£¬ÔÀ´µ¼³öµÄÎļþµÄ±àÂë¸ñʽÊÇUTF-8ºÍ¶øexcelĬÈÏ´ò¿ªÎļþµÄ±àÂëÊÇunicode£¬ÓÚÊÇ£º
1¡¢ÓüÇʱ¾´ò¿ªÎļþ£¬È»ºóÁí´æΪ£¬ÌîдÎļþÃû£¬Ñ¡Ôñ±àÂë¸ñʽΪunicode
2¡¢ÓÃexcel´ò¿ªÐµÄÎļþ£¬Õý³£ÏÔʾ
µ«ÊdzöÏÖÁíÍâµÄÎÊÌ⣠......