Here is where I would start your research.

http://msdn.microsoft.com/en-us/library/ms159090(v=sql.90).aspx

As you read and have questions, come back and ask.

PaulB-TheOneAndOnly (3/23/2012)

---

Lynn Pettis (3/23/2012)

---

Even weirder is that from the...

Honestly, please provide more information. From what you originally posted it is difficult to know what you are looking for here.

Even weirder is that from the looks of this...

Just as long as the developer knows that if he hoses his system he is on is own, ensures that all required software is installed and running at all times...

Pretty awesome. Wouldn't want to get caught out in it though!

Okay, I'm getting really punchy.

Response removed.

OMG..............

sandeep4testing (3/23/2012)

---

Hi Lynin,

Thank u very much for ur quick reply,

i want different primary keys for fname and lname,

here my requirement is :

FK- FName should be FK of Users.FName

FK- LName should...

nathan 7372 (3/23/2012)

---

Hello All,

I'm experiencing some unexpected behavior using rounds and sums on a floating point column. This is my query.

SELECT

sum(round([Refund],2))

FROM [MyDatabase].[TotalRefunds]

The...

GilaMonster (3/23/2012)

---

You say that like it should be obvious it's a bad idea. I got so much flak from a client...

If you knew nothing about this problem, could you help this person with the information provided?

GilaMonster (3/23/2012)

---

Can I have some too?

50 posts (or more) trying to explain index fragmentation. http://www.sqlservercentral.com/Forums/Topic1202104-1550-1.aspx Maybe I was assuming basic knowledge that doesn't exist...

And if finally went full circle...

Here is another OMG.

Wants a primary key on fname and lname.