Questions tagged as 'sql-server'

Tagged questions
0
answers

Upload photo from Datagridview and switch to picturebox C #

I'm having a hard time getting my photo taken and showing it in PictureBox My scenario is as follows: I have a Registration Form that inserts the data and A Form that performs the search of the record that is displayed in a DataGridView; W...
asked by 10.08.2018 / 18:23
1
answer

Versioning of Procedure

I'm having a bit of a conceptual doubt. I am currently working on a project where I will have to version the calls from some api's. For example: Urls: /api/V1.0/Chamados/1220 /api/V1.5/Chamados/1220 The difference between the two c...
asked by 17.07.2018 / 23:21
0
answers

Id jumping 1000 Sql server 2014 (localDB)

In my application a few times when I'm going to add some data to the database, the ID jumps to 1000 units. I found some solutions, but they do not work for me because I use EF6 with code-first and my intention is to install the application wi...
asked by 27.08.2018 / 16:35
1
answer

UPDATE with multiple records from another table

I have a T1 table where I have ID . I have a T2 table where it gets the ID_T1 ( Foreign Key ) of T1 . I have a T3 table where it gets the ID_T1 ( Foreign Key ) of the T1 and the ID_T2...
asked by 11.07.2018 / 15:52
1
answer

Multiple rows in a Sql Server column

I have a problem where I need to merge the query return into two tables in a single row. I thought about using PIVOT but could not because of INNER JOIN . The query looks like this: SET LANGUAGE us_english; SELECT CONVERT(V...
asked by 04.07.2018 / 14:16
0
answers

Perform sorting by a given field of a given table

I have the following syntax The instruction below performs the ordering by the Lot Number field of the Batch var lvmLotes = db.Lotes.ToList () Where (x => x.DataAbate.Date == Search) .OrderBy (x => x.Library); p> I need to cha...
asked by 19.06.2018 / 15:20
1
answer

How to Generate NFe / NFC-e / CF-e / CT-e Key Verifier Digit [closed]

How to calculate the NFe Key Check Digit? For example, what is the check digit of the Key with 43 positions: '2411050954052500019455001000000709124205076'     
asked by 07.06.2018 / 19:20
0
answers

Application wpf with entity framework does not work on another machine

I have a wpf application with entity framework and sql server express ... it works perfectly on my pc, but when I try to install on another computer it does not work ... the application does not create the database with the frst code of the enti...
asked by 05.06.2018 / 01:49
1
answer

OPENROWSET - How to assign a variable in place of the file name to open?

I make this command and it's true: SELECT * FROM OPENROWSET( 'Microsoft.ACE.OLEDB.12.0', 'Excel 12.0 Xml;Database=\00.000.00.0000\Arquivos\TI\Arquivos2203408.xlsx;HDR=YES', 'SELECT * FROM [Rateio$]'); How can I put a variable in place...
asked by 16.05.2018 / 19:48
1
answer

Connect MS SQL to PGADMIN

Hello, good afternoon! I need to know if there are any tools, scripts or anything else where I can have the following scenario: I have an MS SQL database however I need to manipulate it through pgAdmin (postgres). Cnosegui do the invers...
asked by 15.05.2018 / 21:33