sqlserverÖÐתÒåµÄд·¨ÎÊÌâ
select * from export where Æ·ÅÆ is not null and ÎÄÕ±êÌâ like '%»¹ÒªÈ̶à¾Ã?·áÌïµÄ'ɲ³µ'Óë'»Ø¹é'%'
Õâ¾ä²éѯÓï¾äתÒåÔõôдѽ£¬Çë´ó¼Ò°ïÏÂæ£¬Ð»ÁË
SQL code:
select * from export where Æ·ÅÆ is not null
and ÎÄÕ±êÌâ like '%»¹ÒªÈ̶à¾Ã?·áÌïµÄ''ɲ³µ''Óë''»Ø¹é''%'
SQL code:
select * from export where Æ·ÅÆ is not null and ÎÄÕ±êÌâ like '%»¹ÒªÈ̶à¾Ã?·áÌïµÄ''ɲ³µ''Óë''»Ø¹é''%'
ÔÚ×Ö·û´®ÖÐ,Á½¸ö'µÈÓÚ³£¹æÏµÄÒ»¸ö'
SQL code:
create table #(code varchar(20),value int)
declare @sql varchar(200)
set @sql='insert into # select ''AAA'',10'
-- AAA֮ǰµÄÒ»¶Ôµ¥ÒýºÅÓëÖ®ºóµÄÒ»¶Ôµ¥ÒýºÅ·Ö±ð´ú±íÒ»¸öµ¥ÒýºÅ
print @sql --²é¿´Õâ¸ö×Ö·û´®µÄʵ¼ÊÄÚÈÝ
/*
insert into # select 'AAA',10
*/
exec(@sql)
select * from #
/*
code value
-------------------- -----------
AAA 10
*/
--Èç¹ûÐèÒªinsertÒ»¸öֵΪ'A''AA'µÄ×Ö·û´®£¬ÈçÏ£º
set @sql='insert into # select ''A''''AA'',10'
--Á½²ãǶÌ×µÄ×Ö·û´®ÄÚ²¿£¬Ò»¸öµ¥ÒýºÅÐèÒª¾¹ýÁ½´ÎתÒ壬ÓÚÊDZä³ÉÁË4¸öµ¥ÒýºÅ
print @sql --²é¿´Õâ¸ö×Ö·û´®µÄʵ¼ÊÄÚÈÝ
/*
insert into # select 'A''AA',10
*/
exec(@sql)
select * from #
/*
code
Ïà¹ØÎÊ´ð£º
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»
ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡
¹Ø×¢¡«¡«
Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......
ÔÚÊý¾Ý¿âÖÐÓÐÕÅ±í£¬ÓÐid,nameÁ½ÁУ¬id ÊÇÖ÷¼ü,ûÓÐÉèÖÃ×ÔÔöÊôÐÔ,ÔÚ³ÌÐòÖÐÈ¡³öÕâÕűí·ÅÈëdatatable£¬ÔÚÕâ¸ödatatableÖвåÈëÒ»Ìõ¼Ç¼£¬µ±¸üÐÂÊý¾Ý¿âʱÌáʾidÁв»ÄÜΪ¿Õ£¬ÇëÎʸÃÔõô½â¾ö£¿
¸øËüÒ»¸öÖµ£¡£¡Ö÷¼ü²»ÄÜΪ¿Õ ......
ÓÐÈËÊÔ¹ýÔÚwin7Éϰ²×°sqlserverÂð£¿
Ìý˵sql2000×°²»ÉÏÈ¥£¬²»ÖªµÀÆäËû°æ±¾Ðв»ÐС£
ºÃÏñ²»ÐÐ,²»¼æÈÝ,ÉÏ´ÎÒ²ÓÐÈËÎʹýѽ
ºÇºÇ£¬ÓÐÍøÓÑÓÐÏà¹ØµÄ¾ÑéÂð£¿
Õâ¸ösqlserverÒª¾¡Á¿×°ÔÚwin7ÉÏ¡£
SQLSERVER 2000Ã ......
ÈçÌâËùʾ
СµÜʹÓÃDelphi7»·¾³½øÐÐÊý¾Ý²É¼¯£¬²É¼¯µ½µÄÊý¾Ý·ÅÈëSQL Server2000Êý¾Ý¿âÖУ¬µ«ÊÇÏë²»°²×°SQLServer2000À´ÊµÏÖ´ÓÆäËü¼ÆËã»úÉÏÔËÐд˳ÌÐò£¬²»ÖªÈçºÎʵÏÖ£¿Íû¸÷λ´óϺ¸æÖªÒ»¶þ¡£
ÁíÍ⣬ÏÖÔÚСµÜÓöµ½ÁËÒ»¸ö ......
ÒÔÏ´úÂëÊÇÌí¼ÓÊý¾Ý°´Å¥µÄ´úÂ룬Ïë°Ñtestid£¬ºÍtestnameÁ½¸ötxt´«µÝµ½Êý¾Ý¿âÖÐ
Êý¾Ý¿âÁ¬½Ó¿Ï¶¨Ã»ÎÊÌâ
¾ÍÊǺìÉ«²¿·ÖÀϱ¨´í
²»ÖªµÀΪʲô-£¬-
Çë¸÷λ¸ßÈ˰ïæ¿´¿´£¡
лл£¡
Java code:
private void new ......