|
S**H
发帖数: 1256 | 2 set up a variable : currentFile ( string)
in the Execute SQL statement.
general
sourceType: Direct Input
SQL statement:
insert into dbo.logTable values
(@[User::CurrentFile],getdate(),getdate())
got error: the name is not permitted in this context. column name
not permitted.
Thanks a lot |
|
S**H
发帖数: 1256 | 3 Thanks!!!! It seems work now.
what I did
IN " Parameter Mapping"
new variable name: user::currentFile, ParameterName:0
type: varchar.
the sql code is like this now:
insert into dbo.logTable values
(?,getdate(),getdate())
*****************
Another Question:
If I have multiple varialbes needed to be passed.
How does the query know which ? is which ?
thanks !!!! |
|
B*****g
发帖数: 34098 | 4 google "bulk insert csv into sybase" |
|
n****e
发帖数: 1403 | 5 MySQL table either insert or drop/truncate table running forever ?
engine=innodb,
innodb_file_per_table
What is the possible reason?
Thanks |
|
n****e
发帖数: 1403 | 6 How to check lock-wait situation?
Even when I restart the linux server and restart the MySQL server and do
insert/truncate the same issue appear again,
Thanks |
|
n****e
发帖数: 1403 | 7 (1). In database A, table `client`
CREATE TABLE `client` (
`pin` INT(11) NOT NULL,
`create_user` INT(11) NULL DEFAULT NULL,
`update_user` INT(11) NULL DEFAULT NULL,
`update_time` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
`dob` DATE NULL DEFAULT NULL,
`create_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,
`dob_type` INT(11) NULL DEFAULT NULL,
`ethnicity_code` VARCHAR(10) NULL DEFAULT NULL,
`gender_code` VARCHAR(10) NULL ... 阅读全帖 |
|
I******0
发帖数: 182 | 8 题目是：Create a new appointment record in the ApptInfo table for a patient
that does not have an existing appointment.
我这样写的：
insert into ApptInfo(ApptNumber,apptdate,appttime,copay,ApptNotes,DoctorID)
VALUES (10006,01-04-2013,'09:30AM',$10,
select patientid from patient
where patientid not in(select patientid from ApptInfo)
我感觉问题是，倒数第二个select的结果不唯一，其结果有两个patientid
不知道要怎么改，谁能帮忙看看啊，晚上要交作业了，谢谢啊 |
|
|
w*****m
发帖数: 20421 | 10 insert targetTable
(col1, col2, patientID)
select
'1', '2' , patientID
from
patientTable |
|
O******t
发帖数: 214 | 11 改成这样就可以了：
insert into ApptInfo(ApptNumber,apptdate,appttime,copay,ApptNotes,DoctorID)
select 10006,01-04-2013,'09:30AM',$10,patientid from patient
where patientid not in(select patientid from ApptInfo) |
|
b***n
发帖数: 590 | 12 Do you know how to insert a Youtube video link into a blog hosted by the
blogspot(Blogger)? Thanks! |
|
c*****t
发帖数: 1879 | 13 In your case, writing your own scanner would be highest performance and
straight forward than ANY other method.
Just keep track the last line that does not have an empty line (thus
guarrantees the root tag is in this line) and dump the rest.
Then search for the (root = root tag name), and insert your
tag in front.
then
comments
tag |
|
e***e
发帖数: 168 | 14 can this be done for screen?
My enviroment is use screen to open many buffers. Then, I use sqlplus
command line to connect Oracle. The problem is I insert a text frequently
when I type Sql query. So, can this be done in screen too?
I know screen has a copy mode, that allow you to use vi to copy.
ctrl+a , [ will enter this copy mode. and press Esc to exit this mode.
Then, press ctrl+a, ] will past what you have copied in vi mode.
But I do not know if I can use screen to buffer some text, and then |
|
L*1
发帖数: 11537 | 15 Did I miss the point? It's so simple, you already got a short cut. I've been
using it for almost 20 years:
1. delete the text you want to paste (insert) using x or dd.
For example, if I move the cursor to "d" in "delete", 10x will delete "
delete the", dd will delete the whole line.
2. shift-p to paste it back. Move the cursor to anywhere and do as many
times as you want. |
|
d****n
发帖数: 130 | 16 /* Inserts the node pointed to by "newNode" into the subtree rooted at "tre
eNode" */
void InsertNode(Node *&treeNode, Node *newNode)
{
if (treeNode == NULL)
treeNode = newNode;
else if (newNode->key < treeNode->key)
InsertNode(treeNode->left, newNode);
else
InsertNode(treeNode->right, newNode);
}
The above "destructive" procedural variant modifies the tree in place. It us
es only constant space, but the previous version of the tree is lost.
我不懂为什么是destructive |
|
l*****d
发帖数: 359 | 17 "destructive" = previous version of the tree is lost
the code seems ok to me.
maybe if you give the other variant method of inserting nodes which is not "
in place", we will know what the author really means by "destructive" |
|
|
b***y
发帖数: 2799 | 19 you mean insert_iterator can't be used on vecters because inserting into a
vector always invalidated the iteraters after that position?
,
push_ |
|
o**f
发帖数: 76 | 20 I am taking a security class, there is a question
in our final project. I can't find any useful
information on this topic, could anyone
help me? Thanks!
The requirements are:
1. Insert a installation program with the attachement,
when the attachment is clicked, then the program will
be installed silently.
2. Do not show itself at the taskbar. |
|
g******o
发帖数: 208 | 21 学校里写ppt写一半, 回家发现电脑上没powerpoint,只有staroffice 8。
找了半天没发现怎么样insert text box, 请高手指点。 原来powerpoint里的text box
都显示正常, copy paste之后还好使，但怎么从菜单里开始建个新的？ |
|
T******s
发帖数: 24 | 22 I am trying to give a self-explained table. I usually give the desciption in
the capition but I cannnot insert an equation in the caption. Can anyone
help me to get around with this problem? Thank you so much ....
\begin{table}
\caption{
{\bf My title Risk} \\
my description comes here with a equation
\begin{equation}
Y= a + b X + e_t
\end{equation}
}
\input{h:/MATLAB/dynamic/d}
\end{table} |
|
p*********e
发帖数: 17 | 23 first, I fopen("filename", "r+b")
then , what I should do to insert a line somewhere? thanks a
lot! |
|
k*****u
发帖数: 1688 | 24 【 以下文字转载自 Linux 讨论区 】
发信人: killniu (killniu), 信区: Linux
标 题: how to insert a column for all slected rows in emacs
发信站: BBS 未名空间站 (Sat Jan 14 18:21:31 2012, 美东)
how to do this in emacs:
for example, the following code, how to comment out the line1 line2 line3
part.
That is, change
texttttttttt
tedtTTTTTTTTT
line1
line2
line3
textttttttttt
textttttttttt
to (add ## for each line)
texttttttttt
tedtTTTTTTTTT
##line1
##line2
##line3
textttttttttt
textttttttttt |
|
k*****u
发帖数: 1688 | 25 【 以下文字转载自 Linux 讨论区 】
发信人: killniu (killniu), 信区: Linux
标 题: how to insert a column for all slected rows in emacs
发信站: BBS 未名空间站 (Sat Jan 14 18:21:31 2012, 美东)
how to do this in emacs:
for example, the following code, how to comment out the line1 line2 line3
part.
That is, change
texttttttttt
tedtTTTTTTTTT
line1
line2
line3
textttttttttt
textttttttttt
to (add ## for each line)
texttttttttt
tedtTTTTTTTTT
##line1
##line2
##line3
textttttttttt
textttttttttt |
|
l****e
发帖数: 78 | 26 我需要把一些JPEG图片insert到一个word文档中,然后打印出来,但是发现图片都太暗了.
我现在想把那些图片的brightness调高一些,却又发现在WORD中只能一个一个的单独调(
用picture tool bar),太麻烦了,因为图片太多了.有没有办法可以选中所有图片一起调
?我试过用CTRL-A是不行的(没法调brightness)... |
|
c***u
发帖数: 730 | 27 【 以下文字转载自 Programming 讨论区 】
发信人: cungu (cungu), 信区: Programming
标 题: 问个简单的excel insert blank page的问题
发信站: BBS 未名空间站 (Thu Feb 19 09:24:06 2009)
一个spreadsheet,我需要把每个人单独打一页。而且每个人的row不同.
我现在用的方法是在每个人后面手动加上blank page.但是几百号人呢。。。
所以上来问问有没有其他简单的方法
|
|
a****o
发帖数: 79 | 28 page break view, 然后设定打印边界就可以了，比你INSERT空白页方便点，但也要花
点时间 |
|
h******g
发帖数: 1521 | 29 把vector给chop了，再收insert，我上次也是一不小心没注意，搞得那么相近，最后筛
选可苦了我，老有污染，最后实在受不了了，就直接pcr产物进终极vector。 |
|
h***l
发帖数: 168 | 30 我也在做这个，一个》10k的insert，做了两次还没拿到。。。
有没有什么建议？ |
|
s*******q
发帖数: 81 | 31 我一般都用4:1或6:1
除了vector SAP 去磷酸化，还可以对insert磷酸化以增强效率 |
|
s******y
发帖数: 28562 | 32 在我的理解中，多加PCR产物肯定是不会错的，因为多加了PCR产物，坏处最多就是
他们自己连接起来，但是反正他们不能在细菌里面扩增，奈何不了你。
但是多加了vector, 就会增加vector 自己链接的风险，增加产物的伪阳性比例
另外一点大家说得非常对，就是必须把insert磷酸化， vector去磷酸化 |
|
z*******o
发帖数: 1794 | 33 在单酶切，并且是vector不去磷酸化的情况下，多加PCR产物肯定没有问题。但这样的
条件谁也不会去做连接，vector自连的风险太高了，就算运气好进去了还有一个正反的
问题。如果是两个酶totally digested呢？原则上说vector将不会存在自我连接的风险
，同时这样的连接无论vector还是insert都是定向的高效连接。 |
|
A*******e
发帖数: 284 | 34 我也一直觉得自己没有真正搞清楚这个连接比例的问题，正常的情况下比较好做克隆也
就不顾这些了，但碰到一些极端情况，如极大或极小的insert，就觉得难了。假若我不
告诉你那个是载体，那个是片段，告诉你需要将两个DNA分子连接起来，该取什么样的
摩尔比。
单梅切若载体不去磷酸化，基本没有成功的可能。最好双酶切的策略。这种8kb的片段
比较大，很难克隆的。 另外我觉得产物纯度很重要，尤其是胶回收的产物，每次测得
时候总发现260/230的比例不够理想，所以觉得这种回收产物最好不要加太多到连接体
系里面。实际上我也发现胶回收的片段加多了就会连接不好 |
|
z*t
发帖数: 863 | 35 单酶切条件下insert磷酸化+vector去磷酸化能把自连降到多少？
现在想把一个cDNA subclone into another vector,但目的vector只有两个酶BamHI和
MluI可以切，并且BamHI还会在cDNA内部有一个切点。。。除了单酶切，我还有什么办
法么？ |
|
s********8
发帖数: 619 | 36 vector去磷酸的话,insert就必须要磷酸化了, 如果是PCR产物的话.这个我也是才搞明
白滴. |
|
n***w
发帖数: 2405 | 37
如果insert是sticky ends呢。 |
|
C*******e
发帖数: 4348 | 38 去磷酸化的vector加sticky ends的insert没问题
其实去不去磷酸化什么的都无所谓
我大多数情况下都不去
如果ligation的时候出问题多半不是去不去磷酸化什么的
多半是片段重新准备啊，浓一点，干净一点
多试几个ratio
vector多放点
就差不多了
vector去磷酸化不过是让自己放心
trouble shooting的时候可以排除掉一个vector自连而已 |
|
s******s
发帖数: 13035 | 39 有些软件是要model insert size的，很多indel caller是这样的，还有BWA.
如果不同的library混测，BWA可以align by read group, 没有问题，但是
indel caller会有问题，如果它们assume unimodal distribution的话。 |
|
c***y
发帖数: 615 | 40 多谢了！
对于需要model insert size 的aligner 只能做single-end read 处理了 |
|
M***D
发帖数: 478 | 41 have a svg file.
want to insert it to powerpoint 2013.
please help. |
|
O**M
发帖数: 29 | 42 how to insert a small icon (eps file) in the same line of the text using
Latex?
thanks |
|
l****n
发帖数: 723 | 43 和我最近一样啊， 换koni insert。 还好本人学工科的， 背靠一个大实验室，什么工
具都有。 只是可怜今晚我把pipe cutter 搞坏了，明天要去配刀片。 呵呵，美国，有
工具就好办。 |
|
w*******y
发帖数: 60932 | 44 I always love eBay when they do this because then I list everything I have
trouble selling and pay nothing when it doesn't sell.
Get free Insertion Fees for Auction-style listings--up to 50 items
BONUS OFFER: Add the Buy It Now option for free
|
|
g******y
发帖数: 2517 | 45 Milwaukee 48-32-1700 Insert Bit Screw Driving Set, 20-Piece, Only $7.77, Was
$11.60
http://amzn.to/zfz6MG |
|
w*******y
发帖数: 60932 | 46 Check your mailbox for this month's Coldwater Creek catalogue insert. $20
OFF your purchase of any amount! NO MINIMUM! online or in-store!
Promotion expires 2/20/12
If you don't currently subscribe, you can get it from Link:
http://www.coldwatercreek.com/Catalog/catalogRequest.aspx
|
|
g******y
发帖数: 2517 | 47 Wilson Jones Insertable Binder Tab Dividers, 8 Tab Multicolor, 原价$3.99, 现
价$1.29
http://amzn.to/H3MO0p |
|
D*******a
发帖数: 1723 | 48 http://www.sdjt.gov.cn/doc/%E6%95%8F%E6%84%9F%E5%AD%97.sql
insert into p_taboo (TID, TABOOWORD) values (12, 'K粉');
insert into p_taboo (TID, TABOOWORD) values (13, '冰毒');
insert into p_taboo (TID, TABOOWORD) values (14, '麻古');
insert into p_taboo (TID, TABOOWORD) values (15, '摇头丸');
insert into p_taboo (TID, TABOOWORD) values (16, '出售');
insert into p_taboo (TID, TABOOWORD) values (17, '配方');
insert into p_taboo (TID, TABOOWORD) values (18, '迷药');
insert into p_taboo (TID, TABOOWORD) values (19,... 阅读全帖 |
|
l*******u
发帖数: 1288 | 49 【 以下文字转载自 ChinaNews 讨论区 】
发信人: Dogerella (Cherry), 信区: ChinaNews
标 题: 看看党妈设定的敏感词
发信站: BBS 未名空间站 (Mon Jan 16 09:56:27 2012, 美东)
http://www.sdjt.gov.cn/doc/%E6%95%8F%E6%84%9F%E5%AD%97.sql
insert into p_taboo (TID, TABOOWORD) values (12, 'K粉');
insert into p_taboo (TID, TABOOWORD) values (13, '冰毒');
insert into p_taboo (TID, TABOOWORD) values (14, '麻古');
insert into p_taboo (TID, TABOOWORD) values (15, '摇头丸');
insert into p_taboo (TID, TABOOWORD) values (16, '出售');
insert into p_taboo (TID, TABOOW... 阅读全帖 |
|
D*******a
发帖数: 1723 | 50 【 以下文字转载自 ChinaNews 讨论区 】
发信人: Dogerella (Cherry), 信区: ChinaNews
标 题: 看看党妈设定的敏感词
发信站: BBS 未名空间站 (Mon Jan 16 09:56:27 2012, 美东)
http://www.sdjt.gov.cn/doc/%E6%95%8F%E6%84%9F%E5%AD%97.sql
insert into p_taboo (TID, TABOOWORD) values (12, 'K粉');
insert into p_taboo (TID, TABOOWORD) values (13, '冰毒');
insert into p_taboo (TID, TABOOWORD) values (14, '麻古');
insert into p_taboo (TID, TABOOWORD) values (15, '摇头丸');
insert into p_taboo (TID, TABOOWORD) values (16, '出售');
insert into p_taboo (TID, TABOOW... 阅读全帖 |
|
