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

C#ÖÐÓÃÓÚÁ¬½ÓSQLÊý¾Ý¿âµÄSQLHelperÀà

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;   //ÒýÓÃÃüÃû¿Õ¼ä
namespace DAL
{
    /*******************************************************************************
    * Name: SQLHelper
    * File: SQLHelper.cs
    * Description: ÓÃÓÚÍê³É¶ÔÊý¾Ý¿âµÄÏà¹Ø²Ù×÷
    * Author: Ñ©ÀÇ
    * DateTime: 2010Äê05ÔÂ13ÈÕ
    *******************************************************************************/
    public class SQLHelper
    {
        //ÉèÖÃÁ¬½Ó×Ö·û´® —— SQL ServerÑé֤ģʽµÄÁ¬½Ó×Ö·û´®
        //public static string strConn = @"server = PANLING;database = StudentMIS;uid = sa;pwd = sa";
        //ÉèÖÃÁ¬½Ó×Ö·û´® —— WindowsÑé֤ģʽµÄÁ¬½Ó×Ö·û´®
        public static string strConn = @"server = T403-004\HB_SQLSERVER;database = DB_LibraryManage;Integrated Security = SSPI";
        /// <summary>
        /// ¹¦ÄÜÃèÊö£ºÖ´ÐÐADO.NETÔö¡¢É¾¡¢¸Ä²Ù×÷
        /// </summary>
        /// <param name="strText">ÊäÈë²ÎÊý —— ÒªÖ´ÐеÄSQLÓï¾ä(ÃüÁîÎı¾)</param>
        /// <param name="cmdType">ÊäÈë²ÎÊý —— ÒªÖ´ÐеÄSQLÃüÁîÀàÐÍ</param>
        /// <param name="SqlParams">ÊäÈë²ÎÊý —— ÒªÖ´ÐеÄSQLÓï¾äÖеIJÎÊýÁбí(ÃüÁî²ÎÊýÁбí)</param>
        /// <returns>·µ»ØÖ´ÐÐÓ°ÏìµÄÐÐÊý</returns>
        public static int MyExecu


Ïà¹ØÎĵµ£º

ºÃµÄSQLÊÕ¼¯ ²»¶Ï¸üÐÂÖÐ

1.Çó1..10żÊýÖ®ºÍ
select sum(level) from dual
where mod(level,2)=0
connect by level
 
2.½«update¸Ä»»³ÉÓÃrowidÀ´ÊµÏÖ¡£
£¨1£©ÐµÄд·¨£º
merge into SNAPSHOT120_2010_572 t1
using (select a.rowid rid, b.vip_level, b.manager_name
       from xyf_vip_info_new b, snapsho ......

ADO.NETºÍSQL SERVERÊý¾Ý¿âÖеÄÊý¾ÝÀàÐͶÔÓ¦¹ØÏµ

ÎÒÃÇÖªµÀ£¬ÔÚSQL SERVERÖÐÓÐBit, Float, Int , CharµÈµÈһϵÁеÄÊý¾ÝÀàÐÍ£¬¶øÔÚDOT NETÖУ¬ÓÐBoolean,Double,Int 32,StringµÈÊý¾ÝÀàÐÍÓëÖ®¶ÔÓ¦¡£ Ò²¾ÍÊÇ˵£¬Êý¾Ý¿âÖеÄÊý¾ÝÀàÐÍÓëDOT NETµÄÊý¾ÝÀàÐÍÖ®¼ä£¬ÓÐÒ»¸öÓ³Éä¹ØÏµ¡£Ï±íÊÇËûÃǵÄÓ³Éä¹ØÏµ£º
 
dot netÖеÄÊý¾ÝÀàÐÍ       &n ......

sql ²éѯ±íµÄÁÐÃû row_number()

select upper(name) from syscolumns
where id =any
(
select Id from sysobjects where name='tb_city'
)
lower
select row_number() over(order by firmid) from dbo.tb_BuildingMaterial
Éú³É  ×ÔÔö  123
select rank() over(order by firmid) from dbo.tb_BuildingMaterial
Éú³É×ÔÔö123  ¸ù¾ÝÅ ......

SQL SERVER 2008Êý¾Ý¿â¸½¼Ó

 
2008Êý¾Ý¿â¸½¼Ó
 
/*
ÍøÉÏ¿´µ½µÄÕûÀíÁËһϡ£
Ô­ÎĵØÖ·http://database.51cto.com/art/201003/190984.htm
 
 
ÔÚSQL Server 7.0ÖУ¬Î¢ÈíÍÆ³öÁËsp_attach_dbºÍsp_attach_single_file_dbϵͳ´æ´¢¹ý³Ì¡£
Ëü¶ÔÓÚSQL ServerÊý¾Ý¿â¹ÜÀíÔ±Ö´ÐÐÏÂÃæµÄÈÎÎñÊǷdz£·½±ãµÄ£º
 
1 ʹÓÃsp_attach_d ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ