Sql Server »ù´¡
Èí¼þ £º Sql Server 2005
ÕâÀï²¢²»ÊÇSQLÓï·¨´óÈ«£¬ÒÔÏÂÊdz£ÓõÄÓï¾ä£¬¶Ô£¨Êý¾Ý¿â¡¢±í¡¢×ֶΡ¢Êý¾Ý£©µÄÔöɾ¸Ä²é£¬Èç¹ûÐèÒªÏêϸȫÃæµÄTransact-SQLÓï¾ä£¬¿ÉÒÔ²éSql ServerÁª»ú´ÔÊ飬ÄÇÀïÊÇ×îÈ«µÄ×ÊÁÏ£¬Ò»°ã°²×°Sql Server¶¼»áĬÈÏ°²×°¡£
´ò¿ªSql ServerÁª»ú´ÔÊé
¿ªÊ¼ à ³ÌÐò à Microsoft SQL Server 2005 à ÎĵµÓë½Ì³Ì à Sql ServerÁª»ú´ÔÊé
´ò¿ªTransact – SQL²Î¿¼
Sql Server 2005 Áª»ú´ÔÊé à Sql Server ÓïÑԲο¼ à Transact – SQL²Î¿¼
Êý¾Ý¿â
´´½¨
create database TestDB
ÐÞ¸Ä
ALTER DATABASE TestDB MODIFY NAME = TestDataBase /* ÉÙʹÓÃ*/
²éѯËùÓÐ
SELECT Name from Master..SysDatabases ORDER BY Name /* Ò»°ãºÜÉÙʹÓÃ*/
ɾ³ý
drop database TestDB
±í
´´½¨
Create table house(
Rates int,
Grow int,
Place varchar(10),
Year int
)
²éѯËùÓÐ
SELECT Name from SysObjects Where XType='U' ORDER BY Name
ÐÞ¸Ä
sp_rename house , NewHouse
ɾ³ý
drop table house
×Ö¶Î
Ôö¼Ó
ALTER TABLE NewHouse
ADD column_name integer
ɾ³ý
ALTER TABLE NewHouse
DROP COLUMN column_name
ÐÞ¸Ä
ALTER TABLE NewHouse
ALTER COLUMN column_name varchar
²éѯ
SELECT Name from SysColumns
WHERE id=Object_Id('TableName')
Êý¾Ý
Ôö¼Ó
insert into NewHouse values(10000,100,'±±¾©',2010)
²éѯ
select * from NewHouse
ÐÞ¸Ä
update NewHouse set Grow = 200 where Rates = 10000
ɾ³ý
delete from NewHouse where Rates = 10000
ºÜ¶àÈ˲»Ï²»¶¿´Sql ServerÁª»ú´ÔÊ飬ÎÒÒ»¿ªÊ¼Ò²²»Ï²»¶£¬Ò»´ó¶Ñ [ ] | {} ÉõÖÁÒ»¸ö[ ]ÀïÃæÓÖǶÌ׶à¸ö[ ] £¬°³ÀàÉñ°¡£¡²»ÊÇÎÒµÄÔ©¼ÒÅÉÀ´¹ÊÒâÍæÎҵİɡ£µÃ£¡»¹²»ÈçÖ±½ÓÔÚÍøÉϲéϱðÈ˸øµÄʾ·¶ÄØ£¡µ«ÊÇ×÷ΪITÐÐÒµÈË£¬ÊìÁ·µÄ²éÔÄÎĵµÊDZر¸µÄÄÜÁ¦£¬ÆäʵÏë¿´¶®ÕâЩ[ ] ,{}Ò²ºÜ¼òµ¥£¬ÏÈÖªµÀÕâЩÊÇʲôÒâ˼¡£
[ ]£¨·½À¨ºÅ£©¿ÉÑ¡Óï·¨Ïî¡£²»Òª¼üÈë·½À¨ºÅ¡£
{ }£¨´óÀ¨ºÅ£©±ØÑ¡Óï·¨Ïî¡£²»Òª¼üÈë´óÀ¨ºÅ¡£
Õª×Ô £º
Sql Server 2005 Áª»ú´ÔÊ
Ïà¹ØÎĵµ£º
²ÉÓÃÔ¤±àÒëÓï¾ä¼¯£¬ËüÄÚÖÃÁË´¦ÀíSQL×¢ÈëµÄÄÜÁ¦£¬Ö»ÒªÊ¹ÓÃËüµÄsetString·½·¨´«Öµ¼´¿É£º
String sql= "select * from users where username=? and password=?;
PreparedStatement preState = conn.prepare ......
½âѹ SQLServer2005SP3-KB955706-x86-CHS.exe Îļþ(ʹÓà WinRAR ¿ÉÖ±½Ó½âѹ,»òʹÓà /extract)
½âѹºóÎļþ¼Ð ËÑË÷ “*.msi *.msp” £¬È»ºó¸´ÖÆËùÓÐËÑË÷µ½µÄÎļþ ·Åµ½ D:\SQL2005\SP3 ÖÐ.
ÌáÈ¡ cs_sql_dev_all_dvd.iso(SQL Server 2005 ¿ª·¢°æ) ÖÐµÄ x86 °æ±¾£¬·Åµ½ D:\SQL2005\MSSQL ÖУ»´Ëʱ D:\SQL2005\M ......
Ó¦ÓÃIDS·ÀÖ¹SQL×¢Èë¹¥»÷
http://www.cnhacker.com/Hacker/Skills/200807/t20080731_6187.html
Ä¿Ç°£¬Õë¶ÔÓ¦Óü°Æäºǫ́Êý¾Ý¿âµÄÓ¦Óü¶ÈëÇÖÒѾ±äµÃÔ½À´Ô½²þâ±£¬ÈçSQL×¢Èë¡¢¿çÕ¾µã½Å±¾¹¥»÷ºÍδ¾ÊÚȨµÄÓû§·ÃÎʵȡ£ËùÓÐÕâЩÈëÇÖ¶¼ÓпÉÄÜÈƹýǰ̨°²È«ÏµÍ³²¢¶ÔÊý¾ÝÀ´Ô´·¢Æð¹¥»÷¡£
ΪÁ˶Ը¶ÕâÀàÍþв£¬ÐÂÒ»¼¶±ðµÄ°²È«ÍÑÓ±¶ø³ö£ ......
Ò».×¢ÊÍ
-- µ¥ÐÐ×¢ÊÍ£¬´ÓÕâµ½±¾ÐнáÊøΪעÊÍsql Óï·¨£¬ÀàËÆC++£¬c#ÖÐ//
/* … */ ¶àÐÐ×¢ÊÍ£¬ÀàËÆC++£¬C#ÖÐ/* … */
¶þ.±äÁ¿£¨int£¬ smallint£¬ tinyint£¬ decimal£¬float£¬real£¬ money £¬smallmoneysql Óï·¨£¬ text £¬image£¬ char£¬ varchar¡£¡£¡£¡£¡£¡££©
Óï·¨£º
DECLARE
{
{@local_variable data_t ......