Ensure Table has only one row

Question

Ensure Table has only one row

harsha.majety

SSCommitted

Points: 1537
More actions
December 8, 2011 at 12:30 am

#249379

Comments posted to this topic are about the item Ensure Table has only one row

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Stephen_W_Dodd SSCommitted Points: 1648 More actions · Answer 1

Sometimes I want to keep a "history" of the different settings, or have more than one set depending on circumstances. In these cases, I use a "current" column (bit) to determine which row I should be using. Just for info.

Eric M Russell SSC Guru Points: 125596 More actions · Answer 2

An alternate method to insure only one row (or 2, 3, ... rows) would be to simply define a unique key and check constraint on the table's ID column.

create table tempdb..foo

(

foo_id int not null primary key check (foo_id = 1)

);

"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 3

Stephen_W_Dodd (12/8/2011)
Sometimes I want to keep a "history" of the different settings, or have more than one set depending on circumstances. In these cases, I use a "current" column (bit) to determine which row I should be using. Just for info.

Thanks for the tip.

Ensure Table has only one row

Cookies on SQLServerCentral