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
Ïà¹ØÎÊ´ð£º
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......
PB10¡¢PB11Á¬½ÓSQLServer¹Ø¼ü×Ö: pb10¡¢pb11Á¬½Ósqlserver (×ªÔØ)
PB10¡¢PB11Á¬½ÓSQLServer (×ªÔØ)
2007-11-02 22:27
´ÓPB10¿ªÊ¼£¬Ã»ÓÐÁËmssql serverרÓýӿÚÁË£¬ÁíÒ»·½ÃæÊý¾Ý¿â¹ÜÀíϵͳ(DBMS)
»»³ÉÁË ......
ÓÐÈËÊÔ¹ýÔÚwin7Éϰ²×°sqlserverÂð£¿
Ìý˵sql2000×°²»ÉÏÈ¥£¬²»ÖªµÀÆäËû°æ±¾Ðв»ÐС£
ºÃÏñ²»ÐÐ,²»¼æÈÝ,ÉÏ´ÎÒ²ÓÐÈËÎʹýѽ
ºÇºÇ£¬ÓÐÍøÓÑÓÐÏà¹ØµÄ¾ÑéÂð£¿
Õâ¸ösqlserverÒª¾¡Á¿×°ÔÚwin7ÉÏ¡£
SQLSERVER 2000Ã ......
ÒÔÏ´úÂëÊÇÌí¼ÓÊý¾Ý°´Å¥µÄ´úÂ룬Ïë°Ñtestid£¬ºÍtestnameÁ½¸ötxt´«µÝµ½Êý¾Ý¿âÖÐ
Êý¾Ý¿âÁ¬½Ó¿Ï¶¨Ã»ÎÊÌâ
¾ÍÊǺìÉ«²¿·ÖÀϱ¨´í
²»ÖªµÀΪʲô-£¬-
Çë¸÷λ¸ßÈ˰ïæ¿´¿´£¡
лл£¡
Java code:
private void new ......
ÎÒÔÚ±¾µØÓÃMicrsosoft sql server managementÁ¬½Ó·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÎÒÏë°Ñ·þÎñÆ÷ÉϵÄÊý¾Ý¿â ±¸·Ýµ½ÎÒ±¾µØ¡£¿ÉÒÔÔõôҲ²»³É¹¦¡£
µÚÒ»ÖÖ·½·¨ÊÇÓÃsql£º
Backup Database test_database
To disk='C:\test_database ......