Click here to Skip to main content
15,877,567 members
Home / Discussions / Database
   

Database

 
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 
AnswerRe: How to query all of the tab_name in the same database Pin
GuyThiebaut10-Oct-07 5:21
professionalGuyThiebaut10-Oct-07 5:21 
Hi,

I created a function to check if a table exists, as I need to check for this sort of thing frequently.

Here is the function code:

<code>
CREATE function dbo.DoesObjectExist(@Name varchar(200), @Type char(1))
returns varchar(7)

begin
declare @Result varchar(7)

if exists (select * from sysobjects
where name = @Name
and xtype = @Type)
	select @Result = 'present'
else	
	select @Result = ''

return @Result
end


This is how you check if the OffVansQtyOrdered table exists using this function:

<code>
if dbo.DoesObjectExist('OffVansQtyOrdered','u') = 'present'


I hope this is of help...



You always pass failure on the way to success.

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 
GeneralRe: problem in a tipical query(plzzz help me) Pin
Arihant rathi10-Oct-07 0:28
Arihant rathi10-Oct-07 0:28 

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.