Please enable / Bitte aktiviere JavaScript!
Veuillez activer / Por favor activa el Javascript![ ? ]
How in C# to change the values of cells in a column to the SQL table, increasing them 2 times? - bug-code.com Q&A

How in C# to change the values of cells in a column to the SQL table, increasing them 2 times?

0 like 0 dislike
102 views
Hello!
Please tell me how you can change all values (for example, by two times) of table column in database using C# (preferably) or Transact-SQL?
asked by | 102 views

1 Answer

0 like 0 dislike
One sql query
update `table` set `col`=`col`*2, where 1
PS written from memory so errors are possible
answered by
Welcome to Bug-code Q&A, where you can ask questions and receive answers from other members of the community.

24.8k questions

46.2k answers

0 comments

12.8k users

24,788 questions
46,220 answers
0 comments
12,825 users