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

¼òµ¥µÄsqlµÇ¼ºÍ×¢²á´æ´¢¹ý³Ì

 Ê×ÏÈÎÒ½¨ºÃÁËÒ»ÕÅÓû§±í±íÖÐÓÐÁ©¸ö×Ö¶Î Ò»¸öÊÇÕ˺ţ¬Ò»¸öÊÇÃÜÂ뵱ȻÕâÀïÎÒдµÄ֪ʶ¼òµ¥µÄµÇ¼ºÜ×¢²á£¬
±íÃ÷ users Óû§±í
×Ö¶Î accountnum  varchar(50) --±íʾÕ˺Å
        password     varchar(50) --±íʾÃÜÂë
µÇ¼´æ´¢¹ý³Ì
create proc use_login
(
@accountnum varchar(50),
@password varchar(50),
@message  varchar(50) output

as
  if exists(select * from users where accountnum=@accountnum and  password=@password)
   set @message='µÇ¼³É¹¦'
 else  if  exists(select * from users where accountnum=@accountnum )
   set @message='ÃÜÂë´íÎó'
 else if exists(select * from users where password=@password)
  set @message='Óû§Ãû´íÎó'
else
  set @message='Óû§ÃûºÍÃÜÂë¶¼´íÎó'
declare @msg as varchar(50)
exec use_login 'text','text',@msg output
print @msg
×¢²á´æ´¢¹ý³Ì
create proc use_registration
(
@accountnum varchar(50),
@password varchar(50),
@message  varchar(50) output
)
as
  if exists(select * from users where accountnum=@accountnum)
   set @message='¸ÃÓû§ÒѾ­´æÔÚ'
 else
    begin
     insert into users values(@accountnum,@password)
     set @message='¹§Ï²Äú£¬¿ÉÒÔ×¢²á¸ÃÓû§'
  end 
  declare  @msg as varchar(50)
 exec use_registration 'text','text',@msg output
print @msg
ÉÏÃæÔÙÖ´Ðд洢¹ý³ÌµÄʱºò Òª´òÓ¡ËùÒªÏÔʾ³öÀ´µÄÐÅÏ¢ÓõÄÊÇprint Ò²¿ÉÒÔÓÃselect
 


Ïà¹ØÎĵµ£º

Mysql µ¼Èë .sqlÎļþÖÐÎÄÂÒÂ룿

 --default-character-set=utf8 ÓëÐÞ¸ÄsqlÎļþ¼ÓÈ룺SET NAMES 'utf8'; 
µ¼Èë½Å±¾Ê±£¬SET NAMES 'xxx' £¬xxxÓ¦¸ÃºÍsql½Å±¾ÎļþµÄʵ¼Ê±àÂëÒ»Ö£¬Èç¹ûÄãÉèÖõÄʱutf-8 £¬ÄÇôÇëÈ·ÈÏÄãµÄsql½Å±¾Îļþʱutf-8±£´æµÄ:
iconv -f UTF-8 xxx.sql
Èç¹ûÏÔʾÕý³££¬ÄÇôÕâÒ»²½¾ÍOKÁË
ÁíÍâ×¢ÒâÄãµÄ½Å±¾ÀÓÐûÓиø¿â±íÉèÖ ......

SQL SERVERÓëACCESS,EXCELµÄÊý¾Ýת»»

ÊìϤSQL SERVER 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚTransact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØÊµÏÖSQL SERVER¡¢ACCESS¡¢EXCELÊý¾Ýת»»£ ......

DataAdapter ¶ÔÏóÖеÄSQLÃüÁî

±êÇ©£ºÊý¾Ý·ÃÎÊ     ADO.NET
    DataAdapter ¶ÔÏóÖеÄSQLÃüÁî     ×¢£ºADO.NET¶ÔÏóÄ£ÐÍ ºÍ C#  Òª±È SQL ¸üÊʺϴ¦Àí¸´ÔÓÔËËã ºÍ µ¼º½Âß¼­£¨±ÈÈ磬²éÕÒÏà¹ØµÄÁíÒ»¸ö±íµÄÊý¾Ý£©
   &# ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ