Questions tagged as 'sql-server'

Tagged questions
2
answers

Doubts SQL Server [closed]

I'm having trouble with this question, can anyone help me? Tables: CREATE TABLE Funcionario ( Cod_Func int Identity not null, Nome_Func varchar(100) not null, Data_CadFunc smalldatetime not null Default Getdate(), Sexo_Func char(01) no...
asked by 02.11.2016 / 16:17
3
answers

Decimal problems in SQL string

I'm having an error: every time the variable c.Value_value passes the SQL string, automatically, the "." which separates the Decimal is converted to ",". Asyoucanseeinthisimage,thevariableisusingthe"." usually. However,theSQLstringtakest...
asked by 05.07.2018 / 16:34
2
answers

Maximum size, connection limit and what version of SQL Server should I use in my desktop application

I'm developing a system and I'm using SQL Server 2014 database, but the free one. What version can I use so that I will not be limiting my bank resources when I reach a larger size or exceed a number of connections?     
asked by 30.06.2018 / 15:33
3
answers

Date field in Firefox and IE

I have the following code: $dataAssContrato = new DateTime($_POST['dataContrato']); This line works perfectly in Chrome, but not in Firefox or IE, because when I try to register one each, I get the following warning:    Fatal error: Unca...
asked by 27.10.2014 / 13:36
1
answer

0097 - missing parentheses to the right. - Can help

I know there are some discussions here in the forum about this error 0097 - missing parentheses on the right .. Here is my command, can you help me? select distinct Coalesce(Sum(Case When FI_TITULO.ABERTOQUITADO = 'Q' Then 0 Else (FI_TITULO.VL...
asked by 21.09.2018 / 15:05
1
answer

Procedures Conversion [closed]

Someone knows or knows an easy way to migrate stored procedures from SQL Server to Oracle.     
asked by 19.09.2018 / 14:40
1
answer

Generate Database Merge

I have a Database backup and for lack of documentation I need to generate the MER of it. I remember reading somewhere that there are programs that do this reverse engineering and generate MER. Could you help me with this?     
asked by 20.12.2017 / 13:10
2
answers

How to connect an HTML page, using ASP, to SQL Server database?

How do I connect a sql database to an html site using asp? Note: I already have the whole bank developed and the whole page too, I just need to know how I bridge the two     
asked by 30.06.2016 / 15:11
1
answer

Connection String C # EntityFramework [closed]

I would continue a work from home project, the Connection String that works is as follows: <add name="DBModel" connectionString="data source=PD_22;initial catalog=EXERCICIO_ENTITY_JOSEEDUARDO;user id=login;password=senha;MultipleActiveResu...
asked by 23.10.2016 / 20:26
1
answer

How to know how many sales for each of the months?

I need to set up a query that brings the total sales of each month from a table called sales.SalesOrderHeader , but I'm not getting it. In this table there is a field OrderDate which is the date of sale and TotalDue is the va...
asked by 14.08.2017 / 19:34