Questions tagged as 'sql-server-2008'

Tagged questions
1
answer

How to export to Excel with php and Sql Server 2008

I want to generate an excel report of my markup query. but I could not. I get the following error in the excel. <b>Fatal error</b>: Class 'Conexion' not found in <b>C:\xampp\htdocs\intragarzon2.0\formatosTH\marcaje\core\b...
asked by 17.05.2018 / 14:10
1
answer

Generate .TXT file with Stored Procedure

I have the following SP and I want the results saved in a .TXT file for   I also have a JOB which executes the Stored Procedure, which I configured   from the SQL Server Management Studio. This is an example of how a result of a query is sent...
asked by 09.01.2018 / 21:39
1
answer

Estimated hours using a check

I have a table in which I have three fields which are: create table horas ( fechaEntrada datetime, fechaSalida datetime, horasEstimadas int ); and I have to make a restriction in the table that is, that the estimated hours shoul...
asked by 22.08.2017 / 03:54
1
answer

How can I compare the records between 2 databases to compare that they are identical? SQL 2008

I have two Databases in Full Mode, taken from the same copy, but in one I debug the Log to leave it at 1 MB and in the other I leave it intact, as I can check that there has been no loss of information in which Was the Log debugged?     
asked by 08.03.2017 / 19:46
2
answers

In SQL query check if a dateA field is equal to "01/01/1900" and if so it returns the value of another dateB field

I have a very long SQL query in one of its paragraphs I need to control if a field dateA is equal to "01/01/1900" and if so it returns the value of another field dateB. As I commented the query is very very long with other CASE, arguments, et...
asked by 05.09.2018 / 11:56
1
answer

Delete user table dtproperties SQL Server

Is there any consequence of deleting the user table dtproperties of SQL Server ?, I am filtering the permissions of Role Public and verifying that this Role does not have DML and DDL permissions different from the Default ones that...
asked by 13.12.2017 / 23:51
2
answers

CREATE DATABASE permission denied in database 'master'

Good afternoon everyone. I'm having trouble creating a database. Since I get the error    CREATE DATABASE permission denied in database 'master' Since the SuperUser (sa) I have given permission to the user "Lucas" with db_owner so he can...
asked by 02.11.2016 / 20:45
2
answers

Error in DBExpress with Delphi + SQLSERVER

Dear, I have this error: SQL STATE 42000, SQL Error CODE 201 Look for information on the internet and I can not find the solution. Client side script: var client : TTServerMethodsClient; var ds:TDataset; var dst:TDataset; v...
asked by 18.05.2018 / 16:50
1
answer

Subtract column value from the same column, previous record

Good afternoon, I have a table Control_Kilometrajes of which I need to get a new column called Recorrido , and is drawn from the column Kilometraje : the greater mileage is subtracted the lower, while Placa_FK be the sa...
asked by 07.09.2017 / 01:53
1
answer

Error with SQL SERVER sequences

When trying to create a sequence in my database, I get an error. Then proceed to publish the script and the error of the query: create sequence seq_valorar start with 300 increment by 1 minvalue 300 no maxvalue no cycle; create sequence seq_...
asked by 05.12.2016 / 14:15