Click here to Skip to main content
12,396,146 members (60,733 online)
   

Database

 
AnswerRe: SQL Server windows authentication Pin
jschell29-Nov-12 8:09
memberjschell29-Nov-12 8:09 
GeneralRe: SQL Server windows authentication Pin
Chris Meech30-Nov-12 3:45
memberChris Meech30-Nov-12 3:45 
QuestionNeed help with a tricky MS SQL Query Pin
muya mwansa27-Nov-12 6:46
membermuya mwansa27-Nov-12 6:46 
AnswerRe: Need help with a tricky MS SQL Query Pin
Eddy Vluggen27-Nov-12 13:31
memberEddy Vluggen27-Nov-12 13:31 
Website wrote:
I only want to see results for users with the following userids '999209','helpdesk1','999339','helpdesk5','999827'

Even if they don’t have records in compuser.

"Want"? How about learning SQL, breaking the problem into smaller pieces?

..and no, it's generally not a good idea to have a server open like that; it's obvious that you're running Sql Server, and one can request a list of all the databases in there.

Ever heard of Bobby Tables[^]? "All input is evil until proven otherwise".
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]
They hate us for our freedom![^]

GeneralRe: Need help with a tricky MS SQL Query Pin
jschell28-Nov-12 8:43
memberjschell28-Nov-12 8:43 
AnswerRe: Need help with a tricky MS SQL Query Pin
Deepak Kumar1128-Nov-12 1:03
memberDeepak Kumar1128-Nov-12 1:03 
QuestionBest Approach For Designing Database Pin
AmbiguousName27-Nov-12 3:59
memberAmbiguousName27-Nov-12 3:59 
AnswerRe: Best Approach For Designing Database Pin
jschell27-Nov-12 13:13
memberjschell27-Nov-12 13:13 
AnswerRe: Best Approach For Designing Database Pin
Mycroft Holmes27-Nov-12 13:14
memberMycroft Holmes27-Nov-12 13:14 
AnswerRe: Best Approach For Designing Database Pin
Eddy Vluggen27-Nov-12 13:23
memberEddy Vluggen27-Nov-12 13:23 

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.


Advertise | Privacy | Mobile
Web02 | 2.8.160721.1 | Last Updated 23 Jul 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid