Comments on Microsoft Sql Server Tutorials: Check if a database or table exists using Sql Serv...

@Vagelis substitute the PRINT with a SELECT. Enjo...

2011-11-05T05:21:25.661-07:00

@Vagelis

substitute the PRINT with a SELECT. Enjoy =)

Ivano

Most Excellent, thank you. I hope it's clear ...

2010-09-08T15:32:24.932-07:00

Most Excellent, thank you. I hope it's clear to everyone that this is a query that you'd be running on the server itself, and that we who are running VB. code against the server are going to construct these as a query strings that we'd be running from a command object (or however you choose to run queries). This seems well suited to be made as a stored procedure, pass it the table name, perhaps object type and schema and have the result returned. I'll post that once I figure it out.
Sorry I'm contributing over two years after the rest of you...
Best Regards

hello i have a problem with those if statements in...

2009-11-07T02:11:09.574-08:00

hello
i have a problem with those if statements in sql server

i call that query with vb.net

IF OBJECT_ID ('hn.dbo.AWBuildVersion','U') IS NOT NULL print 'table exists' ELSE Print 'Table Does Not Exists'

and i reseave the message
the read try is not valid because it doesnt exist data

can anyone help??

Thank you very much

2009-02-18T01:39:00.000-08:00

Thank you very much

Very useful, you can also do this if youre running...

2009-01-23T05:24:00.000-08:00

Very useful, you can also do this if youre running across several db's in a cursor or something.

declare @db_name varchar(255)
set @db_name = 'db_test'
/*only run in dbs that have view*/
IF OBJECT_ID (@db_name+'.dbo.custom_count_dbm_mth2_vw','V') IS NOT NULL
Print 'do this'
ELSE
Print 'do nothing or something else'

Done this before, am having a blonde day so this w...

2009-01-23T05:22:00.000-08:00

Done this before, am having a blonde day so this was very helpful thanks!

Thanks for the information

2008-09-25T11:06:00.000-07:00

Thanks for the information

Thanks, I was also looking for the same thing. Th...

2008-07-05T20:12:00.000-07:00

Thanks, I was also looking for the same thing. Thank you.

thank you, this was very useful

2008-06-11T11:06:00.000-07:00

thank you, this was very useful