³£ÓÃsqlÏà¹Ø
1Ð޸Ļù±¾±í
Ìí¼ÓÁÐ alter table tableName add<ÐÂÁÐÃû><Êý¾ÝÀàÐÍ>[ÍêÕûÐÔÔ¼Êø]
ɾ³ýÁÐ alter table tableName drop<ÐÂÁÐÃû><Êý¾ÝÀàÐÍ>[ÍêÕûÐÔÔ¼Êø]
2´´½¨
½¨±ícreate table tableName(
id primary key AUTO_INCREMENT(mysql);
id primary key identity(1,1)(sql server)
)
½¨Á¢Ë÷Òý
create index OID_IDX on ±íÃû(number);
create unique index oin_idx on ±íÃû(number);´´½¨Î¨Ò»Ë÷Òý
3 ɾ³ý
ɾ³ýË÷Òý drop index <Ë÷ÒýÃû>
ɾ³ý±í drop table <±íÃû>
4 sql¹¦ÄÜ
Êý¾Ý²éѯ select
Êý¾Ý¶¨Òå create drop alter
Êý¾Ý²Ù¿Ø insert update delete
Êý¾Ý¿ØÖÆ grant(ÊÚȨ) revoke(ÊÕ»ØȨÏÞ)
(1) Êý¾Ý²éѯ
select * from tableName where <Ìõ¼þ±í´ïʽ> group by<ÁÐÃû>[having<Ìõ¼þ>] order by<ÁÐÃû>[ASC DESC]
select distinct Sno from sc ²éѯÊý¾ÝÈ¥µôÖظ´ÐÐ
³£¼ûµÄ²éѯÌõ¼þ
±È½Ï = ,>,<,<=,<=,!=,<>,!<,!>,
È·¶¨·¶Î§ between and |not between and
È·¶¨¼¯ºÏ in ,not in
×Ö·ûÆ¥Åä like ,not like like '<Æ¥Åä·û>' Æ¥Åä·û¿ÉÒÔ°üº¬Í¨Åä·û%ºÍ_
¿ÕÖµ is null ,is not null
¶àÖØÌõ¼þ(Âß¼ÔËËã) and,or,not
select a.name,a.mialbox from a where EXISTS(select b.name from b where a.name=b.name)
Áª½Ó²éѯjoin
select a.number,a,name,b.age,b.sort from a join b on a.number=b.number
inner join ÄÚÁª½Ó ÓÃÓÚ·µ»ØÁ½¸ö±íÖÐÒª²éѯµÄÁÐÊý¾Ý left join right join
³£¼ûÔËËãÒÔ¼°¾Û¼¯º¯Êý
ABS(x)·µ»Ø¾ø¶ÔÖµ
&
Ïà¹ØÎĵµ£º
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class _Default : System.Web.UI.Page
{
......
˵Ã÷£º¸öÈ˸оõÔÚJavaÁìÓò´óÐÍ¿ª·¢¶¼Àë²»ÁËORMµÄÉíÓ°£¬ËùνµÄSSH¾ÍÊÇSpring+Struts+Hibernate£¬³ýÁËÔÚѧϰ»ù´¡ÖªÊ¶µÄʱºò±»¸æÖª¿ÉÒÔʹÓÃJDBC²Ù×÷Êý¾Ý¿âÖ®Í⣬´óÁ¿µÄÊé¼®Öж¼Êǽ²ÊöʹÓÃHibernateÕâ¸öORM¹¤¾ßÀ´²Ù×÷Êý¾Ý¡£ÔÚ.NETÖвÙ×÷Êý¾Ý¿âµÄ·½Ê½ÓжàÖÖ£¬³ýÁË×îÖ±½ÓµÄ·½Ê½¾ÍÊÇʹÓÃADO.NETÖ®Í⣬»¹¿ÉÒÔʹÓÃNHiber ......
ÈçºÎ´´½¨ SQL Server 2005 ÐÂÕË»§£¿
Ê×ÏÈÒªÉèÖÃSQL Server 2005µÄ·ÃÎÊ·½Ê½
1´ò¿ªSQL Server Management Studio
2·þÎñÆ÷Ãû³ÆÉÏÓÒ¼üÑ¡Ôñ“ÊôÐÔ”£¬´ò¿ª“·þÎñÆ÷ÊôÐÔ”¶Ô»°¿ò£¬ÔÚ“Ñ¡ÔñÒ³”ÀïÑ¡Ôñ“°²È«ÐÔ”£¬ÔÚ“·þÎñÆ÷Éí·ÝÑéÖ¤”ÀïÑ¡Ôñ“SQL ServerºÍWindows É ......
¼¸µÀ¾µäµÄSQL±ÊÊÔÌâÄ¿£¨Óд𰸣©
£¨1£©±íÃû£º¹ºÎïÐÅÏ¢
¹ºÎïÈË ÉÌÆ·Ãû³Æ ÊýÁ¿
A ¼× 2
B ÒÒ &n ......