I don't have access to my code right now, but I'll post a script later that will check a given directory for files that match a certain filename, with wildcards...

SanjayAttray (11/8/2010)

---

Isn't it funny that when you say order by 1, sql server assumes 1 as column and gives result order by column 1 but at the same time...

Nice question. I was a bit distracted by the select 1 from #table statement, but opted to choose for the error anyway.

Glenn (11/6/2010)

---

I'd like to pad an nvarchar field with trailing spaces to make the length a uniform 23. Is there anything

equivalent to what I do in excel as in...

Which version of SSMS do you use? (2000, 2005 or 2008 (R2))

Which version of SQL Server do you use?

Absolutely true.

But I'm pretty confident this is not a disaster situation, but an interview...

Resender (11/4/2010)

---

checking if the connections are available is the priority

the script to loop through all connection managers will help with that

see my boss claims the following

let say you have...

I guess you are using a script task here with VB.NET?

Try using the DirectoryInfo and FileInfo, you can use wildcards there.

In my opinion, if you don't know the answers or don't know where to find the answers, you don't...

Throw the database away and start with a clean slate.

Kyle Freeman (11/4/2010)

---

What do you recommend for study materials for

70-432

70-433

70-450

70-451

And I may look into the BID certifications as well....

I believe way back when I took the tests for 7.0,...

tilew-948340 (11/4/2010)

---

My engish beeing what it is, I did also not get the differance between the first two answers, but that's ok. I learned something new and it is the...

Nice question, but since this is an international website, it was better to include some information about the server settings of the set-up. Or include some statements like SET DATEFORMAT.

I...

Good question, although it was more about convert than about ceiling.

A link to the msdn page for convert and decimal:

http://msdn.microsoft.com/en-us/library/ms187928(SQL.90).aspx (convert)

http://msdn.microsoft.com/en-us/library/ms187746.aspx (decimal/numeric)

The last page describes the gotcha of this question...

Nice question, thanks.