Questions tagged as 'sql-server'

Tagged questions
1
answer

Time Limit - SQL Server 2008

Good afternoon, I would like to do a SQL to control the limit of the last hit of the employees point with the first of the other day, filtering the amount of times the calculation gave less than 11 hours for example. I have the data below,...
asked by 30.06.2015 / 20:23
1
answer

How to check the constraints on the bank

Hello, how do I check if my constraints are linked in the entire bank? I need a query for Oracle and SQL Server.     
asked by 14.07.2015 / 20:36
0
answers

Return columns according to sql server criteria?

How can I return the column names of a table according to search criteria? I want to return the columns that are with 'S' option, all fields is a char of 1 that receives 's' or 'n' select b.livros, b.jogos, b.cinema from tb_cadast...
asked by 12.05.2015 / 05:14
1
answer

Doubt about 'NUMA' (non uniform memory access) in Microsoft SQL Server

Can anyone help me to understand the concept of 'NUMA' in Portuguese and their respective characteristics sff? I've found websites in English, but I still do not understand!     
asked by 27.05.2015 / 02:40
1
answer

How to convert DateTime type to nvarchar?

I have a table with a column of type nvarchar , and I pass the following parameter to the stored procedure : cmd.Parameters.Add("@PointDate", SqlDbType.NVarChar).Value = DateTime.Now; As expected, I'm getting the following error: A...
asked by 21.05.2015 / 16:11
1
answer

Error converting BigInt to integer using lambda

In the database the type is BigInt and in C # I am trying to convert to int and it can convert, but when it arrives in the lambda statement, it gives error. long codpro = Int64.Parse(tb_CodigoProduto.Text.Substring(0,14)); db...
asked by 10.02.2015 / 00:51
0
answers

CakePHP SQL SERVER

I have a big problem here. I have an application made in cakephp hosted on locaweb on windows server. The following problem is occurring: The save method of NO model is working. In debug I search for error of validation error and invalid f...
asked by 03.04.2015 / 14:09
0
answers

Updating data in sqlsrv

Since yesterday I have been having a very strange problem at the time and updating data in my DB. I have always been able to update data, but I can not do it with this command: if(isset($_POST['salvarNao'])){ $acordoo = $_POST['acordoo'];...
asked by 20.01.2015 / 12:03
1
answer

I can not create table in SQL SERVER

I have a SQL SERVER instance installed locally where I am an administrator, I can create databases but I can not create tables. Home Here is a photo of the error that SQL displays. More Some Details: ===================================...
asked by 29.12.2014 / 18:33
1
answer

Error using sql command Insert (SQL Server), via classic ASP

Good evening, I'm having a problem executing a sql command through an ASP application. The command is this: strSql = " INSERT INTO movimento_tef_nsu ( "&_ " identificador "&_...
asked by 25.07.2014 / 14:07