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.

...

There is hardly ever a good reason for employees or contractors to copy sensitive production data down to the local SQL Server instance on their laptop or desktop. Any developer...

It seems like I hear more stories about sensitive data theft (or least misplacement) as a result of some developer's laptop getting stolen than I do about production database servers...

On any given day, I rarely check email while out of the office, even when not on vacation. If something important comes up, I'll get a call on my cell...

David Moutray (11/29/2011)

---

I Dont want to change on the DB , i want to have that display as YYYY/MM/DD when i want to generate reports for the application reports, the...

rashid_alavi (11/29/2011)

---

hi All,

I Dont want to change on the DB , i want to have that display as YYYY/MM/DD when i want to generate reports for the application reports, the...

Members of different teams often follow a rigid "start [this] only after [that] has been completed" development path that isn't necessary.

For example, when developing the data model and stored procedures...

rashid_alavi (11/27/2011)

---

Dear All,

i have column in my table which of datatype varchar(14) (20111107070115) , now i want to change display

2011/11/07 07:01:15 ( DD/MM/YYYY HH:MM:SS)

please help me on this ,...

When something like this arisis, it helps a lot when the team's manager acknowledges that he or she is aware of the situation and understands the reason for delay is...

I agree with the quote "perfect is the enemy of good", and I'll be the first to compromise.

Here is the problem: Ask 100 people to define their idea...

In terms of which technique will perform the best; it really depends on the actual table definition and indexing. Obviously what you originally intended to be an ID column is...

Evil Kraig F (11/21/2011)

---

There's no guarantee I'm going to safely cross...

Eric M Russell (11/18/2011)

---

LadyRuna (11/18/2011)

---

Definitely the trip to space for me 🙂

Taking the cash is a bad plan because the government will steal about 60% of it in...

LadyRuna (11/18/2011)

---

Definitely the trip to space for me 🙂

Taking the cash is a bad plan because the government will steal about 60% of it in the form of...

Ninja's_RGR'us (11/18/2011)

---

Eric M Russell (11/18/2011)

---

Ninja's_RGR'us (11/18/2011)

---

SPACE, anytime.

100K is easy-ish to come buy with more work. Space is another story and not enough of a motivator to work towards for...