of course. oops!

themancorp (6/24/2008)

---

Hi all,

I've got to populate a table in a DB in a particular language. This language can be deciphered from finding the most popular language used by a set...

SELECT

COUNT(*) AS TotalRows

,COUNT(case when Status='P' then 1 else 0 end) AS Present

,COUNT(case when Status='A' then 1 else 0 end) AS Absent

FROM Attendance WHERE sid=studentnumber

why do you care if the output is different? sqlcmd still executes the script right?

some good resources here for large databases:

http://sqlcat.com

smells like a parameter sniffing problem.

get it? 🙂

if you want to automate the generation of scripts from the cmd line, I wrote a tool to do it. it's open source on codeplex:

http://www.codeplex.com/scriptdb

I would say so. much ado about nothing. 🙂

Another reason people haven't mentioned is code reuse.

In our shop we have a library of helper functions that is used by all our managed components. We also...

nice that you found your query, but you should really use a source control system.

SqlSpec is a tool I wrote for documenting databases. It supports all major DBMS platforms, including SQL Server and Oracle.

for collecting windows and hardware information, there are lots of...

I use SqlSpec all the time, but I'm biased because I wrote it. 🙂

I don't understand your question.

SQLCMD is the replacement in 2005 for OSQL.exe if you are familiar with 2000 administration surely you know osql. sqlcmd is easy to learn...

if you have scripts that you want to run from a central location against many servers, you can use SQLCMD for that. It's very useful for that kind of...

what is the first transaction? is it a big delete or update? if so you can always do this in batches to minimize the size of a transaction.

for...