Click here to Skip to main content
15,905,229 members
Home / Discussions / Database
   

Database

 
GeneralRe: SQL statement on website, global password Pin
andyharman15-Oct-07 8:29
professionalandyharman15-Oct-07 8:29 
Questiona problem about stackoverflow Pin
nibabug12-Oct-07 3:27
nibabug12-Oct-07 3:27 
AnswerRe: a problem about stackoverflow Pin
Pete O'Hanlon12-Oct-07 4:44
mvePete O'Hanlon12-Oct-07 4:44 
GeneralRe: a problem about stackoverflow Pin
nibabug12-Oct-07 15:26
nibabug12-Oct-07 15:26 
GeneralRe: a problem about stackoverflow Pin
nibabug12-Oct-07 15:36
nibabug12-Oct-07 15:36 
QuestionChecking Duplicate values in Database Pin
codingrocks12-Oct-07 2:25
codingrocks12-Oct-07 2:25 
AnswerRe: Checking Duplicate values in Database Pin
Pete O'Hanlon12-Oct-07 2:31
mvePete O'Hanlon12-Oct-07 2:31 
AnswerRe: Checking Duplicate values in Database Pin
Skanless12-Oct-07 5:33
Skanless12-Oct-07 5:33 
Are u checking for duplicate values in a Database or a table? If it is a table the you use the following script.

SELECT
count(Column(s))
FROM
table_Name
ORDER BY Column(s)
GROUP BY column(s)
HAVING Count(Column(s)) > 1

Hope this helps.

Skan

If you knew it would not compile why didn't you tell me?!?!?!

QuestionHow to update a table using a Select statement in the Where Clause Pin
Skanless11-Oct-07 16:47
Skanless11-Oct-07 16:47 
AnswerRe: How to update a table using a Select statement in the Where Clause [modified] Pin
joemonvarghese11-Oct-07 19:28
joemonvarghese11-Oct-07 19:28 
AnswerRe: How to update a table using a Select statement in the Where Clause Pin
Skanless12-Oct-07 21:08
Skanless12-Oct-07 21:08 
QuestionPlease Help to me this is very urgent issue Pin
mohd faiz11-Oct-07 12:52
mohd faiz11-Oct-07 12:52 
AnswerRe: Please Help to me this is very urgent issue Pin
Christian Graus11-Oct-07 13:41
protectorChristian Graus11-Oct-07 13:41 
AnswerRe: Please Help to me this is very urgent issue Pin
kubben12-Oct-07 2:13
kubben12-Oct-07 2:13 
AnswerRe: Please Help to me this is very urgent issue Pin
Skanless12-Oct-07 5:35
Skanless12-Oct-07 5:35 
Questionconnection string Pin
IamAmit11-Oct-07 5:49
IamAmit11-Oct-07 5:49 
AnswerRe: connection string Pin
Vasudevan Deepak Kumar11-Oct-07 7:24
Vasudevan Deepak Kumar11-Oct-07 7:24 
Question1:1 Relationships Pin
Brendan Vogt11-Oct-07 4:43
Brendan Vogt11-Oct-07 4:43 
AnswerRe: 1:1 Relationships Pin
John Gathogo11-Oct-07 4:47
John Gathogo11-Oct-07 4:47 
AnswerRe: 1:1 Relationships Pin
Rob Philpott11-Oct-07 4:54
Rob Philpott11-Oct-07 4:54 
GeneralRe: 1:1 Relationships Pin
Colin Angus Mackay11-Oct-07 5:22
Colin Angus Mackay11-Oct-07 5:22 
AnswerRe: 1:1 Relationships Pin
Skanless12-Oct-07 5:38
Skanless12-Oct-07 5:38 
GeneralRe: 1:1 Relationships Pin
Colin Angus Mackay12-Oct-07 9:03
Colin Angus Mackay12-Oct-07 9:03 
QuestionTable comparison in sql server 2000 Pin
Guru_yogi11-Oct-07 4:10
Guru_yogi11-Oct-07 4:10 
AnswerRe: Table comparison in sql server 2000 Pin
Rob Philpott11-Oct-07 4:37
Rob Philpott11-Oct-07 4:37 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.