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

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µ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»


ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡

¹Ø×¢¡«¡«

Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......

Çóc#²Ù×÷sqlserverÊý¾Ý¿âÎÊÌâ

ÔÚÊý¾Ý¿âÖÐÓÐÕÅ±í£¬ÓÐid,nameÁ½ÁУ¬id ÊÇÖ÷¼ü,ûÓÐÉèÖÃ×ÔÔöÊôÐÔ,ÔÚ³ÌÐòÖÐÈ¡³öÕâÕűí·ÅÈëdatatable£¬ÔÚÕâ¸ödatatableÖвåÈëÒ»Ìõ¼Ç¼£¬µ±¸üÐÂÊý¾Ý¿âʱÌáʾidÁв»ÄÜΪ¿Õ£¬ÇëÎʸÃÔõô½â¾ö£¿
¸øËüÒ»¸öÖµ£¡£¡Ö÷¼ü²»ÄÜΪ¿Õ ......

win7Éϰ²×°sqlserver - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÓÐÈËÊÔ¹ýÔÚwin7Éϰ²×°sqlserverÂð£¿
Ìý˵sql2000×°²»ÉÏÈ¥£¬²»ÖªµÀÆäËû°æ±¾Ðв»ÐС£

ºÃÏñ²»ÐÐ,²»¼æÈÝ,ÉÏ´ÎÒ²ÓÐÈËÎʹýѽ


ºÇºÇ£¬ÓÐÍøÓÑÓÐÏà¹ØµÄ¾­ÑéÂð£¿
Õâ¸ösqlserverÒª¾¡Á¿×°ÔÚwin7ÉÏ¡£

SQLSERVER 2000Ã ......

DelphiʹÓÃSQL ServerÈçºÎ¿ÉÒÔ²»°²×°SQLServer2000

ÈçÌâËùʾ
СµÜʹÓÃDelphi7»·¾³½øÐÐÊý¾Ý²É¼¯£¬²É¼¯µ½µÄÊý¾Ý·ÅÈëSQL Server2000Êý¾Ý¿âÖУ¬µ«ÊÇÏë²»°²×°SQLServer2000À´ÊµÏÖ´ÓÆäËü¼ÆËã»úÉÏÔËÐд˳ÌÐò£¬²»ÖªÈçºÎʵÏÖ£¿Íû¸÷λ´óϺ¸æÖªÒ»¶þ¡£
ÁíÍ⣬ÏÖÔÚСµÜÓöµ½ÁËÒ»¸ö ......

sqlserverÌí¼ÓÊý¾ÝµÄÎÊÌâ - Java / Java EE


ÒÔÏ´úÂëÊÇÌí¼ÓÊý¾Ý°´Å¥µÄ´úÂ룬Ïë°Ñtestid£¬ºÍtestnameÁ½¸ötxt´«µÝµ½Êý¾Ý¿âÖÐ
Êý¾Ý¿âÁ¬½Ó¿Ï¶¨Ã»ÎÊÌâ
¾ÍÊǺìÉ«²¿·ÖÀϱ¨´í
²»ÖªµÀΪʲô-£¬-
Çë¸÷λ¸ßÈ˰ïæ¿´¿´£¡
лл£¡
Java code:

private void new ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ