Posted
by chandru_cp
on Stack Overflow
See other posts from Stack Overflow
or by chandru_cp
Published on 2010-05-24T08:02:04Z
Indexed on
2010/05/24
8:11 UTC
Read the original article
Hit count: 240
select distinct * from Drivers where IsDeleted=0 gives me this,
I want select * based on distinct DriverMobNo column
© Stack Overflow or respective owner
as seen on ASP-PHP.net
- Search for 'ASP-PHP.net'
Modification technique pour le site de l'article.
>>> More
as seen on SQL Authority
- Search for 'SQL Authority'
If you are still using SQL Server 2005 – I suggest that you consider migrating to later version of the SQL Server 2008/2008 R2. Due to any reason, you wanted to continue using SQL Server 2005, I suggest that you take a look at the Feature Pack for Microsoft SQL Server 2005 SP4. There are many…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I've got a rather large SQL Server 2005 database that is under constant development. Every so often, I either get a new developer or need to deploy wide-scale schema changes to the production server.
My main concern is deploying schema + data updates to developer machines from the "master" development…
>>> More
as seen on Internet.com
- Search for 'Internet.com'
SQL Server 2005 introduced a function that is very handy when you want the result set to have row numbers assigned to each returned row.
>>> More
as seen on Internet.com
- Search for 'Internet.com'
SQL Server 2005 introduced a function that is very handy when you want the result set to have row numbers assigned to each returned row.
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
Hi I am trying to use a HTML select box with 'multiple' select options and size to 1 as below
`
<SELECT NAME="toppings" MULTIPLE SIZE=5>
<OPTION VALUE="mushrooms">mushrooms
<OPTION VALUE="greenpeppers">green peppers
</SELECT>
When the size is set to 1 small scrollbar appears…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
I noticed something strange while executing a select from 2 tables:
SELECT * FROM table_1 WHERE id IN (
SELECT id_element FROM table_2 WHERE column_2=3103);
This query took approximatively 242 seconds.
But when I executed the subquery
SELECT id_element FROM table_2 WHERE column_2=3103
it…
>>> More
as seen on SQL Authority
- Search for 'SQL Authority'
Few days ago I wrote article about SQL SERVER – Stored Procedure Optimization Tips – Best Practices. I received lots of comments on particular blog article. In fact, almost all the comments are very interesting. If you have not read all the comments, I strongly suggest to read them. Click here to…
>>> More
as seen on Programmers
- Search for 'Programmers'
var numbers = new int[] { 1, 2, 3, 4, 5 };
var contacts = from c in context.Contacts
where c.ContactID == numbers.Max() | c.ContactID == numbers.FirstOrDefault()
select c;
foreach (var item in contacts) Console.WriteLine(item.ContactID);
Linq-to-Entities…
>>> More
as seen on Stack Overflow
- Search for 'Stack Overflow'
As the title suggests, I get an error running Play 2.0.1 Tests using a FakeApplication w/ H2 in memory.
I set up a basic unit test:
public class ModelTest {
@Test
public void checkThatIndustriesExist() {
running(fakeApplication(inMemoryDatabase()), new Runnable() {
public…
>>> More
