I don't have Italian Windows / Sqlserver settings, so it's a bit of guessing, but ...

I think the problem could be in the dot in the timepart.

Did you try...

In the Netherlands the tax credit is EUR 6000 (ca $8000) for a Prius !!

But we pay much more tax on our cars. And also a lot of tax on gas ($8...

@david-2:

OK, you are right.

The smalldatetime values still  has a time part, set to 0 (00:00:00.000).

If you want the day only, without the time part you could use:

convert(char(8), getdate(), 112)

There are other solutions, but I like this one.

The purple color is back again. Thank you for the fast implementation.

You may use "convert" to get a date in the new format.

e.g. 

SELECT convert(CHAR(8), getdate(), 112) 

(gives 20070122)

When you want the date quoted then you could use:

SELECT quotename(convert(CHAR(8), getdate(), 112),'''')

(gives '20070122')

Mohammed, thank you for your help.

I'll look in BOL.

Mohammed, thank you for your answer.

I thought that maybe there is a "hidden" sql agent somewhere, and that I didn't found the way to activate the sql agent.

So I have to...

Found out what my problem was (it's solved now): the correct codec wasn't installed. The commercial has another format then the movie. Thus, after the known format of the commercial,...

I have also problems viewing the presentations. It stops after the commercial. I tried more then once.

I'm sick of looking at a man buying sanitary napkins for his daughter,...

At a beginners level you could look at:

http://www.w3schools.com/sql/default.asp

It's regular Sql, not TSQL, but for a beginner there is not so much difference.

BOL is always good, but it is not so easy...

Chinn,

Thank you for your answer.

My problem is that after the commercial I see nothing. I waited for 20 minutes, and nothing hapend (I have fast internet, the commercial is loaded in...

As a software developer I will use SQL Server 2005 Express for a update of a Paradox database from 1998 with 30 users (its amazing that this is possible). In this...

I remember the days we had to stay inside. The Tsernobyl cloud came over. Nothing to see, but it was dangerous outside (as it was inside the house, but they...

OK, that is precise what I meant with my second solution.

But it gives a problem when the string is empty, or contains no backslash.

So,...