Questions tagged as 'sql-server'

Tagged questions
1
answer

You can create a trigger in SQL server 2008 R2

Good I want to create a trigger that when I create a Procedure the trigger take the name of the procedure and the name of the base data used and this is inserted with the 2 names base data used and name of procedure in a table of X basedato Is t...
asked by 08.09.2018 / 06:57
0
answers

Connection timed out: no further information. Verify the connection properties

Something very strange happened, I'm doing a web application in java with app engine and sql server using rest services, everything works apparently fine, but only once, that is, I have an endpoint that connects to a database and runs a Store Pr...
asked by 07.09.2018 / 17:54
0
answers

Web App Azure (trial version) and codeigniter project

Well, it's my first time using Azure as a host for a codeigniter project, because I decided to mount it on this platform because: 1. I need to connect it to a database in SQLServer (free of charge) for a quick presentation. 2. I do not know at t...
asked by 12.09.2018 / 07:13
1
answer

Compare 2 fingerprints using SQL and C #

Good day I have an application that I set up on the Internet, and adapt it to my needs, I have only managed to get the data captured, I used Digital Person SDK 1.6.1, I have a fingerprint reader: digital person 4500u. In my database I store t...
asked by 19.09.2018 / 20:57
0
answers

Error inserting records in SQL Server (BULK INSERT)

I have a problem inserting the records of a table with the BULK INSERT command. BULK      Insert product from 'C: \ csv \ products.csv' with (firstrow = 2, fieldterminator = ', ', rowterminator =' \ n ') This is the error that com...
asked by 23.10.2018 / 05:48
0
answers

pyodb package connects to SQLSERVER 2008 and does not get data

I am working with python 3.5.4 and django 1.11.13 install pyodbc and pyodbc-azure, it connects but it does not make any sql, here I put an image of the code and the debugging with the answer , also probe with 'DATABASES = { 'default': {...
asked by 15.08.2018 / 16:51
1
answer

Print SQL variable after an EXEC AT

I have searched tirelessly for how to execute the EXEC AT command with a variable and I have not found it. SQL SERVER 2008 R2 Example: DECLARE @ServInst Varchar(100) = 'SQLSERV\INST01' DECLARE @Query nVarchar(100) = 'SELECT * FROM...
asked by 17.08.2018 / 22:01
2
answers

Name of object not valid SQL

I want to create a function that allows generating a sales report per employee, in a certain year. The function must return: the data of the employee, the number of registered orders and the total amount per employee. This is an exercise of a PD...
asked by 30.07.2018 / 21:06
3
answers

Subquery with data from the same table in sql server

I am using SQL SERVER 2012 I want to make a subquery with data from the same table that has the query relating three fields, I mean, the query is SELECT m.COMPROBANT, COUNT (m.COMPROBANT)Item_ENTRADA, m.FECHA_TRS,m.COD_PROVEE,m.COD_AREA, SU...
asked by 26.07.2018 / 00:52
1
answer

syntax mysql procedure

Could you please help me with the following procedure in mysql? ... The following procedure is in sqlserver. I would appreciate if you would indicate what it would be like with your syntax. I would appreciate your help please, I am suffering day...
asked by 21.07.2018 / 17:42