Questions tagged as 'sql-server'

Tagged questions
2
answers

Doubt with cast sql server 2008

I have a sql query I want to bring the information PRECO_LIQUIDO is PRECO_LIQUIDO_PROMOCAO formatted as decimal using a cast decimal (12, 2) How could it be done, thank you select --calculo do desconto individual ((P.DESCONTO01 / 100 ) * P.P...
asked by 23.02.2016 / 17:32
1
answer

Create Table in SQL Server 2008

It is possible to create a CAIXA table which, for example, when putting CODIGO of product, pull DESCRIÇÃO automatic, being in the PRODUTOS ?? table     
asked by 08.03.2016 / 19:01
1
answer

Pulling SQL Server data using PHP

Hello everyone using the PHP code below I can insert rows into my SQL Server table: sqlsrv_query( $conn, "INSERT INTO usuarios (login, senha) VALUES ('new', 'mano')"); However, I would like to return some value and play in a text. I tried t...
asked by 30.04.2018 / 02:31
1
answer

How to insert a value into a copy of the table?

I'm doing a transfer from the table " Histo_Ficha_Controle " to " Cad_Espec_Teste ". The two tables contain the same fields to receive the information. When you copy from one table to another, I'd like to know if it's possible to ins...
asked by 12.04.2018 / 20:02
2
answers

Problem to send values of type 11.50 to SQL Server database

I have a formatting problem of values of type R $ when I send to the database 11.50 in the database it is of type 1150. This is the push button of the submit button for the database has a database management class cl_GestorBD private...
asked by 06.06.2018 / 15:50
1
answer

NODE.js Insert in MS SQL

I'm trying to run an INSERT on my MSSQL through my NODE.js server But it is not working. I believe it is not a connection problem because (as I will demonstrate at the end of the post) I did a select that worked. so I should be making some...
asked by 05.11.2018 / 22:07
1
answer

Can not find the interop type that matches the embedded [closed]

type 'Microsoft.Office.Interop.Excel.Application' . Are you missing an assembly reference? FileCopy("\Thulller\Sistema\ModeloAbertaFechada.xls", "\Thulller\Sistema\Financeiro\" + txtNomeDoc.Text + ".xls") Dim xlApp As Excel....
asked by 12.07.2016 / 15:38
2
answers

Table Relationship Doubt

Good morning I would like a help from how do I get two information in one table from another. I have a table of notes where I have the agent_id and ID_endereco, I want to get the agent name and the customer name in the table whose people field i...
asked by 02.12.2015 / 11:31
1
answer

Write float field in sql server with C #

I'm trying to do this, but I'm not sure how to do this, but I'm not sure how to do this. to float. Follow my code. SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.Comman...
asked by 12.09.2017 / 15:24
2
answers

Select separated by semicolons for xls

I have the following code: var cmd = @"SELECT mt.Id + ';' + mt.Nome + ';' + mt.Cidade AS Resultado FROM MinhaTable mt"; var objectContext = ((IObjectContextAdapter)db).ObjectContext; var resul...
asked by 08.09.2015 / 15:06