SQLÊÂÎñ£¬Í¬Ê±Ö´Ðд¿sqlÓï¾äºÍ´ø²ÎµÄSQLÓï¾ä
/// <summary>
193 /// Ö´ÐÐÊý¾Ý¿âÊÂÎñ
194 /// </summary>
195 /// <param name="sqlStringList"> </param>
196 public void ExecuteTransaction(System.Collections.ArrayList sqlStringList)
197 {
198 Connection.Open();
199 DbTransaction tran = Connection.BeginTransaction();
200 DbCommand Command = BuildInitCommand();
201 Command.Transaction = tran;
202 try
203 {
204 for (int i = 0; i < sqlStringList.Count; i++)
205 {
206 Command.CommandText = sqlStringList[i].ToString();
207 Command.ExecuteNonQuery();
208 }
209 tran.Commit();
210 &n
Ïà¹ØÎÊ´ð£º
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿
21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......
»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
ÔÚsqlÖÐʹÓÃoutputºÍ²»Ê¹ÓõÄÇø±ð£¿
ÀýÈ磺
ALTER PROCEDURE [dbo].[sp_1]
@SYS_LNNO varchar(20),
@SYS_CALLER varchar(20),
@SYS_ORGANIZE varchar(10), ......
ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ
DB2ÖÐÈçºÎʹÓÃÐ ......