|
The easiest way around this is to not execute queries that return rows.
Instead of:
SELECT *
FROM Users
WHERE ID = "Tom"
Do:
DELCARE @i INTEGER
SELECT @i = COUNT(*)
FROM Users
WHERE ID = "Tom"
You can use logic to determine if @i > 0 then process the rest of the login. You can use any number of variables in the SELECT. Just make sure your query only returns 1 row.
You can also use EXISTS:
IF EXISTS(SELECT * FROM Users WHERE ID = "Tom")
BEGIN
-- Do your work here
END
|
|
|
|
|
Hey all, I've got data structured like this:
ID - Contact - Company - Email
1 - Jeff - Acme - Jeff@Acme.com
2 - Hester - Acme - Hester@Acme.com
3 - Mort - Acme - Mort@Acme.com
4 - Jason - Widget - Jason@Widget.com
5 - Harriet - Widget - Harriet@Widget.com
I need to write a query that will return only the first contact for each company, in this case it should return:
----------------------------------------
1 - Jeff - Acme - Jeff@Acme.com
4 - Jason - Widget - Jason@Widget.com
Thanks in advance!
*->>Always working on my game, teach me
*->>something new.
cout << "dav1d\n";
|
|
|
|
|
Not Tested but give it a try.
<br />
SELECT ID, Contact, Company, Email<br />
FROM [table]<br />
GROUP BY Company<br />
HAVING MAX(ID) = ID<br />
Michael
I firmly believe that any man's finest hour, the greatest fulfillment of all that he holds dear, is that moment when he has worked his heart out in a good cause and lies exhausted on the field of battle - victorious.
Vince Lombardi (1913-1970)
|
|
|
|
|
Just a little correction
SELECT ID, Contact, Company, Email
FROM [table]
GROUP BY Company
HAVING MIN(ID) = ID
|
|
|
|
|
Nope
something like
select * from [table] t where id=(select min(id) from [table] tt where t.company=tt.company)
HTH
|
|
|
|
|
Check this
SELECT *
FROM DeleteMe
GROUP BY Company
HAVING MIN(ID) = ID
|
|
|
|
|
It will nerver work. Read BOL about GROUP BY first before posting.
|
|
|
|
|
Why dont you try it first then reply. I have already tested it and it works fine.
I think you need some lesson on Group By.
|
|
|
|
|
well the query by alam_pune looks fine to me as well..... its a nice and simple sql and works fine too.....
|
|
|
|
|
select * from [table] where ID in
(select min(ID) from [table] group by company )
|
|
|
|
|
I am having a Data Set which has multiple tables. I want the changes to be updated in the database(SqlServer 2000) which i perform in dataset.
I want to use only single DataAdapter for that. Please suggest me how to proceed regarding this.
Mansimranjit
|
|
|
|
|
Hi !
My app is using SQLite as a database. I'd like to change the datatype of a column of several tables (for example changing from VARCHAR(10) to VARCHAR(50)) without loosing the existing datas.
How can I do this in SQL ? I didn't find anything ! Is it possible ?
Thanks for your help !
Jerome
|
|
|
|
|
Just use the ALTER COLUMN syntax. If I had the following table:
CREATE TABLE DContact(
CONTACTID INT IDENTITY(1,1),
CONTACT VARCHAR(50),
COMPANY VARCHAR(50),
EMAIL VARCHAR(50)
)
I could change things like so:
ALTER TABLE DContact
ALTER COLUMN Email VARCHAR(100)
GO
This is TSQL that I wrote and tested, but it should be generic enough to work with your database.
*->>Always working on my game, teach me
*->>something new.
cout << "dav1d\n";
|
|
|
|
|
when i use localhost in connection string dose not connect to the server i got SQL Server does not exist or access denied but when i use computer name it work the problem that programs use localhost dose not work how to resolve this
My Configrations
1-WinXP SP2 -Firewall OFF
2-SqlServer 2000 SP4
thanks for your help
|
|
|
|
|
Use "(local)" instead of "localhost". Off the top of my head I cannot remember the reason why, but there is a difference.
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
Thanks for your replay but this if you write the application or use computer name will work but what if you do not have access to the application source and can not configer connection string?
ie how to make localhost work ?
|
|
|
|
|
Then how are you managing to configure it between using localhost and the computer name?
At a guess (as I've never come across this problem) you probably need to ensure that SQL Server is set up to use TCP/IP as a communications mechanism - and you need to ensure you have a network adapter for the communications to route through (even although it will just get looped back).
My: Blog | Photos
"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious
|
|
|
|
|
When
Colin Angus Mackay wrote:
Then how are you managing to configure it between using localhost and the computer name?
when i wrote my application using local host it dose not work when i replace it with computer name it works
the problem the application that i do not write it it give me the error and i can not change the connection string and
SQL Server is set up to use TCP/IP as a communications mechanism
|
|
|
|
|
How can I find out programatically all the ODBC Drivers avaliable on a system?
Hope I understand...because is a rough world out there...
|
|
|
|
|
|
Thank you
I hope you understand...because is a rough world out there...
|
|
|
|
|
Hi there,
following my last question where I inserted data coming from different tables, I displayed these data using crystal report. Up to here everything is fine. The data displayed is grouped by Appartment Code Id field.In my report, data look like this:
Appartement Code : 1737/R1
inhaitant Name: Mike Jones
|month |Amount due
|07-2005 |100
|08-2005 |100
total Due:200
Appartement Code : 1737/R2
Inhabitant Name: Emilie carter
|month |Amount due
|06-2005 |100
|07-2005 |100
total Due:200
As these are grouped by Appartement Id each time I click on the appartment Id A new page with only the group information is displayed on a separate page.
What I want to know is how can I custom this page so that It can e used as a letter to my client?
example of what I need:
Once I click on 1737/R2
I want to get in a new page:
Dear Mr/miss Emilie Carter,
I'm glad to announce you that you owe me a total of 200$ for the rent of your appartement for the unpaid periods of 06-07 2005.
compliments
Something like that!
If you can help please do!
anyOne who shows you something you ignore gave you a real tresure!he's your master.To thank him,transmit what you learned
|
|
|
|
|
Hi all,
How to package sql server database as part of our custom application (VB application) using install shield or any software.
That setup should detect the presence of sql server. If sql server is not present in the client machine, then our set up should install the sql server and deploy our database.
If sql server is present in the client machine, then our set up should install our database alone. How to do that. Please help me.
 Regards,
S.Sevugan.
|
|
|
|
|
By license, you can't distribute SQL Server with your application. Your user has to install it manually. But you can create a database in an already-installed SQL Server.
There's actually a version of SQL Server that you can distribute. It's called MSDE, but it has certain limitations for very big databases. Search MSDN for MSDE.
-- LuisR
Luis Alonso Ramos
Intelectix - Chihuahua, Mexico
Not much here: My CP Blog!
The amount of sleep the average person needs is five more minutes. -- Vikram A Punathambekar, Aug. 11, 2005
|
|
|
|
|
when you get your solution plz email it to ndnzuza@gmail.com
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
