Are you trying to use a linked server, or trying to login into a local server? If the last one, is the sa account enabled?

Probably because they were never executed at all.

The compiler noticed a syntax error in your script, so it gives an error straight away.

This thread lists of few possible solutions:

http://stackoverflow.com/questions/63291/sql-select-columns-with-null-values-only

The older versions of Excel also don't play nice...

jamie 82947 (8/11/2013)

---

Ok so I can get the 'CSV Splitter' working but that only does a string. I need to read the data in from a table which could have...

When you save a query, it is saved as a .sql file on your hard drive.

This is typically in the My Documents\SQL Server Management Studio folder. You can organise your...

You need to join the student table with the absence table, do a count on the absence date and divide this by 10.

DECLARE @minDate DATE = '2010-01-01';

DECLARE @maxDate DATE = '2013-04-01';

SELECT DATEADD(mm,6 * number,@mindate) AS ResultDate

FROM master.dbo.spt_values

WHERE type = 'P' AND DATEADD(mm,6 * number,@mindate) < @maxDate

ORDER BY number asc;

I used...

Too easy 🙂

Simply by thinking "Express won't have any feature that standard hasn't", you could already devise the correct answer.

Great question to start the week!

Jeff Moden (8/9/2013)

---

My recommendation would be to get into SSMS and press the {f1} key. There's a whole lot of...

Mark-101232 (8/9/2013)

---

Koen Verbeeck (8/8/2013)

---

Probably because Oracle is a sucky DB engine who evaluates the expression row by row, while SQL Server evaluates them all at the same time, resulting in...

Why don't you post your code, so we know what we're dealing with.

Check if you are connecting to the right server.

Not an expert in bcp format files, but you can use a query in BCP, so I would do the formatting there.

You need to specify the server as well in your bcp command line.