Activity overview
Latest activity by jnet
To Ben Pinchen:
I have too many problems with datetime format, I use Italian language, but I think it may resolve with change of the script, for example, from:
UPDATE [dbo].[aspnet_Membership]
SET [LastLoginDate]='2008-09-25 07:22:33.920'
WHERE [UserId]='1d6436d0-ac6d-4f1f-8cfc-a78308746c58'
to:
UPDATE [dbo].[aspnet_Membership]
SET [LastLoginDate]=CONVERT(datetime, '2008-09-25 07:22:33.920', 121)
WHERE [UserId]='1d6436d0-ac6d-4f1f-8cfc-a78308746c58'
If SQL Data Compare will write this script for me, I will continue without copy, modify and execute of script.
Thank you. / comments
To Ben Pinchen:
I have too many problems with datetime format, I use Italian language, but I think it may resolve with change of the script, for example, from:
UPDATE [dbo].[aspnet_Membership]
SET ...