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

¼±£¡Ò»¸ö¹ØÓÚSQLµÄ¼òµ¥ÎÊÌâ

Delphi(Pascal) code:
with ADOQuery1 do
begin
Close;
SQL.Clear;
SQL.Add('select * from pw where ÀàÐÍ=:a AND ±êÌâ=:b');
Parameters.ParamByName('a').Value:=spSkinComboBox1.Items[spSkinComboBox1.ItemIndex];
Parameters.ParamByName('b').Value:=spSkinEdit2.Text;
Prepared;
Open;
if RecordCount=0 then
Append;
FieldByName('ÀàÐÍ').AsString:=spSkinComboBox1.Items[spSkinComboBox1.ItemIndex];
FieldByName('±êÌâ').AsString:=spSkinEdit2.Text;
FieldByName('Óû§Ãû').AsString:=spSkinEdit3.Text;
FieldByName('ÃÜÂë').AsString:=spSkinEdit5.Text;
FieldByName('±¸×¢').AsString:=memo1.Text;
Post;
end;

ÕâÊÇ´úÂ룬Ӧ¸ÃÊÇÄǼ¸¸ö²ÎÊýÎÊÌ⣬´íÎóÌáʾÊÇ: ÖÁÉÙÓÐÒ»¸ö²ÎÊýûÓб»Ö¸¶¨Öµ
ÎҺܼ±£¬¸øÎÒ´óÏÀ¿ì°ïæ!
try
Delphi(Pascal) code:
SQL.Add('select ÀàÐÍ,±êÌâ,Óû§Ãû,ÃÜÂë,±¸×¢ from pw where ÀàÐÍ=:a AND ±êÌâ=:b');


崃쵀
²»Ðа¡
´óÏÀ¿ìÏÖÉí

spSkinComboBox1.Items[spSkinComboBox1.ItemIndex];
stringֵû±ØÒª ÕâÑùд°¡¡£¡£Ö±½ÓSPSKINCOMBOBOX1.TEXT¶àºÃ¡£¡£ÄãÕâ¸öд·¨ÎÒÓеãÏë²»Ã÷°×¡£Äã¼Ó±äÁ¿¸½Ò»ÏÂÖµ¡£¸ú×ÙһϿ´¿´¡£¡£Ó¦¸ÃÊÇÕâÀïµÄÎÊÌâ¡£
{{


Ïà¹ØÎÊ´ð£º

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

sqlת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

sqlССµÄÒÉÎÊ - .NET¼¼Êõ / C#

¿ÉÄÜÒòΪ¹¤×÷µÄÔ­Òò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......

Êý¾ÝÒÔxml¸ñʽ·µ»Ø - MS-SQL Server / Ó¦ÓÃʵÀý

´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......

MS SQL×÷ÒµÎÊÌâ - MS-SQL Server / Ó¦ÓÃʵÀý

ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP

²Î¿¼:http://hi.baidu.com/toiota ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ