IF NOT EXISTS (select * from dbo.sysobjects where id = object_id(N'COMPONENT_EVENT') and type = 'U') BEGIN CREATE TABLE COMPONENT_EVENT ( COMPONENT_EVENT_ID integer IDENTITY, COMPONENT_CD nvarchar(50) NOT NULL, COMPONENT_DESC nvarchar(50) NULL, COMPONENT_EVENT nvarchar(30) NULL, COMPONENT_LEVEL nvarchar(30) NULL, EVENT_DT datetime DEFAULT getdate() NOT NULL, CTRL_INSERT_DT datetime DEFAULT getdate() NOT NULL, CTRL_UPDATE_DT datetime DEFAULT getdate() NOT NULL ) ALTER TABLE COMPONENT_EVENT ADD CONSTRAINT CMPNNTVNT_PK PRIMARY KEY (COMPONENT_EVENT_ID ASC) END go
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.
Connect with Certified Experts to gain insight and support on specific technology challenges including:
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE