Questions tagged as 'sql-server'

Tagged questions
2
answers

Bring current date and time

I want to put the current date and time in this script select convert(datetime, cast(year(getdate()) as varchar(4)) + '-' + cast(month(getdate()) as varchar(2)) + '-' + cast(day(getdate()) as varchar(2)) + ' 12:00:00.000'); Can someone he...
asked by 25.05.2018 / 14:07
2
answers

How to get all the jobs in separate scripts sql server ssis?

When it is necessary to generate the drop and create scripts of the jobs in SQL Server separately, it is not possible through the SQL Server Management Studio, you can only go one by one to do this ... The problem with this is when you...
asked by 16.06.2017 / 17:28
1
answer

Connecting Php with SQLServer 2000

<?php $server = "10.7.0.202"; $database = "GERENCIA"; $user = "sa"; $password = ""; $conexión = odbc_connect("Driver={SQL Server Native Client 10.0};Server=$server;Database=$database;", $user, $password); ?> I am looking to connect to a...
asked by 18.01.2018 / 03:46
1
answer

Problems importing pyodbc module using bottle

I am working in windows and using bottle to connect to a database of SQL server , for it install pyodbc with pip install pyodbc however when I want to load the program I always get the error ImportError: No mo...
asked by 27.04.2018 / 15:44
2
answers

Algebraic Sum of 2 Select SQL Server 2012

Good morning, I have the following Select in SQL Server 2012, and I need to do an algebraic sum of both Select of the quantity and total fields, since the result of each one gives me positive and negative values. SELECT T0.U_CTS_Vendedor, T5.[...
asked by 11.09.2017 / 14:02
1
answer

The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception

I'm doing a program in C # that attacks an Oracle 12C database that is in another virtual machine, if I connect using SQL Developer I have no problems, I connect and I can work. Now I try to enter from code and I get the error indicated in...
asked by 01.06.2017 / 15:33
2
answers

Store stored procedure results in temporary table

Background I have a procedure stored in a database in SQL Server 2012 1 that averages some values. This stored procedure receives as parameters two (2) values of type int. Example: IdFuntionary IdProcess 1 It is the version...
asked by 18.04.2017 / 18:57
2
answers

Open DTS files in Sql Server 2012

I want to migrate several Integration Services packages from sql 2000 that have a .DTS extension to DTSX. I currently have Sql Server 2012 and I can not pass them to DTSX. Is there a direct way to migrate them, without needing to convert t...
asked by 31.01.2017 / 17:28
1
answer

Connection to Sql Server by JAVA - Windows Authentication

I want to connect to Sql Server using Java with Windows Authentication but I get the following error: This driver is not configured for integrated authentication. ClientConnectionId: 0b65956b-a286-4aef-a372-ab741a239761 This is the code I use...
asked by 09.02.2017 / 20:20
2
answers

Pass ResultSet to a JSON in Java JSP

My query is to know how I can pass a ResultSet from SQLServer to JSON, since I am working with JavaScript libraries (ChartJS) to generate graphics for a dashboard and it only reads data in that format. package DAO; import conexion.Conexion; i...
asked by 07.01.2017 / 01:09