![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库类
renbaoyong
从事过多年的开发,流程优化,人员培训!
展开
-
利用存储过程
利用存储过程来消除数据库中冗余的数据CREATE PROCEDURE sp_mytest ASdeclare @pro varchar(50)declare @mm intdeclare wu Cursor for select distinct product from mytestopen wufetch next from wu into @prowhile @@fetch_status=0原创 2004-11-09 00:54:00 · 729 阅读 · 0 评论 -
asp 中处理异常
on error resume nextset rs=server.CreateObject("adodb.recordset")rs.open "select * from t_student where id=0",my_conn,1,3rs.addnewrs("studentID")="98106"rs("studentName")="gzp"rs("studentClass")="2"原创 2004-11-15 00:20:00 · 755 阅读 · 0 评论 -
存储过程进行数据合并导入
CREATE PROCEDURE sp_mytest1@mytype int ASdeclare @pro varchar(50)declare @pro1 varchar(50)select @pro=typename from table1 where [id]=@mytypedeclare wu Cursor for select product from table2 where [typ原创 2005-11-18 11:01:00 · 1033 阅读 · 1 评论 -
跨库的触发器
CREATE TRIGGER addtomsgdown ON [dbo].[TABLE1] FOR INSERTASdeclare @usernumber as varchar(11)declare @messagecontent as varchar(200)declare @senddate as datetimeselect @usernumber=username,@messageco原创 2006-06-03 22:14:00 · 873 阅读 · 0 评论