Click here to Skip to main content
14,634,310 members
Home » Discussions » Database
   

Database

 
JokeRe: set password on database in sql server 2005 Pin
lw@zi 21-Jul-11 22:27
professional lw@zi 21-Jul-11 22:27 
JokeRe: set password on database in sql server 2005 Pin
Blue_Boy21-Jul-11 22:28
MemberBlue_Boy21-Jul-11 22:28 
GeneralRe: set password on database in sql server 2005 Pin
SajjadZare22-Jul-11 0:24
MemberSajjadZare22-Jul-11 0:24 
GeneralRe: set password on database in sql server 2005 Pin
Blue_Boy22-Jul-11 2:56
MemberBlue_Boy22-Jul-11 2:56 
AnswerRe: set password on database in sql server 2005 Pin
Shameel22-Jul-11 9:19
professionalShameel22-Jul-11 9:19 
QuestionEntity Framework and Default Values [answered] Pin
Pascal Ganaye21-Jul-11 6:33
MemberPascal Ganaye21-Jul-11 6:33 
AnswerRe: Entity Framework and Default Values [answer] Pin
Pascal Ganaye21-Jul-11 22:05
MemberPascal Ganaye21-Jul-11 22:05 
QuestionHow to do a select statement from two or more tables? Pin
eight20-Jul-11 23:27
Membereight20-Jul-11 23:27 
Hi,

What I have is table Student and Poke

Student
------------------------------------
Student_Id(PK) | Name
------------------------------------
1                Alex
2                Bob
3                Caveman


Poke
----------------------------------------------------------
Poke_Id(PK) | Poke_Giver_Id(FK) | Poke_Receiver_Id(FK)
----------------------------------------------------------
1                    1                    2     
2                    1                    2
3                    2                    1


What I'm trying to get is something like this.
----------------------------------------------------
Poke_Id | Poke_Giver_Name | Poke_Receiver_Name
----------------------------------------------------
1             Alex             Bob
2             Alex             Bob
3             Bob              Alex



Please help.
AnswerRe: How to do a select statement from two or more tables? Pin
Blue_Boy20-Jul-11 23:43
MemberBlue_Boy20-Jul-11 23:43 
GeneralRe: How to do a select statement from two or more tables? Pin
eight20-Jul-11 23:51
Membereight20-Jul-11 23:51 
GeneralRe: How to do a select statement from two or more tables? Pin
Blue_Boy21-Jul-11 0:58
MemberBlue_Boy21-Jul-11 0:58 
AnswerRe: How to do a select statement from two or more tables? Pin
Niladri_Biswas24-Jul-11 22:26
MemberNiladri_Biswas24-Jul-11 22:26 
General:-\ Select Pin
velmahesh20-Jul-11 18:22
Membervelmahesh20-Jul-11 18:22 
AnswerRe: What is Buffer Pool in SqlServer? Pin
Mycroft Holmes20-Jul-11 20:51
professionalMycroft Holmes20-Jul-11 20:51 
AnswerRe: What is Buffer Pool in SqlServer? Pin
Blue_Boy20-Jul-11 21:25
MemberBlue_Boy20-Jul-11 21:25 
GeneralRe: What is Buffer Pool in SqlServer? Pin
Shameel21-Jul-11 2:29
professionalShameel21-Jul-11 2:29 
GeneralRe: What is Buffer Pool in SqlServer? Pin
Blue_Boy21-Jul-11 2:44
MemberBlue_Boy21-Jul-11 2:44 
AnswerRe: What is Buffer Pool in SqlServer? Pin
PIEBALDconsult21-Jul-11 2:45
professionalPIEBALDconsult21-Jul-11 2:45 
QuestionSSRS 2005 Sub report issue (newbie) Pin
Paul E Davies19-Jul-11 1:07
MemberPaul E Davies19-Jul-11 1:07 
AnswerRe: SSRS 2005 Sub report issue (newbie) Pin
Paul E Davies21-Jul-11 0:27
MemberPaul E Davies21-Jul-11 0:27 
QuestionSQL Syntax Issue Pin
Frank Lepkowski18-Jul-11 3:04
MemberFrank Lepkowski18-Jul-11 3:04 
AnswerRe: SQL Syntax Issue Pin
Tim Carmichael18-Jul-11 3:13
MemberTim Carmichael18-Jul-11 3:13 
AnswerRe: SQL Syntax Issue Pin
AnnieMacD18-Jul-11 3:38
MemberAnnieMacD18-Jul-11 3:38 
QuestionDynamic Query Question Pin
Kevin Marois14-Jul-11 19:01
professionalKevin Marois14-Jul-11 19:01 
AnswerRe: Dynamic Query Question Pin
Blue_Boy14-Jul-11 20:54
MemberBlue_Boy14-Jul-11 20:54 

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.