You'd get better help quicker if you'd follow the methods in the article in the link in my signature below... 😉

cuteprabakar (9/27/2008)

---

Dear All, I need help TO design DB that will contain the following tables. I am using ASP in the frontend

USERS

[userid] [int] NOT NULL,

[password] [int] NOT NULL,

[Fullname] [nvarchar] (50)...

Not sure if it's possible, but it would also be really cool if we could have discussions on SQL Server about articles not on SQL Server. In other words,...

I'll...

The OP must like porkchops...

Not sure what you mean, but if you want to pass an array to SQL, then the following article will help... covers passing of 1, 2, and 3 dimensional arrays...

http://www.sqlservercentral.com/articles/T-SQL/63003/

Matt Miller (9/27/2008)

---

Any more references like these and you're going...

Yeah, I know... but I just can't bring myself to programming by exception. I'd rather know the correct answer up front and take...

You bet, Neela.

I'm not sure who gave you the requirements on these file names, but the yyyymm format will serve you much better and for much longer.

Old gaming trick... when you can't move, change color... Temp Table...

sivavardhan (9/26/2008)

---

Use the below script to find whether the database is there or not in a server

if exists

(select name from master..sysdatabases where name like '%abc%')

Begin

...

vyas (9/24/2008)

---

SET QUOTED_IDENTIFIER OFF

IF EXISTS(select * FROM master..sysdatabases where [name] ='pubs')

begin

use pubs

...

Stuff it...:P seriously... the STUFF solution that Chris Morris posted will do the trick just fine.

Heh... thanks for posting your solution. Sometimes the problem just boils down to "must look eye." 🙂