Click here to Skip to main content
15,878,970 members
Home / Discussions / Database
   

Database

 
QuestionStored Procedure Pin
Nath20-Oct-10 22:19
Nath20-Oct-10 22:19 
AnswerRe: Stored Procedure Pin
J4amieC20-Oct-10 23:38
J4amieC20-Oct-10 23:38 
GeneralRe: Stored Procedure Pin
Mycroft Holmes21-Oct-10 13:04
professionalMycroft Holmes21-Oct-10 13:04 
GeneralRe: Stored Procedure Pin
J4amieC21-Oct-10 21:48
J4amieC21-Oct-10 21:48 
GeneralRe: Stored Procedure Pin
Mycroft Holmes22-Oct-10 0:52
professionalMycroft Holmes22-Oct-10 0:52 
QuestionReturn name and identity for all tables Pin
yippiecoder20-Oct-10 10:55
yippiecoder20-Oct-10 10:55 
AnswerRe: Return name and identity for all tables Pin
Blue_Boy20-Oct-10 21:12
Blue_Boy20-Oct-10 21:12 
GeneralRe: Return name and identity for all tables Pin
David Skelly20-Oct-10 22:40
David Skelly20-Oct-10 22:40 
Maybe I'm missing something here. How can that ever return 0?

If I have understood it correctly, this is what the query will do:

Select the rows from TABLES with type "BASE TABLE"
Group them by TABLE_NAME
Counts the number of rows for each TABLE_NAME
If the count is 0, return 0
If the count is not 0, return the identity of the table

But, surely the only way COUNT(TABLE_NAME) can be 0 is if there are no rows in TABLES with this TABLE_NAME and type "BASE TABLE". In which case, this query would never pick up that table name, so it would never appear in the result set. So for any TABLE_NAME that this query picks up, the count will always be greater than 0.
QuestionI want your help Pin
Lamis Radman19-Oct-10 9:31
Lamis Radman19-Oct-10 9:31 
AnswerRe: I want your help Pin
Pete O'Hanlon20-Oct-10 0:02
mvePete O'Hanlon20-Oct-10 0:02 
QuestionXml datatype vs cdc Pin
Ebube19-Oct-10 6:47
Ebube19-Oct-10 6:47 
AnswerRe: Xml datatype vs cdc Pin
Mycroft Holmes19-Oct-10 12:22
professionalMycroft Holmes19-Oct-10 12:22 
GeneralRe: Xml datatype vs cdc Pin
Ebube21-Oct-10 5:37
Ebube21-Oct-10 5:37 
Questionhow to use % symbol in Like statement. Pin
shiva.kore18-Oct-10 21:13
shiva.kore18-Oct-10 21:13 
AnswerRe: how to use % symbol in Like statement. Pin
thatraja18-Oct-10 21:21
professionalthatraja18-Oct-10 21:21 
QuestionMessage Removed Pin
18-Oct-10 8:03
eddieangel18-Oct-10 8:03 
AnswerRe: Normalization / Referential Integrity Pin
Eddy Vluggen18-Oct-10 8:21
professionalEddy Vluggen18-Oct-10 8:21 
AnswerRe: Normalization / Referential Integrity Pin
Chris Meech18-Oct-10 8:43
Chris Meech18-Oct-10 8:43 
AnswerRe: Normalization / Referential Integrity [modified] Pin
PIEBALDconsult18-Oct-10 9:00
mvePIEBALDconsult18-Oct-10 9:00 
AnswerRe: Normalization / Referential Integrity Pin
Mycroft Holmes18-Oct-10 13:00
professionalMycroft Holmes18-Oct-10 13:00 
GeneralRe: Normalization / Referential Integrity Pin
eddieangel18-Oct-10 13:12
eddieangel18-Oct-10 13:12 
AnswerRe: Normalization / Referential Integrity Pin
Ray Cassick18-Oct-10 13:51
Ray Cassick18-Oct-10 13:51 
QuestionCan a Unique Index be set on a secondary linked table field? Pin
Stryder_118-Oct-10 7:29
Stryder_118-Oct-10 7:29 
AnswerRe: Can a Unique Index be set on a secondary linked table field? [modified] Pin
Eddy Vluggen18-Oct-10 8:24
professionalEddy Vluggen18-Oct-10 8:24 
AnswerRe: Can a Unique Index be set on a secondary linked table field? Pin
rushingfly18-Oct-10 20:19
rushingfly18-Oct-10 20:19 

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.