ÎÒ¿´Á˺ܶàÎÄÕ£¬Ð´µÄ̫רҵ£¬Äܲ»ÄÜÓôó°×»°½²½²£¬¾ÍÊÇÔõô¹¹½¨Ë÷ÒýµÄ£¬²éµÄʱºòÊÇÔõôÑùµÄ²½Ö裬Ϊʲô±Èlike¿ì£¬ÊDz»ÊÇÖ»ÒªÓÃcontect£¬¾ÍÒ»¶¨»áÈ¥²é£¬±ÈÈç
select * from table where contect('sdfsd',sdf) and id=5
idÊÇÖ÷¼ü£¬Õâʱ»áÈ¥²éÈ«ÎÄË÷ÒýÂð£¿ÎªÊ²Ã´£¿
¾¡Á¿Óôó°×»°½²£¬Õ³ÌùרҵÎÄ×Ö¾ÍËãÁË
ÎÊÌâ²¹³ä£ººÃ°É£ ......
ÏÖÔÚÓöµ½µÄÎÊÌ⣺
¶ÁÈ¡±¾µØÒÑÓеÄdbfÊý¾Ý¿â,дÈëµ½SQLSERVER2000ÖУ¬µ«ÊÇ¿´ÊéºÍÍøÉÏÈ«ÊÇÏîÄ¿×Ô´øÊý¾Ý¿âµÄ¶Áд£¨¼´°ó¶¨Êý¾ÝÔ´£©¡£
ÒÑÖªµÀdbfµÄ·¾¶£¬µ«ÊÇÁ¬½ÓµÄ×Ö·û´®ºÍÊý¾Ý¶ÁÈ¡µÄ²Ù×÷Ôõôд£¿
ÈçºÎÁ¬½ÓSQLServer2000,²¢µ÷ÓÃÆä´æ´¢¹ý³Ì£¿
ÎÒÏëÖªµÀͨ¹ýsqlÓï¾äÈçºÎ¶Á£¬ÈçºÎд.
ÏÈлл¸÷λµÄ½â´ð¡£
connDbf = ......
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µ¼ÈësqlserverÁË µ«²»ÖªµÀÊý¾Ý¿â·ÅÔÚÄÄ
ÓÃSQL SERVER ÖÐ×Ô´øµÄDTS (Êý¾Ýµ¼Èëµ¼³ö¹¤¾ß) °´²½Öè²Ù×÷¼´¿É,Ö÷ÒªÊÇÑ¡ÔñÒªµ¼ÈëµÄÊý¾ÝÔ´Óëµ¼³öµÄÊý¾ÝÔ´.......×ÔÒÑÊÔÊÔ.
ÊÔÊ ......
SqlserverÖеıí¸üв»ÁË£¬ÎÒÓÐÒ»¸öthreads±í£¬
ÀïÃæÓлظ´Êý£¬±êÌâʲôµÄÔÙ³ÌÐòÖÐ×ö£¬¸üÐÂ
²»ÁËÊý¾Ý¿â£¬ÔÚÊý¾Ý¿âÈËΪµÄ¿ÉÒÔ¸üС£
²»ÖªµÀʲôÔÒò£¬¸ú±íÖ®¼äµÄ¹ØϵÓйØÂð£¿
´óÏÀÃÇ£¬°ï°ïæ°¡£¿£¿£¿
¸Ð¾õ³ÌÐòû´íµÄ¡£
public int modifyThreads(Threads threads) {
int num=0;
String sql=" ......
ÒÑÖª sql serverÖÐ
$server="se";
$username="us";
$password="pa";
$datebase="ds";
1 ÏÖҪȡsql serverÖÐ body ±í(×Ö¶ÎΪid, title) ÖеÄid£¬ÒªÒ»ÌõÒ»ÌõµÄÈ¡³öÀ´£¬²¢Êä³ö£¬
²¢ÔÙÊä³ö£º¡°Äã×îºóÈ¡µ½µÄÒ»Ìõ¼Ç¼µÄidÊÇ¡£¡£¡£¡±
Ôõôʵ ......