Posts by Marcos Tulio • 33 points

• 0

  votes

  2

  answers

  697

  views

  Q: Problem renaming column in Sql Server table

  I needed to rename a column from a table in Sql Server and used the stored SP_RENAME system processor. I used it as follows: USE [meu_db] GO EXEC sp_rename '[dbo].[minhaTabela].[minhaColunaAntiga]',…

  sql sql-server stored-procedures

  asked 5 years, 4 months ago Marcos Tulio 33

• 0

  votes

  3

  answers

  65

  views

  A: How to join the score with the last word on the left?

  I assigned the variable and did cast. I tested it like this and it worked. a="Teste com valor d:" b=round((17.45*4.987),2) c=str(b) d=c + "%" print (a,d) Teste com valor d: 87.02% Maybe it’ll help…

  python python-3.x

  answered 5 years, 6 months ago Marcos Tulio 33

• 2

  votes

  1

  answer

  1343

  views

  Q: How to change 2 or more columns at the same time in Sql Server 2014? (ALTER TABLE/ALTER COLUMN)

  How do I change 3 columns at the same time in the SQL SERVER table? I want to change the COLLATION, but it could be something else. I tried to: ALTER TABLE dbo.SIX_POSTO ALTER COLUMN VIS_DS…

  sql sql-server

  asked 5 years, 6 months ago Marcos Tulio 33