Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

sql server 2005´¥·¢Æ÷ѧϰ±Ê¼Ç£¨Ò»£©

        ´¥·¢Æ÷ʵ¼ÊÉϾÍÊÇÒ»ÖÖÌØÊâÀàÐ͵Ĵ洢¹ý³Ì£¬ÆäÌØÊâÐÔ±íÏÖÔÚ£ºËüÊÇÔÚÖ´ÐÐÌØ¶¨µÄT-SQL ×Ô¶¯Ïà¼ÓµÄ¡£
   
        ´¥·¢Æ÷·ÖΪÁ½Àࣺ 
                               Ò»£º DML ´¥·¢Æ÷
                                                   DML´¥·¢Æ÷Êǵ±Êý¾Ý¿â·þÎñÆ÷Öз¢ÉúÊý¾Ý²Ù×÷ÓïÑÔʼþÖ´ÐеĴ洢¹ý³Ì¡£
                                                    DML·ÖΪ£º AFTER ´¥·¢Æ÷ ºÍ  Instead Of´¥·¢Æ÷
                               ¶þ£º DLL´¥·¢Æ÷
                                                     DDL´¥·¢Æ÷ÊÇÔÚÏìÓ¦Êý¾Ý¶¨ÒåÓïÑÔʱ¼äʱִÐеĴ洢¹ý³Ì¡£DDL´¥·¢Æ÷Ò»°ãÓÃÓÚÖ´ÐÐÊý¾Ý¿âÖйÜÀíÈÎÎñ¡£ÈçÉóºËºÍ¹æ·¶Êý¾Ý¿â²Ù×÷¡¢·ÀÖ¹Êý¾Ý±í½á¹¹±»Ð޸ĵȡ£
        
        ´¥·¢Æ÷×÷Óãº
                &n


Ïà¹ØÎĵµ£º

C#Á¬½ÓSQL Server 2005 ExpressµÄ×Ö·û´®

C#Á¬½ÓSQL ServerµÄSqlConnectionµÄ×Ö·û´®£¬Ðí¶à¶¼ÊDz»ÄÜÁ¬½ÓµÄ¡£ÏÖÔÚ¸øÒ»¸öÄÜÁ¬½ÓµÄ£º
using System.Data.SqlClient;
public class sqlServerConnection {
//
public static void Main() {
//ÏÂÃæ¾ÍÊDZê×¼µÄÁ¬½Ó£¬×¢ÒâSERVERÊÇÎҵļÆËã»úÃû¡£SQLEXPRESSÊÇÊý¾Ý¿âʵÀý¡£SSPI±íʾʹÓÃWindowsµÇ½µÄÕÊ»§¡£masterÊÇÒªÁ¬½Óµ ......

SQLʵÀý

--1¡¢²éÕÒÔ±¹¤µÄ±àºÅ¡¢ÐÕÃû¡¢²¿ÃźͳöÉúÈÕÆÚ£¬Èç¹û³öÉúÈÕÆÚΪ¿ÕÖµ£¬ÏÔʾÈÕÆÚ²»Ïê,²¢°´²¿ÃÅÅÅÐòÊä³ö,ÈÕÆÚ¸ñʽΪyyyy-mm-dd¡£
select emp_no,emp_name,dept,isnull(convert(char(10),birthday,120),'ÈÕÆÚ²»Ïê') birthday
from employee
order by dept
--2¡¢²éÕÒÓëÓ÷×ÔÇ¿ÔÚͬһ¸öµ¥Î»µÄÔ±¹¤ÐÕÃû¡¢ÐԱ𡢲¿ÃźÍÖ°³Æ
select ......

sql×¢Èë¼°·À·¶

ËùνSQL×¢Èëʽ¹¥»÷£¬¾ÍÊǹ¥»÷Õß°ÑSQLÃüÁî²åÈëµ½Web±íµ¥µÄÊäÈëÓò»òÒ³ÃæÇëÇóµÄ²éѯ×Ö·û´®£¬ÆÛÆ­·þÎñÆ÷Ö´ÐжñÒâµÄSQLÃüÁî¡£ÔÚijЩ±íµ¥ÖУ¬Óû§ÊäÈëµÄÄÚÈÝÖ±½ÓÓÃÀ´¹¹Ôì(»òÕßÓ°Ïì)¶¯Ì¬SQLÃüÁ»ò×÷Ϊ´æ´¢¹ý³ÌµÄÊäÈë²ÎÊý£¬ÕâÀà±íµ¥ÌرðÈÝÒ×Êܵ½SQL×¢Èëʽ¹¥»÷¡£³£¼ûµÄSQL×¢Èëʽ¹¥»÷¹ý³ÌÀàÈ磺
¡¡¡¡¢Å ij¸öASP.NET WebÓ¦ÓÃÓÐÒ»¸ö ......

±í½á¹¹ÐÅÏ¢²éѯ sql server 2005


--sql server 2005
-- 1. ±í½á¹¹ÐÅÏ¢²éѯ
-- ========================================================================
-- ±í½á¹¹ÐÅÏ¢²éѯ
-- ×Þ½¨ 2005.08(ÒýÓÃÇë±£Áô´ËÐÅÏ¢)
-- ========================================================================
SELECT
    TableName=CASE WHEN ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ