由买买提看人间百态

topics

全部话题 - 话题: trigger
首页 上页 1 2 3 4 5 6 7 8 9 10 下页 末页 (共10页)
s**********o
发帖数: 14359
1
来自主题: Database版 - how to write this trigger
假设UPDATE QTY触发CHECK QTY和SEND EMAIL
create TRIGGER SendEmailCheckQtyAfterUpdate
ON Table
AFTER UPDATE
AS
IF ( UPDATE (Quantity) )
BEGIN
if (select top quantity from table where productname= product)< 5
begin
send email
end
END
c*****d
发帖数: 6045
2
你把问题说复杂了,这件事和AddLineItemSP没太大关系
就是insert trigger的问题
不要用SELECT NVL(MAX(detail), 0) + 1
如果你没锁表,两个用户同时插入数据,你这个是有问题的
改用sequence
B*****g
发帖数: 34098
c*****d
发帖数: 6045
4
以上是思路,这个是答案(如果必须用max+1)
create table emp (id number, name varchar2(20));
insert into emp values(1,'coolbid');
commit;
create or replace trigger trg_bir_emp
before insert on emp
referencing new as new old as old
for each row
begin
select max(id)+1 into :new.id from emp;
end;
/
insert into emp (name) values('beijing');
commit;
c*****d
发帖数: 6045
5
更好的方法是用sequence
create sequence seq_emp_id start with 3 incrmented by 1;
create or replace trigger trg_bir_emp
before insert on emp
referencing new as new old as old
for each row
begin
select seq_emp_id.nextval into :new.id from dual;
end;
/
insert into emp (name) values('id not provided');
insert into emp (name) values(100,'id provided');
select * from emp;
B*****g
发帖数: 34098
6
你这样教我觉得不行,lz的问题是一口想把2个问题都解决,这样容易乱。
很显然问题应该分几步走:
1 写一个trigger,insert时自动加一个固定值(比如说1)
2 在1的基础上把那个固定值换成变量
新手写程序切记不要想一次把功能都写出来,要迭代式的开发
B*****g
发帖数: 34098
7
你的知识该更新了,三天不学习,赶不上刘少奇
http://dev.mysql.com/doc/refman/5.0/en/create-trigger.html
n****e
发帖数: 1403
8
偶试过prepared statement了。 trigger滴不行啊!
c*****d
发帖数: 6045
9
yhangw的意思是用sql语句生成创建trigger的语句
和bejing的意思一样
s**********o
发帖数: 14359
10
这个TRIGGER更新的数据太多了,不能用的,可以搞个USER DEFINED FUNCTION,把
TIMESTAMP储存在那,就一个RECORD么,干嘛没事了去TABLE上UPDATE
y****w
发帖数: 3747
11
lz要的就是这个新column。他那些triggers就是用来更新这一列的。
L*********i
发帖数: 649
12
我想CREATE TRIGGER,
见附图,
但总有问题,见MSG,不懂,诚心请教。
w*r
发帖数: 2421
13
告诉老师trigger现在没人用了,不要教了
c*****d
发帖数: 6045
14
为啥?我们还在用trigger
L*********i
发帖数: 649
15
老师是韩国女人,
应该还是有水平的,
就是“概括”能力不太好;讲课能力急待提高;
我们上课一直用ms sql server,可讲到trigger, 她上课给的零散的例子都是oracle 的,
这也就罢了;
关键是讲的几个例子相互毫无关系,大家听的都云里雾里。
我觉得我虽然只是初学者,水平很低,可是我也给班上的同学讲老师出的题,我自己懂
了,我一边在 ms sql server 上演示,一边讲,这样效果就很好呀,不会的同学很快
就明白了。
光听懂老师上课讲的内容是无法完成她布置的作业的,这样也好,很多东西还是要靠自
己多看,多问,多请教,多练习;
我特别喜欢 上学期的那个教 data structure & algorithm 的老师,讲课逻辑极其清
楚,他一边上机演示,一边教学,和学生的互动也很好。据说是我们这个一般学校学生
评价最好的一个cs 老师。
c*****d
发帖数: 6045
16
如果能确保所有修改都通过前台程序,trigger确实没啥用
可是无法保证所有修改都通过前台程序
y****w
发帖数: 3747
17
要后台更新啥,你会更不愿意面对一堆trigger。
g****y
发帖数: 436
18
来自主题: Linux版 - help on SCIM trigger
hi, I finished installing ubuntu and found the scim panel under System->
Preferences .But I can not trigger on SCIM no matter what I type.
Can anyone help me out?
n******r
发帖数: 718
19
来自主题: Linux版 - help on SCIM trigger
BTW, default trigger for my SCIM is CTRL + Space. Does it matter? I doubt
it, but you could try.
c***n
发帖数: 408
20
For example, we have a pdf file, which has different text. ABC, CDE, XYZ.
etc. These texts don't have hyperlink, just plain text.
Now we want to trigger an event when clicking on the text XYZ. Can we do
that? thanks
g*****g
发帖数: 34805
21
I don't know how to trigger an event on pdf text, you probably need to go
through low level mouse event and try to match the cursor position. For text
in Swing, it's much simpler, you can listen on the Swing text component.
t**********g
发帖数: 3388
22
只有chorme有这个问题。自动trigger acdsee 打开该图片。怎么回事?重装acdsee和
杀毒都不管用
n***s
发帖数: 287
23
如果你说的是experimental particle physics, trigger is:
a selection process based on signals collected by the very front end
electronics, generally the selection is a pure hardware process at L1
and L2 and software process at Level 3.
n***s
发帖数: 287
24
Yes, high frequency of beam crossings (actually bunch crossings)
makes it impossible to record all events happened there, so people
have to select and record only those events that have interesting
signature. Basically I said "selection" while you said "filter", that's
the same thing I think.
I am not sure "早期的计算机水平比较低" refers to when? but at
the moment FermiLab is still using L1/L2/L3 trigger system. Sure,
LHC and CMS are more advanced.
The fact that there is no good text book for detector/trig
d*b
发帖数: 21830
25
Tevatron设计的时候,100兆的网络还只在纸上,所以传输detecotor 模数转换后出来
的数字信号用的还是10M的网络。
10M的网络是8芯双交线,但实际使用的只有2对,一对收,一对发。
90年代后期tevatron做upgrade的时候,数据传输改用Cypress的hotlink,hotlink的速
度可以达到150M,用的还是普通的网线,但是2对收2对发,这个设计思想跟现在的千兆
网差不多。但速度比千兆网要慢多了--那时候也没什么千兆网。 早期L2的trigger用
DEC的Alpha CPU,有点计算机常识的都知道Alpha是跟486一代的爷爷级的CPU了,这样
的技术条件下,数据的3级处理是非常必要的。
LHC的detector因为比较大,模拟信号必须在当地转换成数字信号后再发回来,这个转
换后的信号是通过光缆传出来,频率比当年的hotlink高无数倍,当然,频率一高,你
就得考虑光信号传输的delay。
计算机条件也大不相同。我这是从一个角度说明技术进步对detector设计的影响。
n***s
发帖数: 287
26
老大, 您不用写这么大一堆我也知道您懂这一块.
要不是以detector硬件为职业, 用的着知道这么多吗! 一般phd, postdoc
撑司死测量个trigger efficiency发个note而已, 主要这东西不是物理所
以不能作为论文topic, 所以一般学生就是直接用用结果.
LZ就是问个概念, 别吓着人家.
d*b
发帖数: 21830
27
这东西怎么不是物理?Nuclear Inst上面文献一大堆,你的phd thesis要是做了这玩意
那可牛大了,全美国懂trigger R&D的加起来也就一手。你知道calinornia到那些做VME
board的公司有多赚钱么?
t*******n
发帖数: 55
28
不晓得如何算作懂得 trigger R&D?
请指教
g****g
发帖数: 1828
29
inspired by hep triggers. usually there are 3 levels. how about brain? just
one level? there is surely dead time!
t*******e
发帖数: 912
30
呵呵,有五个正常的我就很满意了!毕竟不是二十多岁的时候,想要二十多个卵泡的愿
望是太渺茫了。多谢这里的JM了,在这里说话心理很舒服,有时候家里人都没法安慰的
,这里JM几句话就使心里服帖。今晚就要打trigger Ovidel了,明天没事儿。希望小个
的卵泡悄悄跟上来,多点机会。这次STIM还算顺利,之前护士警告说荷尔蒙注射期间会
有情绪变化,可我不觉得呀。晚上睡得死沉死沉的,越到后来越是这样。除了小腹涨涨
的,breasts变大了些,呵呵,其他没什么。
25mm的卵泡?哇,好大,说不定有好几个卵子在里面!
b*******3
发帖数: 386
31
来自主题: _IVF版 - TRIGGER的时机
我星期六作 ultrasound 至少有三个大约21,22,还有一些小的,星期天 trigger,星
期二 ET,结果只取了三个,肯定晚了。
j****q
发帖数: 21
32
谁知道打trigger shot那天,Progesterone, Estradiol, LH三项指标的正常值应该是多
少?
s******e
发帖数: 364
33
I only know about E2. Normally with one egg, your E2 should be around 200.
As long as your E2 is >200, that means at least one egg is mature, it's okay
to trigger. Of course, if your E2 is 400, two eggs will make better chance.
w*******y
发帖数: 60932
34
Amazon's got a few very good DS rpgs on sale today.
Link:
http://www.amazon.com/gp/feature.html/ref=amb_link_85826191_2?ie=UTF8&docId=1000208101&pf_rd_m=ATVPDKIKX0DER&pf_rd_s=right-1&pf_rd_r=07F34VVABQ2NPGHKBC44&pf_rd_t=101&pf_rd_p=496383051&pf_rd_i=409566
The World Ends With You - $14.99
Chrono Trigger - $14.99
Kingdom Hearts 358/2 Days - $17.99
Shipping is free with Prime, other wise you can use goodfillers to get to $
25 to make it free:
http://www3.
w*******y
发帖数: 60932
35
Craftsman 10 Pattern Front Trigger Nozzle:
http://www.sears.com/shc/s/p_10153_12605_07169153000P
$4.99 - pick up in store for free
Discount will show in cart
A new and innovative diaphragm-activated push button ON/OFF. No more need
for constant hand activation - superior ergonomics and hand stress relief.
Flow control for easy and convenient control of water flow. GRIPGUARD
insulated rubber coating protects hands from cold water.
w*******y
发帖数: 60932
w*******y
发帖数: 60932
w*******y
发帖数: 60932
38
For those of you that missed this a few days ago, here it is again.
Subscribe and Save $4.64
Link:
http://www.amazon.com/Shout-Trigger-22-Ounce-Pack-3/dp/B0049T2S
w*******y
发帖数: 60932
39
Newegg has the Nokia Wireless Observation Camera for MMS (Text) Enabled
Phones With Motion Detection Triggered Alerts for $14.99 shipped
LInk:
http://www.newegg.com/Product/Product.aspx?Item=9SIA0MC06T0471
Part of the BF deals... some sites still has this for $400! technology from
a few years back..
Features:
oMonitor remote business or personal assets almost anywhere in the GSM
coverage area
oGSM/GPRS 800/1900
oFeatures motion-detection and temperature-alert functions
oInfrared light source cap... 阅读全帖
w*******y
发帖数: 60932
40
Amazon Lysol 75352 32 Oz. Lemon Breeze All Purpose Cleaner with Trigger (
Case of 12) $4.49 + $4.59 shipping
w*******y
发帖数: 60932
41
Skylanders Legendary Trigger Happy is in stock available for shipping and
possibly store pick up. I know it is regular price $9.99 plus shipping, but
many don't have a TRU around and this is the only place besides Ebay to find
it. Hope it helps someone,
Link:
http://www.toysrus.com/product/index.jsp?productId=12722123
c******n
发帖数: 4965
42
我的zorki 土得很,没有自拍trigger,
其实接cable release 的口应该可以连个这种东西。
i***e
发帖数: 373
43
来自主题: GunsAndGears版 - 2nd best to H&K P30?
A good link on HK P2000 V3 vs V2: http://www.calguns.net/calgunforum/showthread.php?t=132246
The best part of it copied here:
I have a P2000SK .40 LEM. The trigger pull is the SAME for each round. You
carry it with a round in the chamber, no safety lever, ready to fire with a
pull of the trigger. The trigger pull is "longish" but that in itself is the
safety mechanism. The reset is relatively short.
I thought the 8# standard LEM trigger too heavy so I swapped out two springs
(less than $10) to m... 阅读全帖
f**d
发帖数: 768
44
来自主题: Neuroscience版 - eBook: From computer to brain
这是一本计算神经科学的优秀著作,全文拷贝这里(图和公式缺),有兴趣的同学可以
阅读
如需要,我可以分享PDF文件(--仅供个人学习,无商业用途)
From Computer to Brain
William W. Lytton
From Computer to Brain
Foundations of Computational Neuroscience
Springer
William W. Lytton, M.D.
Associate Professor, State University of New York, Downstato, Brooklyn, NY
Visiting Associate Professor, University of Wisconsin, Madison
Visiting Associate Professor, Polytechnic University, Brooklyn, NY
Staff Neurologist., Kings County Hospital, Brooklyn, NY
In From Computer to Brain: ... 阅读全帖
d**********g
发帖数: 2014
45
这个网站挺好的。
http://www.best9mm.com/compact9mm.html
我感觉先从轻的开始挑。
Compact 9mm Pistols for Concealed Carry
We didn't do a "best list" because your personal requirements for a
concealed carry pistol will not always be the same as ours.
The rules for the 9mm CCW list: Weigh 30 ounces or less, barrel 4.1 inches
or shorter, and cost less than $600 from a dealer. Most confrontations will
be at 7 yards or less, so any choice you make from the below list should be
good for concealed carry. Some of these compa... 阅读全帖
l****z
发帖数: 29846
46
by Bruce N. Eimer, Ph.D
The question is often asked, “what is the best handgun for concealed carry?
” There are many valid answers to this question and they usually begin with
, “well, it depends on a number of factors.” However, in my humble opinion
, there is one universally valid answer, and that is, “it is the gun that
you have on you when you need it.” With that said, the purpose of this
brief article is to make you aware of twelve handguns that are so easy to
carry, that there is no excuse... 阅读全帖
c****x
发帖数: 1270
47
来自主题: GunsAndGears版 - 奥巴马的保安们都用什么手枪装备?
U.S. Secret Service agents carry SIG SAUER handguns. Specifically, the 
P229 chambered in .357 SIG. It’s an accurate and dependable gun that fires
a fearsome round. Up to this point, all the agents’ SIGs were equipped with
a DA/SA trigger. The first shot is double action (ten pound trigger pull,
the hammer cocks and drops). The second shot and any shots thereafter are
sent downrange via single action (pre-cocked hammer, 4.4 pound trigger pull)
. We hear that the Secret Service are switching... 阅读全帖
d******e
发帖数: 2541
48
来自主题: Tennis版 - 新年新气象
发信人: blacklodoss (flyingChopStick), 信区: Dok_Tennis_Salon
标 题: Re: 黑道,总有一天你才会觉悟的
发信站: BBS 未名空间站 (Wed Feb 5 11:07:04 2014, 美东)
嗯, 道理知道了, 不一定做的到, 但至少不会走太偏, 而且随着水平提高, 对道
理的感触也会更深。
记得一年多前,有个高手和我说, 看级别不同之处在于怎么对待easy shot, 高一级的
人是不会miss 或少miss 那些 easy shot. 每个level都一样,3.0vs3.5vs4.0vs4.
5vs5
.0... 当时想想有道理,因为高手对待那些easy shot 总让你感觉calm, steady。 不
过当时也没太多想了。
前阵子和朋友打球时聊到 "trigger point". 我说我有时把握"trigger point"把握的
不好, 有时不该pull the trigger, 有时pull trigger 时人会tight. 他对我说,
every shot is a trigger shot... 这让我感... 阅读全帖
d******e
发帖数: 2541
49
来自主题: Tennis版 - 新年新气象
发信人: blacklodoss (flyingChopStick), 信区: Dok_Tennis_Salon
标 题: Re: 黑道,总有一天你才会觉悟的
发信站: BBS 未名空间站 (Wed Feb 5 11:07:04 2014, 美东)
嗯, 道理知道了, 不一定做的到, 但至少不会走太偏, 而且随着水平提高, 对道
理的感触也会更深。
记得一年多前,有个高手和我说, 看级别不同之处在于怎么对待easy shot, 高一级的
人是不会miss 或少miss 那些 easy shot. 每个level都一样,3.0vs3.5vs4.0vs4.
5vs5
.0... 当时想想有道理,因为高手对待那些easy shot 总让你感觉calm, steady。 不
过当时也没太多想了。
前阵子和朋友打球时聊到 "trigger point". 我说我有时把握"trigger point"把握的
不好, 有时不该pull the trigger, 有时pull trigger 时人会tight. 他对我说,
every shot is a trigger shot... 这让我感... 阅读全帖
z*t
发帖数: 863
50
Beutler得奖,Medzhitov会不会有意见?
http://www.sciencedirect.com/science/article/pii/S1074761309002
Ruslan Medzhitov
This year marks the 20th anniversary of a publication (Janeway, 1989) that
in many ways revolutionized our understanding of the immune system. As part
of the proceedings of the Cold Spring Harbor Symposium on Immune Recognition
, the paper authored by the late Charles A. Janeway, Jr. was not a standard
peer-reviewed publication. In fact, Charlie used to refer to it as “the
best paper I've ... 阅读全帖
首页 上页 1 2 3 4 5 6 7 8 9 10 下页 末页 (共10页)