Nope, it will not.

It will place Aberlin before Berlin....

Ok.

Both samples performs search...

Andy, actually, use of CHARINDEX for ORDER BY here will not satisfy OP requirements. Try to add another City like that:

UNION ALL SELECT'Zberlin'

You query will place it straight after Aberlin,...

Look!...

Please, read the article from the link at the bottom of my signature

-- to help your helper you should provide

-- "I have table like that:" like that:

create table...

I cannot see any problems with using 3-rd party client tools if they bring any benefits.

However, why using 3-rd party client tools should stop you from using SSMS?

Is it...

Use TRY.. CATCH

I have couple of questions:

1. Why to use table variable if you only insert only one row anyway?

Is your real code will try to insert...

You can check for schema name as well:

SELECT * FROM sys.key_constraints

WHERE type = 'PK'

AND OBJECT_NAME(parent_object_id) = 'TableName'

AND SCHEMA_NAME([schema_id]) = 'SchemaName'

I knew that "how?" question will follow...

In order to provide "any TSQl code reference" we have, we will...

Jeff Moden (3/15/2012)

---

Jayanth_Kurup (3/15/2012)

---

I wud go with the instead of trigger [font="Arial Black"]if this wasnt a frequent activity[/font]. else i wud create a new column called is modifiable. and update...

thbaig1 (3/15/2012)

---

Hi,

I have around 53 tables in my schema. Due to some business constraint , we have not implement on delete cascade constraint on all entities.

Now I am finding a...

GilaMonster (3/15/2012)

---

The term 'clustering key' refers to the key column(s) of the...

It's not a Poll! It's looks like an interview questions and there is nothing to discuss about! I guess you need to do some sort of research/learning... Google usually helps!

Or,...

winston Smith (3/15/2012)

---

Regarding indexes, i always thought the clustering key and the primary key could be different.

In sql server howerver when i create a primary key it automatically creates a...