@gopi Muluka

Your example assumes there's a character indicator specifying where the split occurs. His example doesn't show one. If it is a split once a certain position in...

I tend to like full featured, or nearly so with unlimited time, but with an annoying reminder at start and close that you should purchase the software. Then if I...

And that's one column, yes?

Is it always a split when you start to see numbers or is it after a certain number of characters?

Could you be more specific? Maybe give some examples of what you want to do?

When I worked at M&M Mars, they had an open floor plan that was quite noisy (and a beagle). Part of the problem was that there were no walls at...

Steve Jones - Editor (5/28/2010)

---

I'm not sure what you can do legally against companies just hiring people overseas. What you'll get is the movement more wholesale of work overseas. The...

TravisDBA (5/28/2010)[hr

Unless we enact laws that penalize companies from doing this they will continue to do it because of they can get cheap labor and work these people around the...

TravisDBA (5/28/2010)

---

I've found many companies end up paying more by outsourcing to India because of the inherant problems of working with people on the other side of the planet who...

TravisDBA (5/28/2010)

---

Stefan Krzywicki (5/28/2010)

---

Early in my career as a contractor I was told "This has to be done by next monday, I don't care how many hours it takes". I...

Early in my career as a contractor I was told "This has to be done by next monday, I don't care how many hours it takes". I got it done...

I have many hobbies: gaming (board and computer), reading and book and comic collecting, record collecting, programming, attending cons, travel, learning science, failing to learn languages (I've done quite badly...

Heh, I'd love to see what he...

stewartc-708166 (5/28/2010)

---

AS Paul stated, it is mainly a question of personal preference. There are no hard & fast rules.

My preference is to put the constraints in-line with the column definition,...

skcadavre (5/28/2010)

---

I'd write it like this: -

CREATE TABLE tested.namedkey

(

namedkeyid INT NOT NULL IDENTITY(1, 1)

...

Paul White NZ (5/27/2010)

---

This is largely a question of personal preference and formatting.

Specifying table constraints may make the definition easier to maintain in some circumstances; whereas column constraints may seem...