Posts by Marcos Tulio • 33 points
3 posts
-
0
votes2
answers697
viewsQ: 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]',…
-
0
votes3
answers65
viewsA: 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…
-
2
votes1
answer1343
viewsQ: 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…