Questions tagged as 'sql-server'

Tagged questions
0
answers

Any way to send or send emails from SQL server 2008R2?

I have SQL server 2008 R2 I want to send emails to all my registered SQL users but I do not have the Emails function Installed in the management studio SQL I want to know if there is any way to send emails taking the variables in the column: S...
asked by 15.10.2018 / 14:07
1
answer

Import data from csv file

I have a csv file which has this data that takes them out of a single field. As you will see, it is not only data from a single field. In the table where I want to insert this data has the following structure. The information I...
asked by 15.10.2018 / 16:56
1
answer

Problem when executing in jasper ireport report

I have a Java GWT project, where I make an invoice, the whole process of saving and returning in the SQL DB works well, the problem is when in two or more terminals the sales process is executed simultaneously, since at the time of showing the d...
asked by 05.10.2018 / 01:38
1
answer

Duplicate sqlserver join

Hello good day I have a question, I have a table that says products and one that says equivalents and linked results that I do the query with joins where is this way: Productos Equivalentes Ligados 00697000 MS-92692 MU-41309-P...
asked by 05.10.2018 / 00:49
0
answers

Query does not bring me the expected data

I have a selection query SELECT which when I apply a filter with WHERE no longer brings me anything but without the filter if it brings me all the data. SELECT PC.ProductoCatalogoId, P.Nombre, PC.PrecioVenta, E.Nombre, O.NombreOp...
asked by 02.10.2018 / 10:13
0
answers

Error integrating data services integration services

problem integrating integration of services of sql server data tools     
asked by 01.10.2018 / 02:14
0
answers

AN event happens at a certain time of day SQL server 2008 R2

At 1 PM in a Game X a monster dies but it is programmed so that within three approximate hours it revives, or it departs at 3 PM. for example, but the time to revive is Variable DOES NOT HAVE A STILL TIME then I got that: DECLARE @horareviv...
asked by 02.10.2018 / 03:15
0
answers

Connect PHP 7.2 to SQLSERVER 2014

I am trying to connect my PHP v7.2.10 to SQLServer2014 I have seen quite a few tutorials and I have not managed to do it, I have downloaded the corresponding libraries to the version of my PHP (php_pdo_sqlsrv_72_nts.dll, php_pdo_sqlsrv_72_ts.dll...
asked by 03.10.2018 / 22:01
1
answer

Difference of SQL days

I have the following problem, I want you to show me in a column how many days are left until my next birthday. I already tried the following functions DATEDIFF and DATEADD I leave you my sentence that would be missing add this column: se...
asked by 02.10.2018 / 21:36
2
answers

How to use a TextBox for different SQL Server operations?

I am using WebForms, for the platform that is already working correctly in the work, in conjunction with VB.NET, I have a question on how to work with a single text field, and, in turn, the same Text field can work to store different information...
asked by 28.09.2018 / 21:58