Just duplicate the inner quotes:

'The child''s cereal is too warm.'

note: '' is not double quotes (") is two single quotes(')

Cheers,

use the Convert function:

select convert( char(6), getdate(), 112)

Cheers,

Sergiy,

In my trigger code there is no need for a while loop because I am using an stored proc (have a look at it) which guards the last available Id to be...

I would like to see if you check for Dateformat on all your SPs or if like the rest of us simply use standards so that when those values are to...

Cursor?

Create Trigger...

Declare @cnt int, @nextID int

Set @Cnt = @@rowcount

exec sp_GetNextID 'TableName', @cnt, @nextId out

-- Now use your same insert into...

1. You are not serious are you

2. That will set a lock on that table for the duration of the insert statement

And by the way if somebody change DATEFORMAT inside their stored procedure is up to them to handle it inside that scope the outer scope will be unaffected

Personally I use ISO format for character dates and you won't need the explicit conversion at all

TEST:

create table test

(

col1 datetime

)

set language 'British'

insert into test(col1) values ('20051011')

set language  'us_english'

insert into test(col1)...

Jaime, IT IS about the language!!!  

if you are trying to use sp_setdefault language you probably need to disconnect and connect after each call to that procedure