Lynn Pettis (5/9/2008)

---

So, would you improve the question, or the answers provided? To take this into an interview environment, I would be looking to see if someone knew that...

I believe you need to have it wrapped in quotes or double quotes.

SET @ExportLocation = '''C:\SQLData\Exports\Sales-' + @ExportDate+ '.xls'''

or

SET @ExportLocation = '"C:\SQLData\Exports\Sales-' + @ExportDate+ '.xls"'

I wish I did know more about IIS, but I don't. I do know, however, that IIS didn't wake up one morning and decide that Windows Authentication just wan't good...

Jack Corbett (5/2/2008)

---

Tom Garth (5/2/2008)

---

Everything you ever wanted to know about working with Excel using T-SQL can be found at this link.

http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/

Will someone PLEASE tell me how to properly post...

Everything you ever wanted to know about working with Excel using T-SQL can be found at this link.

http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/

Thanks for the answer Jack:Will someone PLEASE tell me how to properly post...

It's nice to see that I'm not the only one who is avoiding doing any real work this morning.

TGIF

magarity kerns (5/2/2008)

---

I never 'select *'; whenever I want the complete contents I right click the table name and pick 'open table'. This has the added benefit of the...

Michael Valentine Jones (5/1/2008)

---

This was my favorite solution from the thread Peso linked to.

declare @ int set @=0while @<100begin set @=@+1print left(@,sign(@%3*@%5)*3)+

left('Bizz',4-sign(@%3)*4)+left('Buzz',4-sign(@%5)*4)end

Short and easy to understand 🙂

Here is a...

One thing to note: If you have a 32 bit app that you want to run on the server's OS, and if it uses ODBC, you will want to dig...

WOW! 21 pages as of this post. Stimulating. I got here late and had to stop reading after page 9. I thought i would throw in another approach that I...

schumi (4/30/2008)

---

I don't think the order of creation of the triggers has any effect on the triggering order, at least not for SQL server, they say it is random. I...

Stephen,

Interesting article. Thanks.

Ian,

I've been using QA for a long time and didn't know that trick. Thanks a bunch.

This is why I read the posts after an article.

a7mad.sayed (4/29/2008)

---

By default triggers on the same table for one action (Update as this example) will be executed in order of creation.

If triggers created in this order :

TRA

TRB

TRC

Then execution...

Ken Gaul (4/29/2008)

---

But nested triggers would be triggers on different tables.

So a trigger on orderdetail that updates the order header totals which has a trigger that goes and modifies some...

Why not commit after each row. Not only that, but drop the connection and get a new one for the next insert. You probably won't notice any performance difference, but...