Posts by Welricsson • 11 points

• 0

  votes

  1

  answer

  75

  views

  A: How to add a description in the column?

  Hi, Matheus. All right? I have no experience with First Migration, but maybe I can open up the possibilities. In SQL Server this type of information is stored in an Extended Properties table. In the…

  sql-server migrations

  answered 3 years, 4 months ago Welricsson 11

• 0

  votes

  1

  answer

  21

  views

  A: Sql server heritage in Procedure

  Hi, Gilmar. All right? At first you could check if creating indexes can improve the performance of your views, if you haven’t seen it yet. Another way to solve it is to materialize the data of the…

  sql sql-server procedure

  answered 3 years, 4 months ago Welricsson 11

• 0

  votes

  1

  answer

  42

  views

  A: How to insert multiple email addresses within one variable, in SQL?

  If you are using from version 2016 onwards SQL Server, just use the native function string_split. See below: DECLARE @email as NVARCHAR(max) SET @email =…

  sql sql-server variable-declaration

  answered 3 years, 4 months ago Welricsson 11

• 1

  votes

  1

  answer

  32

  views

  A: Error formatting ZIP with Format() function

  The function FORMAT accepts only numeric types and date types. You could do so: DECLARE @cep int = 23574510; SELECT FORMAT(@cep,'#####-###') AS [CEP]

  sql-server

  answered 3 years, 4 months ago Welricsson 11