Viewing 15 posts - 1,876 through 1,890 (of 2,894 total)
Simple change to the ordering from this:
ORDER BY
CHARINDEX('ber',City)
,City
To This
City
,CHARINDEX('ber',City)
Should handle this...
Nope, it will not.
It will place Aberlin before Berlin....
March 15, 2012 at 10:10 am
However, I do not understand why and how?
If you have any link that you can direct me to in order for me to learn, I would appreciate.
Ok.
Both samples performs search...
March 15, 2012 at 8:56 am
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,...
March 15, 2012 at 8:44 am
You only posted your original question about an hour ago. Many people may not have even had a chance to read your question, let alone respond to it.
Look!...
March 15, 2012 at 8:36 am
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...
March 15, 2012 at 8:26 am
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...
March 15, 2012 at 8:14 am
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...
March 15, 2012 at 7:37 am
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'
March 15, 2012 at 7:26 am
thbaig1 (3/15/2012)
thank you Ten Centuriesbut how ?any TSQl code reference you have ?
I knew that "how?" question will follow...
In order to provide "any TSQl code reference" we have, we will...
March 15, 2012 at 7:21 am
Jeff Moden (3/15/2012)
Jayanth_Kurup (3/15/2012)
March 15, 2012 at 7:16 am
thbaig1 (3/15/2012)
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...
March 15, 2012 at 6:23 am
GilaMonster (3/15/2012)
Eugene Elutin (3/15/2012)
There are no such thing as "CLUSTERING KEY" in SQL Server as such, but CLUSTERED INDEX.
The term 'clustering key' refers to the key column(s) of the...
March 15, 2012 at 6:16 am
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,...
March 15, 2012 at 6:09 am
winston Smith (3/15/2012)
In sql server howerver when i create a primary key it automatically creates a...
March 15, 2012 at 5:59 am
Viewing 15 posts - 1,876 through 1,890 (of 2,894 total)