Questions tagged as 'sql-server'

Tagged questions
0
answers

Hibernate, JPA and SQL Server ERROR

I can not upload my application. Below the stack, persistence and pom. Stack 22:25:32.131 [main] ERROR o.h.tool.hbm2ddl.SchemaExport - HHH000231: Schema export unsuccessful java.lang.UnsupportedOperationException: The application must suppl...
asked by 27.02.2016 / 02:29
7
answers

Best data type to work with money?

I'm developing a project for commercial automation, using PAF-ECF and everything else. What would be the best data type to work with SQL Server and C # for money issues? Especially in relation to rounding and truncations. I imagine the bes...
asked by 13.02.2014 / 23:33
1
answer

Doubt with DATEDIFF days range between dates

I have a query that needs to return the range of days, the problem is that the date fields are set to varchar (30). --a data teria que ficar assim SELECT DATEDIFF(day,'2015/12/16','2015/12/20') AS DiffDate --data está gravada assim no b...
asked by 16.03.2016 / 15:25
0
answers

MSSQL: SQLSTATE [] (null) (severity 0) after loading 1000 rows

I have some reports where I need to perform new SQL queries in the loop. These reports are running on PHP and datatables. At times, when the number of rows reaches a volume greater than 1000, the MSSQL: SQLSTATE [] (null) (severity 0) error...
asked by 02.02.2016 / 13:12
1
answer

Doubt with for command in sql server 2008

I have the following situation, 5 discount fields that receive the discount name 01 through 05. this sql query works down (1), makes the correct calculation more only when you have only 1 of the rebates filled, if I have more than 1 then the res...
asked by 22.02.2016 / 17:40
0
answers

Column Discriminator error EF code first

I'm doing a project in asp.net, I'm using C # classes to make the connection to the database, but every time I try to insert a user into the database, it generates the following error:    invalid column name "Discriminator" Note: My bank...
asked by 24.01.2016 / 04:00
1
answer

Maintenance plan SQL Server 2014

I created a maintenance plan in the bank of the company where I work, it is dealing with the following options: Check Database Integrity Shrink Database Reorganize Index Rebuild Index Update Statistics And after completing it, he...
asked by 20.01.2016 / 20:04
1
answer

How to return day of week and time formatted sql server 2008?

I need to make a query as follows, I have a table (script): 1 - Pick up the day of the week 2 - Get the server time in hh:mm format example: SELECT CASE DATEPART(DW, GETDATE()) WHEN 1 THEN 'DOMINGO' WHEN 2 THEN 'SE...
asked by 29.12.2015 / 03:47
1
answer

Search for largest SQL vendors

I need a SQL code that shows me the best sellers but in the result show me which of the stores this official belongs to. I can do the research to know which are the best sellers but I do not know to select from which store it is. Here is my c...
asked by 12.12.2015 / 23:47
1
answer

Execute SQL procedure that disables dates in Datepicker

I have a system with a datepicker, and I want some dates to be disabled automatically. These dates should automatically populate the array that disables the dates. (Today is manual as the function below shows) var disableddates = ["10-12-2015"...
asked by 04.12.2015 / 12:30