SQL ËÙ²éÊÖ²á
--SQL ËÙ²éÊÖ²á
/*******************************************/
SELECT
--ÓÃ;£º´ÓÖ¸¶¨±íÖÐÈ¡³öÖ¸¶¨ÁеÄÊý¾Ý
--Óï·¨£º
SELECT column_name(s) from table_name
--Ö÷Òª×Ö¾ä¿ÉժҪΪ:
SELECT select_list [INTO new_table]
from table_source
[WHERE search_condition]
[GROUP BY group_by_expression]
[HAVING search_condition]
[ORDER BY order_expression[ASC|DESC]]
-- AND & OR
ÓÃ;£ºÔÚWHERE ×Ó¾äÖÐ AND ºÍ OR ±»ÓÃÀ´Á¬½ÓÁ½¸ö»òÕ߸ü¶àµÄÌõ¼þ
--Between…AND
ÓÃ;£ºÖ¸¶¨Ðè·µ»ØÊý¾ÝµÄ·¶Î§
Óï·¨£º
SELECT column_name from table_name
WHERE column_name
Between value1 AND value2
--Distinct
ÓÃ;£ºDISTINCT ¹Ø¼ü×Ö±»ÓÃ×÷·µ»ØÎ¨Ò»µÄÖµ
Óï·¨£º
SELECT DISINCT column-name(s) from table-name
--Order by
ÓÃ;£ºÖ¸¶¨½á¹û¼¯µÄÅÅÐò
Óï·¨£º
SELECT column-name(s) from table-name ORDER BY {order_by_expression [ASC|DESC]}
--Group by
ÓÃ;£º¶Ô½á¹û¼¯½øÐзÖ×飬³£Óë»ã×ܺ¯ÊýÒ»ÆðʹÓá£
Óï·¨£º
SELECT column,SUM(column) from table GROUP BY column
Àý£º
SELECT Company,SUM(Amount) from Sales Group By Company
--Having
ÓÃ;£ºÖ¸¶¨Èº×é»ò»ã×ܵÄËÑѰÌõ¼þ
Óï·¨£º
SELECT column,SUM(column) from¡¡table GROUP BY column
HAVING SUM(column) condition value
½âÊÍ£ºHAVING ͨ³£ GROUP BY ×Ó¾äͬʱʹÓá£
--Join
ÓÃ;:µ±ÄãÒª´ÓÁ½¸ö»òÕßÒÑÉϵıíÖÐÑ¡Çø½á¹û¼¯Ê±£¬Äã¾Í»áÓõ½JOIN.
INNER JOIN Óï·¨£º
SELECT field1,field2,field3 from first_table
INNER JOIN second_table ON first_table.keyfield=second_table.foreign_keyfield
½âÊÍ£ºINNER JOIN ·µ»ØµÄ½á¹û¼¯ÊÇÁ½¸ö±íÖÐÏàÆ¥ÅäµÄÊý¾Ý¡£
LEFT JOIN Óï·¨£º
SELECT field1,field2,field3 from first_table
LEFT JOIN second_table
ON first_table.keyfield=second_table.foreign_keyfield
½âÊÍ£ºLEFT JOIN ·µ»Ø“first_table”ÖÐËùÓеÄÐо¡¹ÜÔÚ“second_table”ÖÐûÓÐÏàÆ¥ÅäµÄÊý¾Ý¡£
RIGHT JOIN Óï·¨£º
SELECT field1,field2,field3 from first_table
RIGHT JOIN second_table
ON first
½âÊÍ£ºRIGHT JOIN ·µ»Ø“second_table”ÖÐËùÓеÄÐо¡¹ÜÔÚ"first_table"ÖÐûÓÐÏàÆ¥ÅäµÄÊý¾Ý¡£
--Alias
ÓÃ;£º¿ÉÓÃÔÚ±í£¬½á¹û¼¯»òÕßÁÐÉÏ£¬ÎªËûÃÇȡһ¸öÂß¼Ãû³Æ¡£
Óï·¨£º
1¡¢¸øÁÐÈ¡±ðÃû£ºSELECT column AS
Ïà¹ØÎĵµ£º
ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃæ£¬ºóÃæ ......
Visual C#Öж¯Ì¬²Ù×÷SQL ServerÊý¾Ý¿â £¨1£©
·¢²¼Ê±¼ä£º2003.01.14 10:09 À´Ô´£ºÈüµÏÍø ×÷ÕߣºÍõ¿Ã÷
ÔÚ±àдÊý¾Ý¿âÓ¦ÓóÌÐòµÄʱºò£¬ÎÒÃÇ¿ÉÒÔͨ¹ýSQLÓï¾äÀ´¶¯Ì¬´´½¨¡¢ÐÞ¸ÄÊý¾Ý¿âÒÔ¼°ÆäÖеĶÔÏó¡£±¾ÎÄÎÒ¾ÍÏò´ó¼Ò½éÉÜÈçºÎÔËÓÃVisual C#À´¶¯Ì¬²Ù×÷SQL ServerÊý¾Ý¿ ......
Ê×ÏȼÆËã»úÉϱØÐë°²×°oracle£¬²¢ÅäÖú÷þÎñÃû
°²×°oracleµÄ¹ý³ÌÖÐÒ»°ã»áÒªÇó½¨Á¢Ò»¸öÊý¾Ý¿â£¬Ò²¿ÉÒÔÖ®ºóÔÙ´´½¨
Õâ¸öºóÃæÓÐÒ»¸ö Êý¾Ý¿âÅäÖÃÖúÀí £¨´´½¨ÐÞ¸ÄÊý¾Ý¿âµÄ£¬Ò»°ãÃÜÂë´´½¨ÒªÇó×Öĸ¿ªÍ·£¬´óÓÚ7λɶµÄ£©ºÍÒ»¸önetÅäÖÃÖúÀí£¨Ìí¼Ó»òÕßÐÞ¸ÄÒ»¸öÊý¾Ý¿â·þÎñÃû£©£¬Ò»°ãÓÃplsql developerÔ¶³Ì²Ù×÷oracleÊý¾Ý¿â ......
ÓÃExcel+VBA+SQL Server½øÐÐÊý¾Ý´¦Àí
ʹÓÃExcel+VBA+SQL Server½øÐÐÊý¾Ý´¦ÀíÊÇÒ»ÖÖ¼òµ¥ÓÐЧ·½·¨£¬ÕÆÎÕÒÔÏ»ù´¡ÖªÊ¶ÊµÏÖ¿ìËÙÈëÃÅ(ÕÆÎÕexcel/vba/sqlserver¸÷1%ÄÚÈÝ£¬Äã¾ÍÄܳÉΪÊý¾Ý´¦Àí¸ßÊÖµÄ:))£º
Ò»¡¢Excel»ù´¡ÖªÊ¶
Á˽⹤×÷²¾(Workbook)¡¢¹¤×÷ ......
/* °üº¬CÍ·Îļþ */
#include <stdio.h>
#include <string.h>
#include <stdlib.h>
/* °üº¬SQLCAÍ·Îļþ */
EXEC SQL INCLUDE sqlca;
EXEC SQL INCLUDE sqlda;
int main()
{
EXEC SQL BEGIN DECLARE SECTION;
int money;
......