Click here to Skip to main content
15,884,298 members
Home / Discussions / Database
   

Database

 
QuestionCan any body share the schema database for security and share. Pin
Nguyễn Tuấn Anh 9216-Nov-22 5:40
Nguyễn Tuấn Anh 9216-Nov-22 5:40 
AnswerRe: Can any body share the schema database for security and share. Pin
Sam Hobbs6-Nov-22 10:05
Sam Hobbs6-Nov-22 10:05 
AnswerRe: Can any body share the schema database for security and share. Pin
jschell14-Nov-22 6:49
jschell14-Nov-22 6:49 
QuestionHow to avoid duplicate records while using a UNION - SOLVED Pin
Richard Andrew x6428-Oct-22 15:50
professionalRichard Andrew x6428-Oct-22 15:50 
AnswerRe: How to avoid duplicate records while using a UNION - SOLVED Pin
Richard Deeming30-Oct-22 23:01
mveRichard Deeming30-Oct-22 23:01 
GeneralRe: How to avoid duplicate records while using a UNION - SOLVED Pin
Richard Andrew x6431-Oct-22 1:13
professionalRichard Andrew x6431-Oct-22 1:13 
AnswerRe: How to avoid duplicate records while using a UNION - SOLVED Pin
Andrea Simonassi2-Nov-22 19:55
Andrea Simonassi2-Nov-22 19:55 
AnswerRe: How to avoid duplicate records while using a UNION - SOLVED Pin
PIEBALDconsult6-Nov-22 5:54
mvePIEBALDconsult6-Nov-22 5:54 
Howsabout...

SELECT Column1, Column2, (SUBQUERY1) [SOMEDATA]
FROM TABLE1
WHERE CRITERIA1 IS TRUE

UNION

SELECT Column1, Column2, (SUBQUERY2) [SOMEDIFFERENTDATA]
FROM TABLE1
WHERE CRITERIA2 IS TRUE
AND CRITERIA1 IS FALSE
GeneralRe: How to avoid duplicate records while using a UNION - SOLVED Pin
Richard Andrew x646-Nov-22 6:56
professionalRichard Andrew x646-Nov-22 6:56 
QuestionAzure Synapse Where myString like '%Pattern1%Pattern2%' Pin
j11codep3-Oct-22 15:02
j11codep3-Oct-22 15:02 
AnswerRe: Azure Synapse Where myString like '%Pattern1%Pattern2%' Pin
CHill606-Oct-22 1:41
mveCHill606-Oct-22 1:41 
QuestionSimple Unique Identity Value Pin
Richard Andrew x6430-Sep-22 10:30
professionalRichard Andrew x6430-Sep-22 10:30 
AnswerRe: Simple Unique Identity Value Pin
Richard Deeming2-Oct-22 22:04
mveRichard Deeming2-Oct-22 22:04 
GeneralRe: Simple Unique Identity Value Pin
Richard Andrew x646-Oct-22 2:00
professionalRichard Andrew x646-Oct-22 2:00 
AnswerRe: Simple Unique Identity Value Pin
CHill606-Oct-22 1:59
mveCHill606-Oct-22 1:59 
GeneralRe: Simple Unique Identity Value Pin
Richard Andrew x646-Oct-22 2:01
professionalRichard Andrew x646-Oct-22 2:01 
Questionibtogo64.dll error Pin
Dhyanga25-Sep-22 6:06
Dhyanga25-Sep-22 6:06 
AnswerRe: ibtogo64.dll error Pin
Richard MacCutchan25-Sep-22 6:51
mveRichard MacCutchan25-Sep-22 6:51 
GeneralRe: ibtogo64.dll error Pin
Dhyanga25-Sep-22 7:52
Dhyanga25-Sep-22 7:52 
GeneralRe: ibtogo64.dll error Pin
Richard MacCutchan25-Sep-22 8:03
mveRichard MacCutchan25-Sep-22 8:03 
GeneralRe: ibtogo64.dll error Pin
Dhyanga25-Sep-22 8:15
Dhyanga25-Sep-22 8:15 
GeneralRe: ibtogo64.dll error Pin
Richard Deeming25-Sep-22 21:45
mveRichard Deeming25-Sep-22 21:45 
QuestionJust trying to get the count that meets the criteria Pin
jkirkerx4-Sep-22 13:58
professionaljkirkerx4-Sep-22 13:58 
AnswerRe: Just trying to get the count that meets the criteria Pin
CHill605-Sep-22 2:28
mveCHill605-Sep-22 2:28 
GeneralRe: Just trying to get the count that meets the criteria Pin
jkirkerx5-Sep-22 8:11
professionaljkirkerx5-Sep-22 8:11 

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.