|
if exists (select * from dbo.sysobjects where name = 'IX_EmpNames' and type = 'K')
ALTER TABLE Employee DROP CONSTRAINT IX_EmpNames
GO
ALTER TABLE Employee
ADD
CONSTRAINT IX_EmpNames UNIQUE NONCLUSTERED (Emp_FirstName, Emp_MiddleName, Emp_LastName)
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
I am a Director of Engineering, have an MBA and work in C# forms, Asp.Net and vb.net. I have been writing Windows program since windows 3.0. I am currently working in the Healthcare industry.
I enjoy reading, music (most types), and learning new technology. I am involved in opensource projects at codeplex.
My linkedin link is
http://www.linkedin.com/in/donsweitzer