有关一个存储过程的问题

Question

有关一个存储过程的问题，要求实现修改Babies表的记录。两个参数分别为列名，值
表结构如下：
IF EXISTS(SELECT * FROM sysobjects WHERE name='Babies')
DROP TABLE Babies 
CREATE TABLE Babies(ID uniqueidentifier not null,Name varchar(50),Sex bit,Birthday datetime ,Birthplace char(8),Mother uniqueidentifier,Father uniqueidentifier,Attachtime datetime,Attacher nvarchar(50))
insert into Babies values(newid(),'杨明',1,'2008-01-01','22010301','7A510535-5C9C-49E1-B505-009B801E9D8A','87C6BCAB-6F34-49AF-B2C9-0098C4321A0B','2010-02-01','吕布')
insert into Babies values(newid(),'朱洋',1,'2010-03-23','22010301','67484537-BF48-45A0-99BE-00F1FAA0D897','D8CAB962-3C91-4F1F-8715-00C69035092E','2010-02-01','吕布')
insert into Babies values(newid(),'吴娜',0,'2010-05-22','22010301','8B1F23C8-BDA6-4864-A247-010A23E1E733','D76E3199-5DA0-4312-BC5C-00F478C1A084','2010-02-01','吕布')
insert into Babies values(newid(),'刘晗',0,'2010-04-03','22010301','2B6B294F-8890-4B1E-B0B0-011CAA855A9E','1BACB014-572F-4B46-B156-0112FF267497','2010-02-01','赵云')
alter table Babies
add constraint PK_BID primary key(ID)求高手指教，存储过程代码，谢谢！

Answer 1

就是要修改Babies表中的记录，要求用两个参数，分别为列名和值，写出存储过程。

Answer 2

create proc sp_Cbabies
(
@Idname varchar (100),
@values varchar (100)
)
as
begin
IF EXISTS(SELECT * FROM sysobjects WHERE name='Babies')
DROP TABLE Babies  
CREATE TABLE Babies(ID uniqueidentifier not null,Name varchar(50),Sex bit,Birthday datetime ,Birthplace char(8),Mother uniqueidentifier,Father uniqueidentifier,Attachtime datetime,Attacher nvarchar(50))
insert into Babies values(newid(),N'杨明',1,'2008-01-01','22010301','7A510535-5C9C-49E1-B505-009B801E9D8A','87C6BCAB-6F34-49AF-B2C9-0098C4321A0B','2010-02-01',N'吕布')
insert into Babies values(newid(),N'朱洋',1,'2010-03-23','22010301','67484537-BF48-45A0-99BE-00F1FAA0D897','D8CAB962-3C91-4F1F-8715-00C69035092E','2010-02-01',N'吕布')
insert into Babies values(newid(),N'吴娜',0,'2010-05-22','22010301','8B1F23C8-BDA6-4864-A247-010A23E1E733','D76E3199-5DA0-4312-BC5C-00F478C1A084','2010-02-01',N'吕布')
insert into Babies values(newid(),N'刘晗',0,'2010-04-03','22010301','2B6B294F-8890-4B1E-B0B0-011CAA855A9E','1BACB014-572F-4B46-B156-0112FF267497','2010-02-01',N'赵云')
alter table Babies
add constraint PK_BID primary key(ID)update Babies set name=@Idname,attacher=@values where sex=1select * from Babies
endexec sp_Cbabies '猪羊','女埠'