C#Êý¾Ý¿â±à³Ì»ù´¡Ö®sqlÓï¾ä²Ù×÷Êý¾Ý¿âÊý¾Ý
	
    
    
	        Á¬½Ósql serverÊý¾Ý¿âÓõ½µÄÃüÃû¿Õ¼äÊÇusing System.Data.SqlClient;
  Êý¾Ý¿âÁ¬½Ó´úÂë:¿ÉÒÔÔÚ´óÀàÖ®ÏÂÉùÃ÷ public SqlConnection myConnection;  //sqlÁ¬½Ó¶ÔÏó
                                    public  SqlCommand myCmd;  //ÓÃÓÚ´æ´¢sqlÓï¾äµÄ¶ÔÏó
        ÁíÒ»ÖÖ¶ÁÈ¡¶ÔÏóÊÇdataset     public SqlDataReader myreader; //ÓÃÓÚ¶ÁÈ¡Êý¾Ý¿âµÄ¶ÔÏó
   SqlConnection myConnection;µÄÓ÷¨ÊÇÔÚÆä¹¹Ô캯ÊýÄÚÖ¸Ã÷Á¬½Ó×Ö·û´®
    myConnection = new SqlConnection("Á¬½Ó×Ö·û´®");
   ¿ÉÒÔÓÃÅäÖÃÎļþÀ´±£´æ¸ÃÁ´½ÓÎļþ,ÕâÑù¼´±ã¸ü»»SQL SERVERÊý¾Ý¿âµÄ·þÎñÆ÷,Ö»ÒªÔÚ½â¾ö·½°¸Àï¸Ä±äÅäÖÃÎļþapp.configÀïµÄÁ¬½Ó×Ö·û´®¾Í¿ÉÒÔÁË¡£¾ßÌåµÄ²Ù×÷ÊÇ:ÔÚVSÖÐË«»÷ÊôÐÔ,ÔÚ³öÏֵĶԻ°¿òÖÐÑ¡"ÉèÖÃ",ÔÚÀïÃæÌîºÃ"Ãû³Æ","ÀàÐÍ","Öµ"¡£Òª¼ÇסÄãÌíµÄÃû³Æ£¨¼ÙÉèΪconnectionstring£©¡£ÔÙÔÚ´úÂëÖÐÉùÃ÷Ò»¸ö×Ö·û´®±äÁ¿str,¸øËû¸³ÖµÎª:Properties.Settings.Default.connectionstring;È»ºó myConnection = new SqlConnection("str"); myConnection.Open(); ¾Í¿ÉÒÔÁ¬½ÓÊý¾Ý¿âÁË¡£
   SqlCommand myCmd; µÄÓ÷¨ÊÇÔÚÆä¹¹Ô캯ÊýÄÚд³ösqlÓï¾äºÍÁ¬½Ó×Ö·û´®¶ÔÏó
    myCmd = new SqlCommand("sqlÓï¾ä",myConnection);
   ÕâÖ»ÊÇ´æ´¢sqlÓï¾ä,»¹Ã»ÓаÑËü½»¸øÊý¾Ý¿â´¦Àí,Òª½»¸øÊý¾Ý¿â´¦Àí¿ÉÒÔÓà myCmd.ExecuteNonQuery();¸Ã·½·¨ÊÇÖ´ÐÐmyCmdÄÚµÄsqlÓï¾ä,²¢·µ»ØintÐ͵ÄÊÜÓ°ÏìµÄÐÐÊý, ¸ü¶àÓõÄÊÇ SqlDataReader myreader¶ÁÈ¡Êý¾Ý¿âµÄ¶ÔÏó.
   SqlDataReader myreader;  Ö»ÄÜͨ¹ýSqlCommand myCmdµÄExecuteReader()´´½¨ÊµÀý Ó÷¨ÊÇ:
   myreader = myCmd.ExecuteReader();  ´´½¨ SqlDataReaderʵÀýµÄͬʱ,ÏòÊý¾Ý¿âÌá½»ÁËsqlÓï¾ä
   ÓÃSELECTÓï¾ä²éѯÊý¾Ýºó¿ÉÒÔÓÃmyreader.Read()À´ÅжÏÊý¾Ý¿âÖÐÓÐûÓÐÒª²éѯµÄÊý¾Ý£¬¸Ã·½·¨·µ»ØµÄÊÇÒ»¸ö²¼¶ûÀàÐÍ,Èç¹ûmyreader.Read()·µ»Øtrue˵Ã÷Êý¾Ý¿âÖÐÓÐÒª²éѯµÄÊý¾Ý,·´Ö®,˵Ã÷Êý¾Ý¿âÖÐûÓÐÒª²éѯµÄÊý¾Ý¡£Èç¹û²éѯ
    
     
	
	
    
    
	Ïà¹ØÎĵµ£º
        
    
    µ±Ë÷ÒýËùÔÚÒ³ÃæµÄ»ùÓÚÖ÷¹Ø¼ü×ÖµÄÂ߼˳Ðò£¬ºÍÊý¾ÝÎļþÖеÄÎïÀí˳Ðò²»Æ¥Åäʱ£¬Ë鯬¾Í²úÉúÁË¡£ËùÓеÄÒ¶¼¶Ò³°üº¬ÁËÖ¸Ïòǰһ¸öºÍºóÒ»¸öÒ³µÄÖ¸Õë¡£ÕâÑù¾ÍÐγÉÒ»¸öË«Á´±í¡£ÀíÏëÇé¿öÏ£¬Êý¾ÝÎļþÖÐÒ³µÄÎïÀí˳Ðò»áºÍÂ߼˳ÐòÆ¥Åä¡£Õû¸ö´ÅÅ̵Ť×÷ÐÔÄÜÔÚÎïÀí˳ÐòÆ¥ÅäÂ߼˳Ðòʱ½«ÏÔÖøÌáÉý¡£¶ÔÄ³Ð©ÌØ¶¨µÄ²éѯ¶øÑÔ£¬Õ⽫´øÀ´¼«¼ÑµÄÐÔÄÜ ......
	
    
        
    
    /* °üº¬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;
     ......
	
    
        
    
    sqlÓïÑÔÖÐÓÐûÓÐÀàËÆCÓïÑÔÖеÄswitch caseµÄÓï¾ä£¿£¿
  ûÓÐ,ÓÃcase   when   À´´úÌæ¾ÍÐÐÁË.   
       
  ÀýÈç,ÏÂÃæµÄÓï¾äÏÔʾÖÐÎÄÄêÔ   
    
  select   getdate()   as   È ......
	
    
        
    
    CREATE FUNCTION [dbo].[f_num_chn] (@num numeric(14,2))
RETURNS varchar(100) WITH ENCRYPTION --¼ÓÃÜ
AS
BEGIN
--°æÈ¨ËùÓУºpbsql
  DECLARE @n_data VARCHAR(20),@c_data VARCHAR(100),@n_str VARCHAR(10),@i int
  SET @n_data=RIGHT(SPACE(14)+CAST(CAST(ABS(@num*100) AS bigint) AS varchar(20)), ......
	
    
        
    
    NULL£¬±íʾ²»Ã÷È·¡¢Î´ÖªµÄÁÐÖµ
²âÊÔ±í£ºtestnull(id varchar(32))
Êý¾Ý¿â£ºSybase ASA11.0
ÐÐÊý¾Ý(''), (NULL)
Êý¾Ý¿âÑ¡ÏîansinullΪtrue(Ò²ÊÇASAÊý¾Ý¿âµÄĬÈÏÑ¡Ïî)ʱ£¬
select * from testnull where id = null
select * from testnull where id != null
½á¹û¾ùΪ¿Õ
select * from testnull where id is null
½á¹ ......