Skip to content

Instantly share code, notes, and snippets.

@spmallette
Created December 27, 2012 15:37
Show Gist options
  • Save spmallette/4389108 to your computer and use it in GitHub Desktop.
Save spmallette/4389108 to your computer and use it in GitHub Desktop.
default constraints on stat
ALTER TABLE [dbo].[roi_campaign_provider_stat] ADD DEFAULT ((0)) FOR [stat_states_provinces_influenced]
GO
ALTER TABLE [dbo].[roi_campaign_provider_stat] ADD DEFAULT ((0)) FOR [stat_zips_influenced]
GO
ALTER TABLE [dbo].[roi_campaign_provider_stat] ADD DEFAULT ((0)) FOR [stat_articles_published]
GO
ALTER TABLE [dbo].[roi_campaign_provider_stat] ADD DEFAULT ((0)) FOR [stat_clinical_trials_involved_in]
GO
ALTER TABLE [dbo].[roi_campaign_provider_stat] ADD DEFAULT ((0)) FOR [stat_providers_directly_influenced]
GO
ALTER TABLE [dbo].[roi_campaign_provider_stat] ADD DEFAULT ((0)) FOR [stat_early_adopters_influenced]
GO
ALTER TABLE [dbo].[roi_campaign_provider_stat] ADD DEFAULT ((0)) FOR [stat_direct_influence_nominations_received]
GO
ALTER TABLE [dbo].[roi_campaign_provider_stat] ADD DEFAULT ((0)) FOR [stat_influencers_influenced_directly]
GO
ALTER TABLE [dbo].[roi_campaign_provider_stat] ADD DEFAULT ((0)) FOR [stat_institutions_influenced]
GO
ALTER TABLE [dbo].[roi_campaign_provider_stat] ADD DEFAULT ((0)) FOR [stat_custom_1]
GO
ALTER TABLE [dbo].[roi_campaign_provider_stat] ADD DEFAULT ((0)) FOR [stat_custom_2]
GO
ALTER TABLE [dbo].[roi_campaign_provider_stat] ADD DEFAULT ((0)) FOR [stat_custom_3]
GO
ALTER TABLE [dbo].[roi_campaign_provider_stat] ADD DEFAULT ((0)) FOR [stat_custom_4]
GO
ALTER TABLE [dbo].[roi_campaign_provider_stat] ADD DEFAULT ((0)) FOR [stat_custom_5]
GO
ALTER TABLE [dbo].[roi_campaign_provider_stat] ADD DEFAULT ((0)) FOR [stat_custom_6]
GO
ALTER TABLE [dbo].[roi_campaign_provider_stat] ADD DEFAULT ((0)) FOR [stat_custom_7]
GO
ALTER TABLE [dbo].[roi_campaign_provider_stat] ADD DEFAULT ((0)) FOR [stat_custom_8]
GO
ALTER TABLE [dbo].[roi_campaign_provider_stat] ADD DEFAULT ((0)) FOR [stat_custom_9]
GO
ALTER TABLE [dbo].[roi_campaign_provider_stat] ADD DEFAULT ((0)) FOR [stat_custom_10]
GO
ALTER TABLE [dbo].[roi_campaign_provider_stat] ADD DEFAULT ((0)) FOR [stat_custom_11]
GO
ALTER TABLE [dbo].[roi_campaign_provider_stat] ADD DEFAULT ((0)) FOR [stat_custom_12]
GO
ALTER TABLE [dbo].[roi_campaign_provider_stat] ADD DEFAULT ((0)) FOR [stat_custom_13]
GO
ALTER TABLE [dbo].[roi_campaign_provider_stat] ADD DEFAULT ((0)) FOR [stat_custom_14]
GO
ALTER TABLE [dbo].[roi_campaign_provider_stat] ADD DEFAULT ((0)) FOR [stat_custom_15]
GO
ALTER TABLE [dbo].[roi_campaign_provider_stat] ADD DEFAULT ((0)) FOR [stat_custom_16]
GO
ALTER TABLE [dbo].[roi_campaign_provider_stat] ADD DEFAULT ((0)) FOR [stat_rank]
GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment