Click here to Skip to main content
14,690,613 members
Home » Discussions » Database
   

Database

 
QuestionNeed to drop a schema in which there are some objects exist Pin
indian1431-Aug-18 7:28
Memberindian1431-Aug-18 7:28 
AnswerRe: Need to drop a schema in which there are some objects exist Pin
Mycroft Holmes1-Aug-18 16:03
professionalMycroft Holmes1-Aug-18 16:03 
AnswerRe: Need to drop a schema in which there are some objects exist Pin
CHill602-Aug-18 3:26
mveCHill602-Aug-18 3:26 
QuestionRe: Need to drop a schema in which there are some objects exist Pin
CHill606-Aug-18 2:40
mveCHill606-Aug-18 2:40 
GeneralLegacy software: can't load MSJTER35.DLL Pin
Keith Sheppard228-Jul-18 0:26
MemberKeith Sheppard228-Jul-18 0:26 
GeneralRe: Legacy software: can't load MSJTER35.DLL Pin
Victor Nijegorodov28-Jul-18 0:45
MemberVictor Nijegorodov28-Jul-18 0:45 
GeneralRe: Legacy software: can't load MSJTER35.DLL Pin
Keith Sheppard22-Aug-18 2:23
MemberKeith Sheppard22-Aug-18 2:23 
Questioninner join results Pin
Member 1386716325-Jul-18 19:12
MemberMember 1386716325-Jul-18 19:12 
Hi,

I have below query which giving 8 records.

declare <a href="https://www.codeproject.com/Members/T">@t</a> table (id int)
declare <a href="https://www.codeproject.com/Members/t2">@t2</a> table(id2 int)
insert into <a href="https://www.codeproject.com/Members/T">@t</a> values(1),(1),(1)
insert into <a href="https://www.codeproject.com/Members/t2">@t2</a> values(1),(1),(1)
select t1.id from <a href="https://www.codeproject.com/Members/T">@t</a> t1 inner join <a href="https://www.codeproject.com/Members/t2">@t2</a> t2 on t1.id=t2.id2

I think we should get 9 records.
Please help

Thanks
AnswerRe: inner join results Pin
Richard Deeming26-Jul-18 2:50
mveRichard Deeming26-Jul-18 2:50 
AnswerRe: inner join results Pin
Victor Nijegorodov26-Jul-18 2:54
MemberVictor Nijegorodov26-Jul-18 2:54 
QuestionCreation of documentation automatically when creating or updating a stored procedure Pin
indian14323-Jul-18 14:49
Memberindian14323-Jul-18 14:49 
AnswerRe: Creation of documentation automatically when creating or updating a stored procedure Pin
Victor Nijegorodov24-Jul-18 11:12
MemberVictor Nijegorodov24-Jul-18 11:12 
AnswerRe: Creation of documentation automatically when creating or updating a stored procedure Pin
jschell28-Jul-18 8:13
Memberjschell28-Jul-18 8:13 
QuestionJob runs 3 times longer Pin
VK1920-Jul-18 8:12
MemberVK1920-Jul-18 8:12 
AnswerRe: Job runs 3 times longer Pin
Victor Nijegorodov20-Jul-18 9:01
MemberVictor Nijegorodov20-Jul-18 9:01 
AnswerRe: Job runs 3 times longer Pin
Eddy Vluggen28-Jul-18 1:16
professionalEddy Vluggen28-Jul-18 1:16 
GeneralRe: Job runs 3 times longer Pin
jschell28-Jul-18 8:14
Memberjschell28-Jul-18 8:14 
GeneralRe: Job runs 3 times longer Pin
Eddy Vluggen28-Jul-18 11:23
professionalEddy Vluggen28-Jul-18 11:23 
GeneralRe: Job runs 3 times longer Pin
Herman<T>.Instance14-Aug-18 4:01
MemberHerman<T>.Instance14-Aug-18 4:01 
GeneralRe: Job runs 3 times longer Pin
Eddy Vluggen14-Aug-18 4:08
professionalEddy Vluggen14-Aug-18 4:08 
AnswerRe: Job runs 3 times longer Pin
Mycroft Holmes28-Jul-18 15:14
professionalMycroft Holmes28-Jul-18 15:14 
Questionjoin query Pin
Member 1391987420-Jul-18 5:53
MemberMember 1391987420-Jul-18 5:53 
GeneralRe: join query Pin
Richard MacCutchan20-Jul-18 6:13
mveRichard MacCutchan20-Jul-18 6:13 
AnswerRe: join query Pin
Victor Nijegorodov20-Jul-18 8:59
MemberVictor Nijegorodov20-Jul-18 8:59 
AnswerRe: join query Pin
Mycroft Holmes20-Jul-18 13:58
professionalMycroft Holmes20-Jul-18 13:58 

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.