I don't know... I hate them both...

I still like

SELECT

fieldname = a.field1,

fieldname2 = a.field2

FROM

table1 a

I know it's not perfect SQL syntax... but the = sign just feels more readable to...

I hope you don't mind... but I printed that post out in a large font and hung in my cube... the next time a programmer...

Sergiy (5/29/2008)

---

Those cursor procedures are used by ODBC drivers when you're addressing (updating, inserting) more than 1 row.

Because ODBC driver is a normal procedural program it cannot perform set-based data...

Can...

That's just another possible cause right? Because every time I track down an sp_cursoropen call... it's coming from client machines and terminal servers that don't have SQL server installed.

Ola Hallengren (5/29/2008)

---

I have done a trace on this. I have a Maintenance Plans that is doing a full backup of all user databases. I'm on version 9.00.3054.00. This is...

Lynn Pettis (5/20/2008)

---

I disagree with statement #2. SQL is a programming language. Yes, it is a Data Manipulation Language, but so is COBOL, FORTRAN, Pascal, Modula-2, Ada, C,...

Lynn Pettis (5/20/2008)

---

So, based on this discussion ALL programming languages should then throw an error if there is a truncation occuring due to attempting to pass a string value that...

Ryan Riley (5/20/2008)

---

mtassin (5/20/2008)

---

Try this one

Create Table #temp_test(testval varchar(10))

INSERT INTO #temp_test values('1234567890ABCD')

SELECT * FROM #temp_test

By your reasoning, I should have 1234567890 as the output.

In the case I have provided, SQL...

Ryan Riley (5/20/2008)

---

This is shocking to me. I don't mean to pick on you, Jon, but 1) why would you want an error--or even a warning--telling you something you should...

marklegosz (5/20/2008)

---

I think there are 2 points to this question:

1) The fact the function did not throw an error about the input being truncated; and;

However you should not be allowed...

This is by far one of the best articles I've read on just about any subject.

As a former programming student who went network admin and then hybridded into DBA, let...

Not 100% sure I follow,

1. You have an application that drops csv files to a specific folder on an ad-hoc type of basis

2. You need to read those csv's...

So basically store the queries as

INSERT INTO #contacts

SELECT [databasename],* FROM [databasename].dbo.contacts WHERE lastname = '_TRAINING DATABASE_'

UNION ALL

and just append all the SELECTS into a single statement?

I can see how...

Just remember that CONTAINS, CONTAINSTABLE, FREETEXT, and FREETEXTTABLE all require that Full Text Indexing is enabled and configured for the tables you're querying. 🙂