Click here to Skip to main content
15,039,244 members
Home / Discussions / Database
   

Database

 
GeneralRe: Combining Data From Temp Tables Pin
Matt U.29-Jan-13 2:52
MemberMatt U.29-Jan-13 2:52 
GeneralRe: Combining Data From Temp Tables Pin
Jörgen Andersson29-Jan-13 3:02
professionalJörgen Andersson29-Jan-13 3:02 
GeneralRe: Combining Data From Temp Tables Pin
Jörgen Andersson28-Jan-13 22:28
professionalJörgen Andersson28-Jan-13 22:28 
Question[VB.net+ADO.net]how can combobox 1 control the result of combobox2 Pin
Achilles8428-Jan-13 8:20
MemberAchilles8428-Jan-13 8:20 
AnswerRe: [VB.net+ADO.net]how can combobox 1 control the result of combobox2 Pin
Achilles8430-Jan-13 3:47
MemberAchilles8430-Jan-13 3:47 
QuestionSMO Retrieve Table Record Pin
savbace28-Jan-13 2:31
Membersavbace28-Jan-13 2:31 
AnswerRe: SMO Retrieve Table Record Pin
Sandeep Mewara28-Jan-13 2:42
mvaSandeep Mewara28-Jan-13 2:42 
AnswerRe: SMO Retrieve Table Record Pin
savbace28-Jan-13 2:55
Membersavbace28-Jan-13 2:55 
Thanks for reply. But it is not actually I'm looking for. I'll try to clarify. Assume we have table "Users":

| Id | Name | Pass   |
----------------------
|  1 | Kate | qwerty |
|  2 | Mike | asd$f5 |

I just want to get a value from second row and column "Name". In this case I'll get value "Mike".
It's equal to query SQL:
"SELECT Name FROM Users WHERE Id=2"

I know that I can use ADO.NET, but in this case I must use SMO.

Can anybody help me?
QuestionRe: SMO Retrieve Table Record Pin
Eddy Vluggen28-Jan-13 3:21
professionalEddy Vluggen28-Jan-13 3:21 
AnswerRe: SMO Retrieve Table Record Pin
Sandeep Mewara28-Jan-13 3:22
mvaSandeep Mewara28-Jan-13 3:22 
AnswerRe: SMO Retrieve Table Record Pin
savbace28-Jan-13 3:40
Membersavbace28-Jan-13 3:40 
Questionhow can reporting in this Situation Pin
karimkpg26-Jan-13 2:38
Memberkarimkpg26-Jan-13 2:38 
AnswerRe: how can reporting in this Situation Pin
Sandeep Mewara26-Jan-13 6:02
mvaSandeep Mewara26-Jan-13 6:02 
QuestionQuery to concatenate multiple rows based on sequence in results set Pin
Alex Lush24-Jan-13 22:43
MemberAlex Lush24-Jan-13 22:43 
AnswerRe: Query to concatenate multiple rows based on sequence in results set Pin
Eddy Vluggen25-Jan-13 1:51
professionalEddy Vluggen25-Jan-13 1:51 
AnswerRe: Query to concatenate multiple rows based on sequence in results set Pin
Shameel25-Jan-13 3:20
professionalShameel25-Jan-13 3:20 
GeneralRe: Query to concatenate multiple rows based on sequence in results set Pin
Alex Lush25-Jan-13 3:30
MemberAlex Lush25-Jan-13 3:30 
AnswerRe: Query to concatenate multiple rows based on sequence in results set Pin
mmccarth25-Jan-13 5:21
Membermmccarth25-Jan-13 5:21 
QuestionSyntax error (Missing Operator) in Query expression ':0:1 Pin
IgaBaro23-Jan-13 14:40
MemberIgaBaro23-Jan-13 14:40 
AnswerRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
Mycroft Holmes23-Jan-13 15:02
professionalMycroft Holmes23-Jan-13 15:02 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
IgaBaro23-Jan-13 15:25
MemberIgaBaro23-Jan-13 15:25 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
PIEBALDconsult23-Jan-13 15:37
professionalPIEBALDconsult23-Jan-13 15:37 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
IgaBaro23-Jan-13 16:16
MemberIgaBaro23-Jan-13 16:16 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
PIEBALDconsult23-Jan-13 16:26
professionalPIEBALDconsult23-Jan-13 16:26 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
IgaBaro23-Jan-13 16:58
MemberIgaBaro23-Jan-13 16: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.