¼òµ¥µÄ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
Ïà¹ØÎĵµ£º
--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 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚTransact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØÊµÏÖSQL SERVER¡¢ACCESS¡¢EXCELÊý¾Ýת»»£ ......
±êÇ©£ºÊý¾Ý·ÃÎÊ ADO.NET
DataAdapter ¶ÔÏóÖеÄSQLÃüÁî ×¢£ºADO.NET¶ÔÏóÄ£ÐÍ ºÍ C# Òª±È SQL ¸üÊʺϴ¦Àí¸´ÔÓÔËËã ºÍ µ¼º½Âß¼£¨±ÈÈ磬²éÕÒÏà¹ØµÄÁíÒ»¸ö±íµÄÊý¾Ý£©
......