ALTER TABLE [SL].[dbo].[zz_styles] ADD UNIQUE (av0_style) in case you have varchar(max) set, you need to change it ALTER TABLE [SL].[dbo].[zz_styles] ALTER COLUMN av0_style VARCHAR(50); ALTER TABLE [SL].[dbo].[zz_styles] ADD UNIQUE (av0_style)

http://www.w3schools.com/sql/sql_unique.asp

ALTER TABLE [SL_h].[dbo].[synced_table_columns] ADD CONSTRAINT tab_col UNIQUE(tab, col); 20.01.17

https://stackoverflow.com/questions/15800250/add-unique-constraint-to-combination-of-two-columns

ALTER TABLE [SL_h].[dbo].[web_section_sales] ADD CONSTRAINT date_sec_code UNIQUE(dates, [section_code]) WITH (IGNORE_DUP_KEY = ON) to ignore duplicated with mssql insert and values 20.01.17 ALTER TABLE [SL].[dbo].[zz_process_bom] ADD CONSTRAINT proc_deperment UNIQUE([tsa_process], [department]) WITH (IGNORE_DUP_KEY = ON) 20.01.17 ALTER TABLE [SL].[dbo].[table_size] ADD CONSTRAINT usdn UNIQUE([update], [server],[database_name]) WITH (IGNORE_DUP_KEY = ON) 20.01.17 ALTER TABLE [SL_h].[dbo].[table_size] ADD CONSTRAINT usdn UNIQUE([update], [server],[database_name],table_name) WITH (IGNORE_DUP_KEY = ON) 20.01.17 ALTER TABLE [SL_h].[dbo].[sold_item_factory] ADD CONSTRAINT uniall UNIQUE( [inv_date] ,[inv_ship_date] ,[inv_status] ,[inv_no] ,[customer] ,[inv_line] ,[style] ,[qty_item] ,[bom_weight] ,[karat] ,[metal] ,[wt_invoice] ,[wt_inv_convert] ,[wt_bom] ,[wt_bom_convert] ,[wt_invoice_per_1]) WITH (IGNORE_DUP_KEY = ON) 20.01.17 Create unique pairs and prevent an error when re-insert with a mssql insert command ALTER TABLE [SL_customer].[dbo].[special_price] ADD CONSTRAINT uniall UNIQUE( [pricelist] ,[style] ,[from] ) WITH (IGNORE_DUP_KEY = ON) 20.01.17 BEGIN CREATE TABLE [SL_customer].[dbo].[special_cost] ( [id] int NOT NULL IDENTITY(1,1) PRIMARY KEY ,[pricelist] VARCHAR(50) NOT NULL DEFAULT '' ,[style] VARCHAR(250) NOT NULL DEFAULT '' ,[cost] float NOT NULL DEFAULT 0 ) END ALTER TABLE [SL_customer].[dbo].[special_cost] ADD CONSTRAINT psuniall UNIQUE( [pricelist] ,[style] ) WITH (IGNORE_DUP_KEY = ON) 20.01.17 ALTER TABLE [SL].[dbo].[zz_worker_extra] ADD CONSTRAINT salid_y_m UNIQUE( [salamander_id] ,[year] ,[month] ) WITH (IGNORE_DUP_KEY = ON) 20.01.17 ALTER TABLE [SL_h].[dbo].[reports_monthly] ADD [date] varchar(6) NOT NULL DEFAULT '' ALTER TABLE [SL_h].[dbo].[reports_monthly] ADD CONSTRAINT dateuniall UNIQUE([date]) WITH (IGNORE_DUP_KEY = ON) 20.01.17

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024