r********g
发帖数: 43 | 1 快冬天了，想说把壁炉改装下，加个烧木头的fireplace insert，效率高点。
homedepot看见了一个，无奈那东西300多磅，而且还要弄烟囱，自己搞不定，有没有认
识的装修师傅，或者contactor能装的？顺便清理下烟囱。 我在salem NH。
多谢多谢 |
|
x******e
发帖数: 1428 | 2 哦 谢谢 其实只要有smartsource的coupon的insert都行 像我知道的有houston
chronicle 你有吗？ |
|
j****3
发帖数: 682 | 3 只知道Ugly stik big water和daiwa mad dragon. 最好guides没有inserts, 怕了。 |
|
k***z
发帖数: 4718 | 4 insert键是啥键？我原来用PC时也没印象啊。MB上的键盘命令很多都可以用快捷键实现
，再加上expose,用习惯了再用XP有时急得都想骂人，太麻烦了 |
|
c**e
发帖数: 3760 | 5 the key that switch input between insert and overwrite.
windows的快捷键也很多啊。mac的我还不知道。
你有啥mac专有的快捷键？我学学。 |
|
c**e
发帖数: 3760 | 6 yeah. I googled and learned that. but seems there's no
replacement for the insert key. |
|
|
s******r
发帖数: 4 | 8 What is the problem below? how to solve it ?
" Error reading Re1.Lines.strings: Richedit line insertion erro. "
Thanx |
|
p****8
发帖数: 4158 | 9 就想把给今年准备的木头烧掉，免得占地方，另一方面是壁炉太强大了，烧烧停停，还
是那么热，而且木头只用掉以前没有insert时候的1/4或1/3。
强力推荐！ |
|
b*s
发帖数: 82482 | 10 Question: I plugged in the SuperDiskUSB drive, but I don誸 see an icon on
the desktop.
Answer: If no desktop icon displays after you insert a diskette in the
drive, complete the following checks:
* Make sure you have a diskette in the SuperDisk drive.
* Make sure all cables are securely connected.
* Make sure the computer and drive have power.
* Make sure you are using the cables that came with the drive.
* If it still doesn誸 work, eject the disk using the button on |
|
a****0
发帖数: 548 | 11 iphone 3g, 不知道解锁没有。试了att的sim 卡，有信号；试Tmobile的sim 卡，没有
信号。
于是就断定手机没有解锁（现在回想来，应该是已经解锁了）。
于是网上google解锁方法。ehow上的一个帖子似乎很可靠。于是在没有搞清楚所用iOS
版本和基带的情况下，先用4.2.1的firmware restore (脑残啊！），然后用RedSn0w
jailbreak. 在jailbreak时，当然4.2.1的firmware不work.然后又google，下载了
custom 3.0 firmware去jailbreak。操作过程中间手机似乎正常（比如，手机上显示
jailbreaking...),但没有出现有俩个动物的画面。
jailbreak完后，朋友直接把iphone unconnect from PC, 没有进行最后一步操作：Add
the source - repo666.ultrasn0w.com 和Install UltraSn0w。
然后手机始终显示：insert a valid sim with no pin lock to activate iph... 阅读全帖 |
|
a****0
发帖数: 548 | 12 但是现在手机一直处于emergency 状态：insert a valid sim with no pin。。。我怎
么找到基带信息呢？
还有一个问题：如果这个手机在最初是已经被解锁了的，经过上面这番脑残操作以后，
如果我能restore到出厂状态的话，手机是不是还是解锁得？
现在最最重要的是：restore到出厂状态！这样手机至少还能用。
多谢！ |
|
a****0
发帖数: 548 | 13 成功restore了，手机还是在emergency 状态：insert a valid sim with no pin。。
。依旧不能用。急啊！！！ |
|
a****0
发帖数: 548 | 14 还有，在手机处在emergency 状态：insert a valid sim with no pin。。。 时，如
何检查手机的iOS版本和基带的情况？？？
这儿有没有人愿意帮忙，有没有高手阿？ |
|
b****o
发帖数: 387 | 15 I tried almost a whole night, and could not figure out how to make "shift+
insert" cmd --- a standard copy paste function for Linux!
Is Mac crazy or I am crazy? |
|
L*********s
发帖数: 3063 | 16 insert, pagedown, end键在哪里？我连了远程桌面，但这些键没有 |
|
g*******n
发帖数: 2198 | 17 WD的移动硬盘显示 the disk you inserted was not readable by this computer
狗了下有说是wd和apple软件上的问题
以前用都好好的 突然今天开始这样
有没谁也遇到过这个问题 |
|
f*******h
发帖数: 1269 | 18 I define image fields in a table, how can use SQL to insert image files
into the image fields? (SQL Server and DB2))
Thanks a lot! |
|
N**e
发帖数: 158 | 19 Can't use Insert Into (...) Values ('','','')
Since the string contains '
What to do? Thanks |
|
a****s
发帖数: 47 | 20 NOt sure. But you can try use Insert Into (...) Values (" "," "," ").
Another way is to escape ' using \ |
|
s***l
发帖数: 9 | 21
I am not clear to ACCESS. But in SQL SERVER 7.0, you can
simply omit the field when inserting new values. |
|
s***t
发帖数: 7 | 22 4' is one '
insert into table_a
values
('aaa''''bbb'); |
|
f*******h
发帖数: 1269 | 23 When I:
INSERT INTO mytable(name, desc) VALUES('Test Name', 'It's a good test')
this will cause problem, because ' after It.
How could I do? |
|
p*****e
发帖数: 58 | 24
INSERT INTO mytable(name, desc) VALUES('Test Name', 'It''s a
good test')
use '' (two single quote) for '. SQL uses ' as the escape
charactor like the \ in C/C++, or " in VB. |
|
s******i
发帖数: 1 | 25 dear all :
How to insert image in a table of DB2 ?
please tall me,thank you !! |
|
f*******h
发帖数: 1269 | 26 An example in Java:
Suppose you have a table (id varchar, image blob)
public static void loadImage(Connection con, String fileName, String
tableName, String idValue){
File imageFile;
try{
imageFile = new File(fileName);
} catch (Exception e) {
System.out.println("File not found!");
return;
}
String queryString = "INSERT INTO "+tableName+" VALUES(?,?)";
try{
PreparedStatement pstmt = |
|
z*q
发帖数: 29 | 27 Hi,
Anybody know how to get Identity (MS-SQL) after the
"insert"? I mean get the Identity column value without using
another retrieve ("select"). And in some case, the addition
select can't work before the Identity is the ONLY primary
key. I know in PowerBuilder, there is some way to do that.
But I don't know how to do it in JDBC.
Thanks a lot. |
|
q***e
发帖数: 21 | 28 According to my experience in DB2 and Informix, batch insert
commit(usually about thousands of record) is faster than
single record or less than one hundred record commit. I
think in Oracle it should work too. Also, in oracle, there
should have some parameters to be adjusted for performance.
You can ask some oracle experts. |
|
v********e
发帖数: 1985 | 29 How do i insert text(CLOB) into informix database using perl dbi:informix? I
have no trouble using mysql, but i am required to migrate to informix now.
many thanks in advance
ice |
|
f***g
发帖数: 10 | 30
Hope this query can work for the case:
INSERT INTO Queue (ID) SELECT @input_ID WHERE NOT EXISTS(SELECT * FROM Queue WHERE ID = @input_ID) |
|
c***y
发帖数: 114 | 31 ft, it's either
insert into table(col) values(value)
or update table set col = value
ur sql is wrong |
|
aw
发帖数: 127 | 32 FT，你INSERT到2个COLUMN，INQLast_Name,INQEmail，怎么用一个值'$lname,$lname'？(
应该是‘$lname’,‘$lname')
new |
|
c*****d
发帖数: 6045 | 33 大数据量的时候用truncate+insert比Update快
陈述一个事实,哈哈 |
|
n****u
发帖数: 229 | 34 I agree.
Last time it would took 3 days to update 320,000 records (just update MSN
etc.)
But I truncated table first, INSERT... SELECT..., 30 seconds, done. |
|
t*********i
发帖数: 217 | 35 I am curious...can you give a example (or document) that a update would be
more expensive than a delete+insert.
I kind of think all relational DBs have similar structures... |
|
t*********i
发帖数: 217 | 36 I don't know much about Sql server, here is what I found:
http://www.windowsitlibrary.com/Content/77/21/1.html
A direct, same-page Update occurs when a record is deleted from a page and
inserted onto that same page, usually because of increasing row length.
Because the record does not move to a new page, none of the indexes needs to
be updated, unless, of course, an indexed field is updated. This type of
Update gets two records, an op code of 5 (Delete), followed by an op code of
6 (Indirect Ins |
|
m*****8
发帖数: 292 | 37 in MS SQL,internally, an update = delete + insert
so u figure the rest. |
|
x***e
发帖数: 2449 | 38 I do not know about that.
I only know it is case by case.
And I am not work for MS either....
I can not image in the following case the update >= insert + delete
in any of the SQL env.
you have a table
Id1, id2, text
while ID1 is unique index, id2 is an int none indexed column and text is a
text column.
and you want to update the id2 column....based on id1....
to
of |
|
a******8
发帖数: 46 | 39 For this case, I will first check if (kb,kc) exist before insert it into db. |
|
c*******e
发帖数: 8624 | 40 脑筋太死了,你先insert,然后再处理不行吗
或者干脆直接就是set table |
|
n********6
发帖数: 1511 | 41 还可以先load to temptable, 处理好以后，再insert.这样对production table影响小。 |
|
B*****g
发帖数: 34098 | 42 can this syntax ignore the duplicate without insert a diff value. |
|
a****x
发帖数: 231 | 43 如果用A+B作primary key的话,可以考虑用
Insert ignore into
或者
Replace into |
|
t*****s
发帖数: 124 | 44 haha, your guess is incorrect
only update, no insert |
|
l*****b
发帖数: 82 | 45 Hi, friends,
I have existed DB with Identity (1,1) primary key columns and it has huge
data. Now I have to insert non-auto-increment value in this primary key. Do
you have any idea on this? |
|
a9
发帖数: 21638 | 46 对，就是那个。我没在生产上用过，不知道。我就是在dts里用。
我也不知道手工insert以后，再自动的时候identity是几，呵呵。 |
|
D*********l
发帖数: 493 | 47 我回答的是:
1. Drop Indexes and Contraints.
2. Drop all insert Triggers.
3. Disable Log
4. Use Hint Append.(without check spaces)
5. Partition/parallelism.
请问各位大虾,还有没有更好或者其它的办法. |
|
y****w
发帖数: 3747 | 48 no. sql server doesn't.
I guess the interviewer just feels interested in: a) batch insert b) load
utility. others are more specific, the more you can point out, the better. |
|
g***l
发帖数: 18555 | 49 大数据量LOAD OLAP SQL SERVER可以考虑FAST TABLE LOAD或者BCP
OLTP环境，BATCH数据要切成小块，.NET的ENTITY INSERT要比SQL块 |
|
