Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎÊ´ð£º

java³ÌÐòÁ¬½ÓSQlServerµÄÎÊÌâ - Java / Java SE

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 (×ªÔØ)
PB10¡¢PB11Á¬½ÓSQLServer (×ªÔØ)
2007-11-02 22:27
´ÓPB10¿ªÊ¼£¬Ã»ÓÐÁËmssql serverרÓýӿÚÁË£¬ÁíÒ»·½ÃæÊý¾Ý¿â¹ÜÀíϵͳ(DBMS)
»»³ÉÁË ......

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

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

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


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

SQLSERVER 2000Ã ......

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


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

private void new ......

sqlserver Êý¾Ý¿â±¸·ÝÎÊÌâ

ÎÒÔÚ±¾µØÓÃMicrsosoft sql server managementÁ¬½Ó·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÎÒÏë°Ñ·þÎñÆ÷ÉϵÄÊý¾Ý¿â ±¸·Ýµ½ÎÒ±¾µØ¡£¿ÉÒÔÔõôҲ²»³É¹¦¡£
µÚÒ»ÖÖ·½·¨ÊÇÓÃsql£º
Backup Database test_database
To disk='C:\test_database ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ