Click here to Skip to main content
15,936,940 members
Home / Discussions / Database
   

Database

 
GeneralRe: Calling reports from server logged in user wise Pin
MSinha10-Oct-07 5:29
MSinha10-Oct-07 5:29 
GeneralRe: Calling reports from server logged in user wise Pin
pmarfleet10-Oct-07 5:37
pmarfleet10-Oct-07 5:37 
QuestionCreateQueryDef() pause needed Pin
new_phoenix10-Oct-07 3:40
new_phoenix10-Oct-07 3:40 
AnswerRe: CreateQueryDef() pause needed Pin
DQNOK10-Oct-07 5:32
professionalDQNOK10-Oct-07 5:32 
GeneralThere has got to be a more elegant way to do this... Pin
new_phoenix10-Oct-07 10:13
new_phoenix10-Oct-07 10:13 
QuestionHow to query all of the tab_name in the same database Pin
nibabug10-Oct-07 1:16
nibabug10-Oct-07 1:16 
AnswerRe: How to query all of the tab_name in the same database Pin
Krish - KP10-Oct-07 1:21
Krish - KP10-Oct-07 1:21 
AnswerRe: How to query all of the tab_name in the same database Pin
Virendrak10-Oct-07 2:25
Virendrak10-Oct-07 2:25 
IF EXISTS (SELECT 1
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE='BASE TABLE'
AND TABLE_NAME='Student')
SELECT 'Student exists.'
ELSE
SELECT 'Student does not exist.'

-- or

SELECT * FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME='Student'

-- or

SELECT * FROM sysobjects WHERE name='Student'

--OR
IF OBJECT_ID('Student') IS NOT NULL
PRINT 'Student exists.'
ELSE
PRINT 'Student does not exist.'

Never Think That You Have Failed Instead Always Think That u hav Better Chance Next Time...

AnswerRe: How to query all of the tab_name in the same database Pin
GuyThiebaut10-Oct-07 5:21
professionalGuyThiebaut10-Oct-07 5:21 
QuestionRe: How to query all of the tab_name in the same database Pin
nibabug10-Oct-07 14:11
nibabug10-Oct-07 14:11 
AnswerRe: How to query all of the tab_name in the same database Pin
GuyThiebaut10-Oct-07 21:16
professionalGuyThiebaut10-Oct-07 21:16 
Questionproblem in page indexing in Grid View Pin
ahmed_fci200610-Oct-07 0:44
ahmed_fci200610-Oct-07 0:44 
QuestionLast value in a Table Pin
BINOVAR10-Oct-07 0:18
BINOVAR10-Oct-07 0:18 
AnswerRe: Last value in a Table Pin
Aavesh Agarwal10-Oct-07 0:32
Aavesh Agarwal10-Oct-07 0:32 
GeneralRe: Last value in a Table Pin
Aavesh Agarwal10-Oct-07 0:36
Aavesh Agarwal10-Oct-07 0:36 
AnswerRe: Last value in a Table Pin
Paddy Boyd10-Oct-07 0:56
Paddy Boyd10-Oct-07 0:56 
GeneralRe: Last value in a Table Pin
Paddy Boyd10-Oct-07 1:11
Paddy Boyd10-Oct-07 1:11 
GeneralRe: Last value in a Table Pin
BINOVAR10-Oct-07 1:09
BINOVAR10-Oct-07 1:09 
GeneralRe: Last value in a Table Pin
pmarfleet10-Oct-07 2:12
pmarfleet10-Oct-07 2:12 
QuestionQuery regarding Trigger Pin
Aavesh Agarwal9-Oct-07 23:37
Aavesh Agarwal9-Oct-07 23:37 
QuestionSwap the columns values [modified] Pin
Aavesh Agarwal9-Oct-07 22:55
Aavesh Agarwal9-Oct-07 22:55 
AnswerRe: Swap the columns values Pin
Joe9-Oct-07 23:26
Joe9-Oct-07 23:26 
GeneralRe: Swap the columns values Pin
Aavesh Agarwal9-Oct-07 23:28
Aavesh Agarwal9-Oct-07 23:28 
Questionproblem in a tipical query(plzzz help me) Pin
Arihant rathi9-Oct-07 20:57
Arihant rathi9-Oct-07 20:57 
AnswerRe: problem in a tipical query(plzzz help me) Pin
joemonvarghese9-Oct-07 22:32
joemonvarghese9-Oct-07 22:32 

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.