Click here to Skip to main content
14,975,931 members
Home / Discussions / Database
   

Database

 
GeneralRe: Create a trigger Pin
Wendelius18-Aug-11 19:18
mveWendelius18-Aug-11 19:18 
AnswerRe: Create a trigger [modified] Pin
Shameel18-Aug-11 23:03
professionalShameel18-Aug-11 23:03 
QuestionSQL Query From Query Results Pin
Kyudos18-Aug-11 14:36
MemberKyudos18-Aug-11 14:36 
AnswerRe: SQL Query From Query Results Pin
Mycroft Holmes18-Aug-11 15:04
professionalMycroft Holmes18-Aug-11 15:04 
GeneralRe: SQL Query From Query Results Pin
Kyudos18-Aug-11 15:22
MemberKyudos18-Aug-11 15:22 
GeneralRe: SQL Query From Query Results Pin
Kyudos18-Aug-11 18:34
MemberKyudos18-Aug-11 18:34 
GeneralRe: SQL Query From Query Results Pin
Mycroft Holmes18-Aug-11 20:38
professionalMycroft Holmes18-Aug-11 20:38 
GeneralRe: SQL Query From Query Results Pin
Kyudos18-Aug-11 22:07
MemberKyudos18-Aug-11 22:07 
Mycroft Holmes wrote:
You can use a sub select but it makes no real difference, why do you not want to
used a table variable?


Crappy reasons. Our database front end program has an advanced option to execute user entered queries - it essentially only allows you one SQL statement, and I don't want to encourage users who only think they know what they are doing to start creating their own tables. And I'm especially not fgoing to let them DROP tables! Big Grin | :-D

So I was wondering if I could get this done in one SELECT statement.
GeneralRe: SQL Query From Query Results Pin
Mycroft Holmes18-Aug-11 22:19
professionalMycroft Holmes18-Aug-11 22:19 
Questionplz brack my licence Pin
saqibali211918-Aug-11 8:08
Membersaqibali211918-Aug-11 8:08 
AnswerRe: plz brack my licence Pin
Mycroft Holmes18-Aug-11 20:41
professionalMycroft Holmes18-Aug-11 20:41 
QuestionCannot start MSSQLSERVER Pin
Blikkies17-Aug-11 22:02
professionalBlikkies17-Aug-11 22:02 
AnswerRe: Cannot start MSSQLSERVER Pin
Mycroft Holmes17-Aug-11 23:02
professionalMycroft Holmes17-Aug-11 23:02 
GeneralRe: Cannot start MSSQLSERVER Pin
Blikkies18-Aug-11 3:59
professionalBlikkies18-Aug-11 3:59 
GeneralRe: Cannot start MSSQLSERVER Pin
jschell18-Aug-11 12:56
Memberjschell18-Aug-11 12:56 
AnswerRe: Cannot start MSSQLSERVER Pin
Corporal Agarn18-Aug-11 2:02
professionalCorporal Agarn18-Aug-11 2:02 
GeneralRe: Cannot start MSSQLSERVER Pin
Blikkies18-Aug-11 3:59
professionalBlikkies18-Aug-11 3:59 
AnswerRe: Cannot start MSSQLSERVER Pin
Wendelius18-Aug-11 6:26
mveWendelius18-Aug-11 6:26 
GeneralRe: Cannot start MSSQLSERVER Pin
Blikkies18-Aug-11 21:38
professionalBlikkies18-Aug-11 21:38 
QuestionOracle Collection Objects Pin
lionelcyril17-Aug-11 21:22
Memberlionelcyril17-Aug-11 21:22 
AnswerRe: Oracle Collection Objects Pin
Wendelius18-Aug-11 8:10
mveWendelius18-Aug-11 8:10 
GeneralRe: Oracle Collection Objects Pin
lionelcyril18-Aug-11 8:21
Memberlionelcyril18-Aug-11 8:21 
AnswerRe: Oracle Collection Objects Pin
Wendelius18-Aug-11 8:32
mveWendelius18-Aug-11 8:32 
GeneralRe: Oracle Collection Objects Pin
lionelcyril18-Aug-11 8:37
Memberlionelcyril18-Aug-11 8:37 
GeneralRe: Oracle Collection Objects Pin
Wendelius18-Aug-11 8:56
mveWendelius18-Aug-11 8:56 

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.