Աϵ֮3
˵
ʾѧá

Asp+Mssql洢̰档

msn:renaski@hotmail.com

ѧϰ֮á
ˮƽޣBUG򲻾ĵطӭָ
л̳˧ܺtzboyİ


Ϻ
2004.9.19 ҹ


ADOVBS.INC  двûаҪõĲŵconn.aspĿֻôҲοһ            ADOVBS.INCݡ

conn.asp   admin adminpswdΪԱ͹Ա




½űѯF5

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_ebook]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_ebook]
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS OFF 
GO

CREATE  proc sp_ebook
@choice varchar (50),
@id int=1,
@uname varchar (50)='renaski',
@upswd varchar(20)='1234',
@utitle varchar (100)='utitle',
@ubody varchar (3000)='ok' ,
@utime datetime =  null
with recompile
as
if @choice='select'
select * from ebook order by id desc
if @choice='del'
delete from ebook where id=@id
if @choice='add'
insert into ebook(uname,upswd,utitle,ubody,utime)values(@uname,@upswd,@utitle,@ubody,@utime)
GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

