--判断是否存在改名字的过程,存在则删除(delete_date是过程名)
if exists (select * from dbo.[sysobjects] where id = object_id(N'delete_date') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [delete_date]
go
--创建过程,声明三个参数(表名,列名,值)
create proc delete_date
@tablename varchar(50),
@coluname varchar(50),
@value varchar(50)
as
begin
--声明一个命令,命令用来保存SQL语句
declare @cmd varchar(500)
--给命令赋值(删除指定表中指定列值为指定值的数据行)
set @cmd='delete from '+@tablename+' where
if exists (select * from dbo.[sysobjects] where id = object_id(N'delete_date') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [delete_date]
go
--创建过程,声明三个参数(表名,列名,值)
create proc delete_date
@tablename varchar(50),
@coluname varchar(50),
@value varchar(50)
as
begin
--声明一个命令,命令用来保存SQL语句
declare @cmd varchar(500)
--给命令赋值(删除指定表中指定列值为指定值的数据行)
set @cmd='delete from '+@tablename+' where