Questions tagged as 'sql-server'

Tagged questions
1
answer

DateTime where do you get the format, depends on the language? [closed]

I am working with windows server with its English version, but on the client system it takes the date format in "M / d / yyyy". Already change the language and date format of the server but it is not changed. Any ideas?     
asked by 26.04.2017 / 16:31
1
answer

How to get selected values in an ASP MVC ListBox?

Greetings, I have a problem with my code in Asp Mvc 5, I have several related models and I have a Listbox that filters the values of a foreign key, but when I try to save it, only a single value is saved, not all the selected ones, and that ulti...
asked by 06.03.2017 / 16:40
1
answer

SSIS: OleDB to Excel problem in a varchar column (1000)

When exporting from a SQL database to Excel in SSIS, I have a problem in a column in SQL that is VARCHAR(1000) , I tried to pass it to Unicode_Ntext , but I get the error:    [Excel Destination [84]] Error: An error occurred while...
asked by 22.02.2017 / 22:31
0
answers

Problem with TransactionScope .Net SqlServer

Usually I use TransactionScope for my developments but in this case I find something strange. I have to update in the tables of Order headers and order lines the delivery date when the user makes a reading of the barcode of the document in quest...
asked by 22.02.2017 / 08:09
1
answer

Replace tabs with commas in a .csv file

I have a .csv file that represents a table with 12931 entries. For example: ID A B C 1 9 hola despues de hola va una coma 383 2 8 esto es sin comas 383 3 2 hola los tabs en este campo son una coma estoy en B 383 We...
asked by 06.02.2017 / 18:33
2
answers

Considerations on using the JOIN in SQL Server 2008

I have a problem with its use. I have two tables in different databases, both tables are identical (same number and name of columns) and the smallest is included (all their records) in the original table. Both tables give me the same number o...
asked by 10.02.2017 / 21:59
1
answer

Show ID in Textbox C # [closed]

Companions I am developing a project in ASP.NET C #, the problem is that I want to show the ID in a textbox of my form, which is increasing one by one, I'm doing highs, lows, changes, for example when adding a new record shows the ID in the text...
asked by 15.02.2017 / 18:38
2
answers

Entity Framework 6 SaveChanges Extremely Slow

I am making an application in WPF, and I use Entity Framework v6.1.3 as ORM, database sql server 2012 as a database. The query is simple. Make an insert of 8 thousand records approximately, it takes me more than 15 minutes. What really takes...
asked by 02.02.2017 / 17:46
1
answer

How to create a Bacpac file to be restored in Azure using SQL 2008 and SQL 2012

I have tried to search and can not find anything to tell me how to do it. I have databases in SQL 2008 and SQL 2012. I need to generate Bacpac files so that they can be imported and restored in Azure. When I try to do it with SQL Manager I ge...
asked by 30.01.2017 / 20:07
1
answer

How to pivot 2 or more SQL Server columns?

I have queries that generate 2 temporary tables, which I need to obtain the total per center and break it down by installed and sold. The first query, creates a temporary table of the dates I need. This second query creates the queries and sa...
asked by 20.02.2017 / 17:42