clicking "Debug" instead of "Execute" more times than I can count.

since you mentioned textcopy, here's pair of procedures to help you use it a little easier. I had this saved in my snippets.

In TSQL, you will have to loop thru...

Kwisatz78 (10/18/2010)

---

Hi all - Can anyone tell me how I can be informed about new releases for my versions of SQL. I am wanting to stay on top of...

lots of things to change there;

get rid of the old ansi join syntaxes...

get rid of the deprecated *= joins

adding the logic to split the string into a table

minor syntax...

GilaMonster (10/16/2010)

---

Why on earth are you looking for this? This has all the signs of someone trying to get around a keyword blacklist, maybe SQL injection, maybe code standards, etc.

Why...

a single record? no...the TRUNCATE TABLE [TABLENAME] command will delete all records in a table. so that deletes records...

no you cannot. backups are forward compatible, but not backwards compatible...meaning SQL 7 could restore a backup from version 6.5, but not any backups from 2000/05/08.

instead you'll want to...

i think your confusing parent-child relationships;

businesswise, the students and the table associated to them are the key/primary table.

information about the parents may or may not be available, so the table...

when you do a backup that does not include the WITH INIT clause, the new backup is appended to the same physical file. So after two...

I'm nearly the same winston; the only info that is in the master database that is special to me is logins, and I've created a script that pulls those out...

AFAIK there is no issues with leaving print statements in place; I've never seen or heard of an application suffering due to print statements.

even from an application you can read...

this is inside a procedure, right?

is @TodaysDate a parameter with a default of NULL?

if that's true, I'm thinking parameter sniffing is the problem, and a bad execution plan is being...

your query is good, all you need to do is change the ORDER BY in order to get it in the desired visual representation.

order by category,price desc;

I've gotten a Gmail account to work just fine; they use an alternate port for SMTP, but the rest was a typical setup:

in simple mode, the log would only have uncommitted transactions in it, right?

could there be a developer or some process that is starting a transaction, but never issuing the COMMIT?...