Skip to main content
Database Administrators

Return to Answer

Formatting
Source Link
Paul White ♦
Paul White ♦
  • 96.2k
  • 30
  • 442
  • 692

How about this:

UPDATE [dbo].[MyTable] SET [ToDateTime] = [ContainedData] WHERE aid = 123 and pid = 2 and isdate([ContainedData] ) = 1

UPDATE [dbo].[MyTable] SET [ToDateTime] = [ContainedData] WHERE aid = 123 and pid = 2 and isdate([ContainedData] ) = 1

How about this:

UPDATE [dbo].[MyTable] SET [ToDateTime] = [ContainedData] WHERE aid = 123 and pid = 2 and isdate([ContainedData] ) = 1

How about this:

UPDATE [dbo].[MyTable] SET [ToDateTime] = [ContainedData] WHERE aid = 123 and pid = 2 and isdate([ContainedData] ) = 1
Source Link
DThompson
DThompson
  • 21
  • 1

How about this:

UPDATE [dbo].[MyTable] SET [ToDateTime] = [ContainedData] WHERE aid = 123 and pid = 2 and isdate([ContainedData] ) = 1