Viewing 15 posts - 5,056 through 5,070 (of 7,187 total)
My advice would be not to be put off by the job description. Most recruiters ask for the moon on a stick, but they don't (or shouldn't) expect to...
September 28, 2011 at 7:34 am
prakash 67108 (9/28/2011)
he needs only india and iran...why should we go for other countries..?
ashuthinks (9/28/2011)
i need to select name and region of the countries in the regions containing 'India', 'Iran'.
Using...
September 28, 2011 at 7:11 am
prakash 67108 (9/28/2011)
yes, Ratheesh is correct...may be you select wrong column...
just use select name,region from bbc where name in ('india', 'iran')
No, because this doesn't return the other countries in the...
September 28, 2011 at 4:31 am
First, select the region(s) where name is India or Iran. Then join back to the table to get the other names with the same region(s). If you provide...
September 28, 2011 at 3:41 am
Jpotucek (9/11/2008)
Also, Is there a way to get 'SQL' uptime? like individual database uptime?
That is 'SQL' uptime. tempdb is created when, and only when, SQL Server is restarted.
John
September 28, 2011 at 3:37 am
ashuthinks (9/28/2011)
something it wrong
Care to be more specific?
Your query will return only rows where region is equal to 'India' or 'Iran'. If you want rows that contain certain...
September 28, 2011 at 3:27 am
Yes. Now if you give us some more details, we may be able to help you in doing so.
John
September 28, 2011 at 3:22 am
Please will you show us the DDL for both tables (including constraints), and some sample data.
Thanks
John
September 28, 2011 at 3:17 am
Not in SQL, as far as I know. But you could write some VB and embed it in the workbook so that the format is changed whenever the cell...
September 28, 2011 at 2:05 am
So you only want one row returned for each unique combination of those two columns? How are you going to decide which row that will be when there's more...
September 28, 2011 at 1:48 am
What do you mean maintained but not updated? How do you know the index hasn't been used?
John
September 27, 2011 at 6:55 am
Jeff, I agree with you. Although I mentioned Mr Celko's name, in doing so I didn't intend to imply that I was taking his strict "ANSI good, proprietary bad"...
September 27, 2011 at 6:30 am
No, if there is corruption on your live database, that corruption will be copied when you restore on to a different server. Restoring and running DBCC CHECKDB in this...
September 27, 2011 at 6:03 am
As Jeff hinted, you need to be very careful when you don't have one-to-one relationships between your tables. The UPDATE ... FROM syntax can cause unreported cardinality errors. ...
September 27, 2011 at 2:55 am
It's not something I've ever done, I'm afraid. You'll probably need to do some good old-fashioned research... unless anyone else can point you in the right direction.
John
September 26, 2011 at 8:24 am
Viewing 15 posts - 5,056 through 5,070 (of 7,187 total)