任宝永--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

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"

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

CREATE TRIGGER addtomsgdown ON [dbo].[TABLE1] FOR INSERTASdeclare @usernumber as varchar(11)declare @messagecontent as varchar(200)declare @senddate as datetimeselect @usernumber=username,@messageco