if there are two same primary keys , it comes with an Error

which is better 'a' or 'b' ?

any good advice to improve the two stored procedures ?

thanks in advance.

B:

ALTER procedure dbo.us_wyj_delivergroup_06

@strdate varchar(16),

@par1 int ,

@par12 varchar(20),

@par2 int,

@par3 int,

@par31 ...

i really appreciate your help.

thanks .

thanks.

i want to create a job to put some data into 'work.xls' every day.

so i think it's nessary to run '*.exe' or '*.bat' in sql server.

thanks.

Thanks everyone for their responses.

quote:

---

No, but you could script the entire db and rerun the script in a new db. Pretty simple.

Steve Jones

sjones@sqlservercentral.com

http://www.sqlservercentral.com/columnists/sjones