To change the default language of a login, you can use sp_defaultlanguage or

ALTER LOGIN sa WITH DEFAULT_LANGUAGE = British;

GO

You will need the alter permission on the Table on which your trigger is defined.

Please refer this:

http://msdn.microsoft.com/en-us/library/ms176072.aspx

I don't think you can change the Server language (May be the experts here can share more light on this).You can change it for individual logins.

PLease provide us with some sample data..

Thanks.

EXEC sp_configure 'default language', 23

RECONFIGURE

You can then check:

SELECT @@language, @@langid

If your database is in full mode, u do not need to change it back to simple. You could just do this

Run a CHECKPOINT

Back up the database

BACKUP LOG with...

Do u think that getting a certification is more important than the Job experience..

Thank you Gail i'll keep that in mind. Thank you for ur valuable suggestion

Thanks Gail

I'll read up more on this and do some tests on our test server before using it in live systems.

for e.g in the below query what does the merge join do? How does it optimise the query/join? What if there are three or four different joins; what will merge...

select datepart(month,@date),sum(Noofstudents)

from temp1

group by datepart(month,@date)

Yes this will work as well;

select COALESCE (currencyold,currencynew) as currency

from tablename

I thought SQL_PRODIGY wanted a case statement but this is better.

Nice one Laura.

Correction:::

select currency=

case when currencyold is null then currencynew

when currencynew is null then currencyold

end,

balance=

case when balanceold is null then balancenew

when balancenew is null then balanceold

end,

publicidentifier

from tablename

select currency=

case when currencyold is null then currencynew

when currencynew is null then currencyold

end,

balance=

case when balanceold is null then balancenew

when currencynew is null then...

You can usee the following script which will reorganise or reindex the tables accordingly. You can create a job using this or use the maintenance plan.

-- Ensure a USE ...