Since I did not do the table structure legacy code I needed a quick and dirty solution - so I went with a dynamic SQL. Sign up to join this community. The best answers are voted up and rise to the top. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams?
Learn more. Asked 3 years ago. Active 2 years, 11 months ago. Viewed 87 times. I am working on a table that has 24 columns named pp1, pp Improve this question. Ilyes 1 1 silver badge 13 13 bronze badges. Are all 24 columns the same datatype? Add a comment. Active Oldest Votes. Improve this answer. Ilyes Ilyes 1 1 silver badge 13 13 bronze badges.
It can be done by performing a "no-op" update on the other columns. Michael Green Michael Green 22k 12 12 gold badges 44 44 silver badges 85 85 bronze badges. Thank you all for the answers and comments. Michael Green 22k 12 12 gold badges 44 44 silver badges 85 85 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook.
Sign up using Email and Password. Viewed times. Consider the date time column contains following values, Improve this question. Bibin Bibin 2 2 silver badges 9 9 bronze badges. This table is predefined by the client. Add a comment. Active Oldest Votes. Improve this answer. Sami Kuhmonen Sami Kuhmonen 28k 9 9 gold badges 57 57 silver badges 68 68 bronze badges. Here the day ,month and time is changing. Bibin so every value should have the day changed, but year and time as previously?
Day should be changed 14 , but year and time should be the same as the previously — Bibin. Bibin You're welcome. Please select the answer as accepted if it worked for you — Sami Kuhmonen. Ankit Bajpai Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.
Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science.
0コメント