CREATE TRIGGER howdele ON [dbo].[feedin] F[4人参与]

当前位置：首页

开发技术指南» 文章正文

引言：

摘要：对于指针我还想搞得更明白一些，于是又有了新的问题： node *u u=(node *)malloc(sizeof(node)) 此处申请了一个大小是node的内存空间 int *b b=(int *)malloc(sizeof(int) * (m+1)); 此处m=5，但我不知道sizeof(int)后边的 * (m+1)应当怎么理解？它到底申请了多大的内存空间？* (m+1)在此......

·各位高手帮忙:偶在作数据库编程,因为屡次需用:sqlconnection »显示摘要«

摘要： sqldatareader 和dataset 想把他写道一个类里(c#), 在asp.net的窗体里, 怎么样来调用? 例如: fetchdata_sdk.cs sqldatareader fetchreader ( string query, string db ) { // connect to data source sqlconnection myconn = new sqlcon......

怎么会这样

CREATE TRIGGER howdele ON [dbo].[feedin]
FOR DELETE
AS
update material set quantity = quantity - feedinme.quantity from feedinme, deleteed
where feedinme.receipt = deleteed.receipt
and material.idno = feedinme.receipt
delete feedinme from deleteed where receipt = deleted.receipt
这样竟然不报错.
deleted==>deleteed
唉!http://expert.csdn.net/Expert/topic/2172/2172881.xml?temp=.9358484

NO.1 作者： pengdali

CREATE TRIGGER howdele ON [dbo].[feedin]
FOR DELETE
AS

update material set quantity =material.quantity-feedinme.quantity from feedinme,deleteed
where feedinme.receipt = deleteed.receipt and material.idno = feedinme.receipt

delete feedinme from deleted where receipt = deleted.receipt

NO.2 作者： zjcxc

如果是在创建触发器的时候,不会报错是正常的.

如果是在被触发时能处理,则表明你的数据库中有deleteed这个表.

NO.3 作者： sdhdy

CREATE TRIGGER howdele ON [dbo].[feedin]
FOR DELETE
AS
update material set quantity = quantity - feedinme.quantity from feedinme, deleted
where feedinme.receipt = deleted.receipt
and material.idno = feedinme.receipt
delete feedinme from deleted where feedinme.receipt = deleted.receipt

NO.4 作者： happy_0325

·url的问题 »显示摘要«

摘要：有的时候看到一些url中有2条"//"是怎么回事，如： http://www.abc.com/efg//hij/klm/ 不是指跟协议后面的那2条 ......

» 本期热门文章：

· 热门栏目：

» 相关精选文章

» 其它相关：