sql»ù´¡ÖªÊ¶
SQLÓïÑÔÓÉÃüÁî¡¢×Ӿ䡢ÔËËãºÍ¼¯ºÏº¯ÊýµÈ¹¹³É¡£ÔÚSQLÖУ¬Êý¾Ý¶¨ÒåÓïÑÔDDL£¨ÓÃÀ´½¨Á¢¼°¶¨ÒåÊý¾Ý±í¡¢×Ö¶ÎÒÔ¼°Ë÷ÒýµÈÊý¾Ý¿â½á¹¹£©°üº¬µÄÃüÁîÓÐCREATE¡¢DROP¡¢ALTER£»Êý¾Ý²Ù×ÝÓïÑÔDML£¨ÓÃÀ´ÌṩÊý¾ÝµÄ²éѯ¡¢ÅÅÐòÒÔ¼°É¸Ñ¡Êý¾ÝµÈ¹¦ÄÜ£©°üº¬µÄÃüÁîÓÐSELECT¡¢INSERT¡¢UPDATE¡¢DELETE¡£
Ò»¡¢SQLÓï¾ä
£¨1£©Select ²éѯÓï¾ä
Óï·¨£ºSELECT [ALL|DISTINCT] <Ä¿±êÁбí´ïʽ> [AS ÁÐÃû]
[,<Ä¿±êÁбí´ïʽ> [AS ÁÐÃû] ...] from <±íÃû> [£¬<±íÃû>…]
[WHERE <Ìõ¼þ±í´ïʽ> [AND|OR <Ìõ¼þ±í´ïʽ>...]
[GROUP BY ÁÐÃû [HAVING <Ìõ¼þ±í´ïʽ>>
[ORDER BY ÁÐÃû [ASC | DESC>
½âÊÍ£º[ALL|DISTINCT] ALL£ºÈ«²¿£» DISTINCT£º²»°üÀ¨Öظ´ÐÐ
<Ä¿±êÁбí´ïʽ> ¶Ô×ֶοÉʹÓÃAVG¡¢COUNT¡¢SUM¡¢MIN¡¢MAX¡¢ÔËËã·ûµÈ
<Ìõ¼þ±í´ïʽ>
²éѯÌõ¼þ ν´Ê
±È½Ï =¡¢>,<,>=,<=,!=,<>,
È·¶¨·¶Î§ BETWEEN AND¡¢NOT BETWEEN AND
È·¶¨¼¯ºÏ IN¡¢NOT IN
×Ö·ûÆ¥Åä LIKE£¨“%”Æ¥ÅäÈκγ¤¶È£¬“_”Æ¥ÅäÒ»¸ö×Ö·û£©¡¢NOT LIKE
¿ÕÖµ IS NULL¡¢IS NOT NULL
×Ó²éѯ ANY¡¢ALL¡¢EXISTS
¼¯ºÏ²éѯ UNION£¨²¢£©¡¢INTERSECT£¨½»£©¡¢MINUS£¨²î£©
¶àÖØÌõ¼þ AND¡¢OR¡¢NOT
<GROUP BY ÁÐÃû> ¶Ô²éѯ½á¹û·Ö×é
[HAVING <Ìõ¼þ±í´ïʽ>] ·Ö×éɸѡÌõ¼þ
[ORDER BY ÁÐÃû [ASC | DESC> ¶Ô²éѯ½á¹ûÅÅÐò£»ASC£ºÉýÐò DESC£º½µÐò
Àý1£º select student.sno as ѧºÅ, student.name as ÐÕÃû, course as ¿Î³ÌÃû, score as ³É¼¨ from score,student where student.sid=score.sid and score.sid=:sid
Àý2£ºselect student.sno as ѧºÅ, student.name as ÐÕÃû,AVG(score) as ƽ¾ù·Ö from score,student where student.sid=score.sid and student.class=:class and (term=5 or term=6) group by student.sno, student.name having count(*)>0 order by ƽ¾ù·Ö DESC
Àý3£ºselect * from score where sid like '9634'
Àý4£ºselect * from student where class in (select class from student where name='³ÂСС')
£¨2£©INSERT²åÈëÓï¾ä
Óï·¨£ºINSERT INTO <±íÃû> [£¨<×Ö¶ÎÃû1> [,<×Ö¶ÎÃû2>, ...])] VALUES (<³£Á¿1> [,<³£Á¿2>, ...])
Óï·¨£ºINSERT INTO <±íÃû> [£¨<×Ö¶ÎÃû1> [,<×Ö¶ÎÃû2>, ...])] ×Ó²éѯ
Àý×Ó£ºINSERT INTO ½èÊé±í£¨
Ïà¹ØÎĵµ£º
(1)SEQNAME.NEXTVALÀïÃæµÄÖµÈçºÎ¶Á³öÀ´£¿¿ÉÒÔÖ±½ÓÔÚinsert into test values(SEQNAME.NEXTVAL) ÊÇ¿ÉÒÔÓà ÕâÑù£º
SELECT tmp#_seq.NEXTVAL
INTO id_temp
from DUAL; È»ºó¿ÉÒ ......
C# SQLÊý¾Ý¿â²Ù×÷ͨÓÃÀà
using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
namespace Framework.DataBase
{
///
/// ͨÓÃÊý¾Ý¿âÀà
///
public class DataBase
{
private string ConnStr = null;
public DataBase()
{
&nb ......
USE [master]
GO
/****** ¶ÔÏó: StoredProcedure [dbo].[sp_backupdatabase] ½Å±¾ÈÕÆÚ: 07/15/2009 16:23:56 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE proc [dbo].[sp_backupdatabase]
@bak_path nvarchar(4000)='', ......
1. ˵Ã÷£º¸´ÖƱí(Ö»¸´Öƽṹ£¬Ô´±íÃû£ºa£¬Ð±íÃû£ºb)
SQL: select * into b from a where 1<>1;
2. ˵Ã÷£º¿½±´±í(¿½±´Êý¾Ý£¬Ô´±íÃû£ºa£¬Ä¿±ê±íÃû£ºb)
SQL: insert into b(a, b, c) select d, e, f from b;
&nb ......