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

ÔÚc#ÖеÄÈ¡µÃsql´æ´¢¹ý³ÌµÄoutput²ÎÊý

һֱûÓÐÕÒµ½Ò»Öֺõķ½·¨À´ÒýÓÃÓзµ»ØÖµµÄ´æ´¢¹ý³ÌµÄ·½·¨£¬Ê¹ÎÒÔÚÌí¼ÓÊý¾ÝÖÐ×ßÁ˲»ÉÙµÄÍä·£¬×î½ü£¬ÔÚ²éÔÄÁË´óÁ¿µÄ×ÊÁÏÖ®ºó£¬ÖÕÓÚÔÚ΢ÈíµÄÒ»¸öʵÀýÖÐÕÒµ½ÁËÒ»ÖÖÁ¼ºÃµÄ·½·¨¡£
Ê×ÏȱàдºÃÒ»Óзµ»ØÖµµÄ´æ´¢¹ý³Ì
create procedure proc_name
   @para1 nchar(20),    --ÊäÈë²ÎÊý
   @para2 int = null out¡¡--Êä³ö²ÎÊý£¬¹©³ÌÐòʹÓÃ
as
   set nocount on
   if ( not exists (select * from employee where em_name=@para1))
   begin
       insert into employee(name) values(@para1)  
       select @para2=@@identity      --·µ»ØÌí¼Ó¼Ç¼µÄID
       return 1                                --·µ»ØÊÇ·ñ³É¹¦Ìí¼ÓÊý¾Ý
   end
   else
      return 0                               --·µ»ØÊ§°Ü
go
È»ºóÊǵ÷Óô洢¹ý³ÌµÄ·½·¨
sqlcommand command;
command = new sqlcommand(proc_name,new sqlconnection(connectionstr));
command.paraments.add("@para1"),"name1");  //ÊäÈë²ÎÊý£¬Ö°Ô±ÐÕÃû
command.paraments.add(new sqlparament("@para2",   //Éú³ÉÒ»Êä³ö²ÎÊý
SqlDbType.Int;¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡//²ÎÊýÊý¾ÝÀàÐÍ
ParamenterDirection.OutPut,¡¡¡¡¡¡¡¡¡¡¡¡//ÊäÈëÊä³öÀàÐÍ
0,
0,
string.Emplty,
DataRowVerstion.Default,
null)¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡//²ÎÊýÖµ£¬ÊäÈë²ÎÊýʱÐèÌṩ
);
command.commandtype=commandtype.StoredProcedure;
command.connection.open();
command.executenonQuery();
int pkid=(int)command.Parameters["@para2"].value;  //µÃµ½Êä³ö²ÎÊýµÄÖµ
command.connection.close();
´Ë´¦ÊÇÒýÓÃÊä³ö²ÎÊý£¬Èç¹ûÒªÒýÓ÷µ»ØÖµ£¨ÊÇ·ñ³É¹¦Ìí¼ÓÊý¾Ý£©ÔòÖ»Ðè°ÑParamenterDirec


Ïà¹ØÎĵµ£º

SQLÓï¾äÓÅ»¯

SQLÓï¾äµÄÓÅ»¯¾ÍÊǽ«ÐÔÄܽϵ͵ÄSQLÓï¾äת»»´ï³ÉͬÑùÄ¿µÄÐÔÄÜÓÅÒìµÄSQLÓï¾ä
ÏÂÃæÎÒÃÇÒ»ÆðÀ´¿´¿´Ò»Ð©¿ÉÒÔÓÅ»¯SQLµÄ·½·¨£¬Ï£Íû´ó¼Ò¶àÌá³öÒâ¼ûÎÒÃǹ²Í¬Ñ§Ï°»òÕßÊÇ´ó¼ÒÓÐʲôºÃµÄÓÅ»¯·½·¨¿ÉÒÔÌá³öÀ´¹²Ïíһϡ£
 
µÚÒ»ÖÖÓÅ»¯£¨Ê¹ÓÃÖ¸¶¨ÁдúÌæ”*”£©
       ʹÓÓ*&rdquo ......

sql server2005²éѯÓÅ»¯½¨Òé


²éѯÓÅ»¯µÄÄ¿µÄÊÇÌá¸ßÊý¾Ý¼ìË÷ËÙ¶È£¬Ìá¸ßÊý¾Ý¼ìË÷Òâζ׿õÉÙ´ÅÅÌ
IO
¶ÁÈ¡»òÕßÂß¼­ÄÚ´æ¶ÁÈ¡´ÎÊý£¬ÕâÐèÒª´ÓÁ½¸ö·½ÃæÈëÊÖ£ºÊý¾ÝÒª¾¡¿ÉÄܵĻº´æµ½ÄÚ´æ¡¢¾¡¿ÉÄܵÄʹÓÃË÷Òý¡£ÄÚ´æµÄÎÊÌâ¿ÉÒԲμû
 
:
http://msdn.microsoft.com/zh-cn/library/ms188284.aspx
£¬±¾ÎÄÖ÷ÒªÊÇÌåÏÖÈçºÎʹÓÃË÷ÒýÀ´Ìá¸ßËÙ¶È¡£¾ßÌå·½·¨£º
1) ......

sql·ÖÒ³£¨×ª£©

½¨Á¢Ò»¸ö Web Ó¦Ó㬷ÖÒ³ä¯ÀÀ¹¦Äܱز»¿ÉÉÙ¡£Õâ¸öÎÊÌâÊÇÊý¾Ý¿â´¦ÀíÖÐÊ®·Ö³£¼ûµÄÎÊÌâ¡£¾­µäµÄÊý¾Ý·ÖÒ³·½·¨ÊÇ:ADO ¼Í¼¼¯·ÖÒ³·¨£¬Ò²¾ÍÊÇÀûÓÃADO×Ô´øµÄ·ÖÒ³¹¦ÄÜ£¨ÀûÓÃÓα꣩À´ÊµÏÖ·ÖÒ³¡£µ«ÕâÖÖ·ÖÒ³·½·¨½öÊÊÓÃÓÚ½ÏСÊý¾ÝÁ¿µÄÇéÐΣ¬ÒòΪÓα걾ÉíÓÐȱµã£ºÓαêÊÇ´æ·ÅÔÚÄÚ´æÖУ¬ºÜ·ÑÄÚ´æ¡£ÓαêÒ»½¨Á¢£¬¾Í½«Ïà¹ØµÄ¼ÇÂ¼Ëø×¡£¬Ö±µ½È¡ÏûÓ ......

sql server Ë÷ÒýÈëÃÅ

    ×î½ü×öÁËÒ»ÍøÕ¾£¬µ«ÊÇÔÚÍâÃæ·ÃÎÊÌ«Âý¡£±¾ÏëÕÒÏÂÔ­Òò¡£¿´¿´ÊdzÌÐòÔ­Òò»¹ÊÇÊý¾Ý¿âÔ­Òò¡£ÔÚÍøÉϹä¹ä¡£¿´ÁËÒ»ÏÂÊý¾Ý¿âË÷Òý¡£ÏÖÔÚ×ܽáһϡ£·½±ãÏ´β鿴¡£±¾ÎıȽϻù´¡ÊÇÈëÃż¶±ðµÄ¡£
     Ê×ÏÈ£¬Ê²Ã´ÊÇË÷Òý£¿´ÓBookOnlineÉÏsearchÁËһϣº    
  &nbs ......

sql°²×°ÎÊÌâ

Ò»¡¢Çé¿ö˵Ã÷
    sql server 2000ÒÔǰµÄ°æ±¾£¬ÀýÈç7.0Ò»°ã²»´æÔÚ¶à¸ö°æ±¾£¬Ö»Óбê×¼°æ¸ú×ÀÃæ°æ£¬Óû§Èç¹û²»Çå³þ¸Ãװʲô°æ±¾µÄ»°£¬¿É°´°²×°ÉϵÄ
°²×°ÏȾöÌõ¼þָʾ°²×°£¬Ò»°ãÔÚWIN2000 ·þÎñÆ÷°æÉÏ×°±ê×¼°æ£¬ÆäËûµÄϵͳװ×ÀÃæ°æµÄ¾Í¿ÉÒÔ£»¶øSQL Server 2000°²×°ÎÊÌâ¾Í±È½Ï´ó£¬Ê±³£
¼ûµ½µÄÎÊÌâÈçÏ£º
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ