Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ : sqlserver

sqlserverÈ«ÎÄË÷ÒýµÄÔ­Àí

ÎÒ¿´Á˺ܶàÎÄÕ£¬Ð´µÄ̫רҵ£¬Äܲ»ÄÜÓôó°×»°½²½²£¬¾ÍÊÇÔõô¹¹½¨Ë÷ÒýµÄ£¬²éµÄʱºòÊÇÔõôÑùµÄ²½Ö裬Ϊʲô±Èlike¿ì£¬ÊDz»ÊÇÖ»ÒªÓÃcontect£¬¾ÍÒ»¶¨»áÈ¥²é£¬±ÈÈç
select * from table where contect('sdfsd',sdf) and id=5
idÊÇÖ÷¼ü£¬Õâʱ»áÈ¥²éÈ«ÎÄË÷ÒýÂð£¿ÎªÊ²Ã´£¿
¾¡Á¿Óôó°×»°½²£¬Õ³ÌùרҵÎÄ×Ö¾ÍËãÁË
ÎÊÌâ²¹³ä£ººÃ°É£ ......

VF6ÏÂÁ¬½Ósqlserverµ÷Óô洢¹ý³Ì

ÏÖÔÚÓöµ½µÄÎÊÌ⣺
¶ÁÈ¡±¾µØÒÑÓеÄdbfÊý¾Ý¿â,дÈëµ½SQLSERVER2000ÖУ¬µ«ÊÇ¿´ÊéºÍÍøÉÏÈ«ÊÇÏîÄ¿×Ô´øÊý¾Ý¿âµÄ¶Áд£¨¼´°ó¶¨Êý¾ÝÔ´£©¡£
ÒÑÖªµÀdbfµÄ·¾¶£¬µ«ÊÇÁ¬½ÓµÄ×Ö·û´®ºÍÊý¾Ý¶ÁÈ¡µÄ²Ù×÷Ôõôд£¿
ÈçºÎÁ¬½ÓSQLServer2000,²¢µ÷ÓÃÆä´æ´¢¹ý³Ì£¿
ÎÒÏëÖªµÀͨ¹ýsqlÓï¾äÈçºÎ¶Á£¬ÈçºÎд.
ÏÈлл¸÷λµÄ½â´ð¡£
connDbf = ......

sqlserver ×Ô¶¨Ò庯Êýreturn ÎÊÌâ

SQL code:
create function subDepartment(@id varchar(36),@flag int)
returns @re table(subid varchar(36))
as
begin
insert @re select deli_id from departmentlink where deli_type=32
and deli_id =@id
if @flag=0
return
while @@rowcount>0
begin
......

ÈçºÎ½«accessÊý¾Ý¿âÎļþµ¼Èësqlserver2005

ÈçºÎ½«accessÊý¾Ý¿âÎļþµ¼Èësqlserver2005 
µ¼Èëµ¼³ö¼´¿É

ѧϰ  ÎÒÒ²ÊÇÐÂÊÖ

Óõ¼Èëµ¼³ö ×ֶμǼ »á¶ªÊ§Âð

²»»á

ÎÒ½«accessµ¼ÈësqlserverÁË µ«²»ÖªµÀÊý¾Ý¿â·ÅÔÚÄÄ

ÓÃSQL SERVER ÖÐ×Ô´øµÄDTS (Êý¾Ýµ¼Èëµ¼³ö¹¤¾ß) °´²½Öè²Ù×÷¼´¿É,Ö÷ÒªÊÇÑ¡ÔñÒªµ¼ÈëµÄÊý¾ÝÔ´Óëµ¼³öµÄÊý¾ÝÔ´.......×ÔÒÑÊÔÊÔ.

ÊÔÊ ......

SqlserverÖеıí¸üв»ÁË

SqlserverÖеıí¸üв»ÁË£¬ÎÒÓÐÒ»¸öthreads±í£¬
ÀïÃæÓлظ´Êý£¬±êÌâʲôµÄÔÙ³ÌÐòÖÐ×ö£¬¸üÐÂ
²»ÁËÊý¾Ý¿â£¬ÔÚÊý¾Ý¿âÈËΪµÄ¿ÉÒÔ¸üС£
²»ÖªµÀʲôԭÒò£¬¸ú±íÖ®¼äµÄ¹ØϵÓйØÂð£¿
´óÏÀÃÇ£¬°ï°ïæ°¡£¿£¿£¿
¸Ð¾õ³ÌÐòû´íµÄ¡£

public int modifyThreads(Threads threads) {
int num=0;
String sql=" ......

php+sqlserver È¡¼Ç¼ʱµÃµ½idµÄÎÊÌ⣬ÔÚÏßµÈ

ÒÑÖª sql serverÖÐ
$server="se";
$username="us";
$password="pa";
$datebase="ds";

1 ÏÖҪȡsql serverÖÐ body ±í(×Ö¶ÎΪid, title) ÖеÄid£¬ÒªÒ»ÌõÒ»ÌõµÄÈ¡³öÀ´£¬²¢Êä³ö£¬
  ²¢ÔÙÊä³ö£º¡°Äã×îºóÈ¡µ½µÄÒ»Ìõ¼Ç¼µÄidÊÇ¡£¡£¡£¡±

  Ôõôʵ ......
×ܼǼÊý:322; ×ÜÒ³Êý:54; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [30] [31] [32] [33] 34 [35] [36] [37] [38] [39]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ