Posts by Douglas • 63 points
4 posts
-
-1
votes1
answer77
viewsA: Dynamic background image
Declare in style. Example: <div style="background-image:url('{{ produto.nom_pathimagem }}')"></div> ;)
-
-3
votes1
answer3754
viewsA: ERROR 1264: 1264: Out of range value for column 'Cpf' at Row 1 SQL Statement
Your mistake was creating columns as Int and trying to write varchar. Try removing quotes from Cpf and cep: insert into pessoas values (04496332780, 'João da Silva', '25-11-1969', 'Rua Antônio…
-
2
votes1
answer531
viewsA: Pivot T-SQL Dynamic Sequential
I believe this is not the best way, but I decided to create a temporary table with the data of the course table by adding a column with a sequentially generated number i++ using the following…
-
5
votes1
answer531
viewsQ: Pivot T-SQL Dynamic Sequential
Breaking my head here to create a proc using pivot for this transformation: There is the possibility? *Using sql server 2008R2 EDIT: CREATE TABLE #Teste5 (name VARCHAR(50),message…