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

AIRÖ´ÐÐSQLÓï¾ä

 ÎÒÃǵÄSQLÓï¾äµÄÖ´Ðж¼ÊÇÓÉÒ»¸öÀàÀ´Íê³ÉµÄ£¡Õâ¸öÀà¾ÍÊÇSQLStatement£¬Õâ¸öÀà¾ÍÊÇÎÒÃÇÓÃÀ´Ö´ÐÐSQLÓï¾äµÄÀ࣬¸ÃÀàµÄʹÓÃÒ²ÊǷdz£¼òµ¥µÄ£¬ÎÒÃÇÖ»ÐèÒª¼ÇסÁ½¸öÊôÐÔÁ½¸ö·½·¨¡£ÎÒÃÇÀ´¿´Ò»Ï£¡
textÊôÐÔ£ºËùÒªÖ´ÐеÄSQLÓï¾ä£¬¸ÃÊôÐÔÊÇÒ»¸ö×Ö·û´®¸ñʽ£¬ËùÒÔÎÒÃǵÄSQLÓï¾ä¶¼ÊÇ×Ö·û´®£¡
sqlConnectionÊôÐÔ£º¸ÃÊôÐÔÊÇÉèÖÃSQLStatement¶ÔÏóËùÒª°ó¶¨µÄSQLConnection¶ÔÏó£¬Õâ¸öÊôÐÔÎÒÃÇÒ»°ãÔÚ´´½¨SQLStatment¶ÔÏóµÄʱºò¾ÍÉ趨µÄ£¡
execute·½·¨£ºÕâ¸ö·½·¨ºÜ¼òµ¥£¬±íʾִÐÐSQLÓï¾ä¡££¨ÓеãÏñplay£©
getResult·½·¨£ºÕâ¸ö·½·¨Í¦ÖØÒªµÄ£¬ÒòΪÎÒÃÇ·ÃÎʵÄÊý¾Ý¿âºó·µ»ØµÄÊý¾Ý¶¼Í¨¹ýÕâ¸ö·½·¨´æ´¢µ½Ò»¸öSQLResult¶ÔÏóÖУ¡
    ºÃÁË£¡ÎÒÃÇÀ´¿´Ò»¸öʵÀý°É£¡Õâ¸öʵÀýÖн«Ö´ÐÐÒ»¸ö²éѯÓï¾ä£¬¸ÃÓï¾ä²éѯºóµÄ½á¹û»átrace³öÀ´£¡
package
{
import flash.data.SQLConnection;
import flash.data.SQLResult;
import flash.data.SQLStatement;
import flash.display.Sprite;
import flash.errors.SQLError;
import flash.events.MouseEvent;
import flash.events.SQLErrorEvent;
import flash.events.SQLEvent;
import flash.filesystem.File;
/**
* ...
* */
public class Main extends Sprite
{
   private var file:File = File.applicationDirectory.resolvePath("abc.db");
   private var shuju:SQLConnection = new SQLConnection();
   private var sqlcaozuo:SQLStatement = new SQLStatement();
   private var a:Sprite = new Sprite();
   public function Main():void
   {
    shuju.addEventListener(SQLEvent.OPEN, openfile);
    shuju.addEventListener(SQLErrorEvent.ERROR, cuowu);
    shuju.addEventListener(SQLEvent.CLOSE, ting);
    shuju.open(file);
    //////////
    a.graphics.beginFill(0x00ff00);
    a.graphics.drawRect(0, 0, 100, 100);
    a.graphics.endFill();
    addChild(a);
    a.addEventListener(MouseEvent.CLICK, an);
   }
   private function ting(evt:SQLEvent):void
   {
    trac


Ïà¹ØÎĵµ£º

sql serverÎÞ·¨Á¬½Ó issue

http://blog.csdn.net/java2000_net/archive/2008/04/05/2252640.aspx
http://sqlserver.chinahtml.com/2006/SQL-mssql11432786154012.shtml
http://www.cnblogs.com/garnai/archive/2007/09/19/898221.html
http://tech.ccidnet.com/art/1099/20050223/214511_1.html
http://www.wangchao.net.cn/bbsdetail_43009.html ......

SQLÖÐcase whenµÄÁ½ÖÖʹÓ÷½·¨Ê¾Àý

Case¾ßÓÐÁ½ÖÖ¸ñʽ¡£¼òµ¥Caseº¯ÊýºÍCaseËÑË÷º¯Êý¡£
--¼òµ¥Caseº¯Êý
CASE sex
         WHEN '1' THEN 'ÄÐ'
         WHEN '2' THEN 'Å®'
ELSE 'ÆäËû' END
--CaseËÑË÷º¯Êý
CASE WHEN sex = '1' THEN 'ÄÐ'
  &nbs ......

sql ¼ÓÃÜ

use Tempdb
go
if object_ID ( 'fn_ACITEncryption' ) is not null
drop function fn_ACITEncryption
go
create function fn_ACITEncryption
(
@Str nvarchar ( 4000), -- ¼ÓÃܵÄ×Ö·û´®
@Flag bit = 1, --1 ¡¢¼ÓÃÜ 0 ¡¢½âÃÜ
@Key nvarchar ( 50) -- ÃÜÎÄ
)
returns nvarchar ( 4000) ......

SQL°´ÕÕÈÕ¡¢ÖÜ¡¢Ô¡¢Äêͳ¼ÆÊý¾Ý

SQL°´ÕÕÈÕ¡¢ÖÜ¡¢Ô¡¢Äêͳ¼ÆÊý¾Ý ÊÕ²Ø
ÎÄÕ²ο¼£ºhttp://www.cnblogs.com/wenbhappy/archive/2008/07/02/1233660.html
Èç: 
±í:consume_record 
×Ö¶Î:consume (moneyÀàÐÍ) 
date (datetimeÀàÐÍ) 
ÇëÎÊÔõôдËÄÌõsqlÓï¾ä·Ö±ð°´ÈÕ,°´ÖÜ,°´ÔÂ,°´¼¾Í³¼ÆÏû·Ñ×ÜÁ¿. 
Èç:1Ô 1200Ô ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ