UPDATE tblDignosis_Test1 SET RnlSelTbSodium='115.0', RnlSelTbPotessium='3.4', RnlSelTbChloride='80.0', RnlSctTbValue='1.0', RnlSelTbSodium='117.0',
RnlSelTbSodium='120.0' WHERE ID = (SELECT ISNULL(MAX(ID),0) FROM tblDignosis_Test1)
Msg 264, Level 16, State 1, Line 1 The column name 'RnlSelTbSodium' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates
columns of a view, then the column name 'RnlSelTbSodium' may appear twice in the view definition.
Remove duplicate coloumns in Update Statement.....
Now i getting this error, so can any give me solution or method which check if string contains or exixst(RnlSelTbSodium) like that so can compare and check it out or better solution.
bhargav5126
Member
153 Points
71 Posts
Remove duplicate coloumn in Update statement
Feb 27, 2012 11:28 AM|LINK
UPDATE tblDignosis_Test1 SET RnlSelTbSodium='115.0', RnlSelTbPotessium='3.4', RnlSelTbChloride='80.0', RnlSctTbValue='1.0', RnlSelTbSodium='117.0', RnlSelTbSodium='120.0' WHERE ID = (SELECT ISNULL(MAX(ID),0) FROM tblDignosis_Test1)
Msg 264, Level 16, State 1, Line 1
The column name 'RnlSelTbSodium' is specified more than once in the SET clause. A column cannot be assigned more than one value in the same SET clause. Modify the SET clause to make sure that a column is updated only once. If the SET clause updates columns of a view, then the column name 'RnlSelTbSodium' may appear twice in the view definition.
Remove duplicate coloumns in Update Statement.....
Now i getting this error, so can any give me solution or method which check if string contains or exixst(RnlSelTbSodium) like that so can compare and check it out or better solution.