Questions tagged as 'sql-server-2008-r2'

Tagged questions
4
answers

Do not insert form in the Database

Good afternoon. I am doing an inventory system with PHP AND SQL SERVER 2008, when making the connection it is successful but when inserting data and consulting them in the database I verify and it does not insert anything. $serverName = ("...
asked by 07.03.2017 / 19:14
1
answer

query sql error when converting to type time?

I have the following query SELECT CONVERT(TIME, LEFT(CONVERT(VARCHAR,(DATEDIFF(HOUR,[Hora Salida],[Registro Salida]))),2) + ':' + LEFT(CONVERT(VARCHAR,DATEDIFF(MINUTE,[Hora Salida],[Registro Salida])),2) + ':00') but when I try to execute i...
asked by 19.01.2018 / 13:24
1
answer

Save file and path? [closed]

I have my following code: public class UsrConexion { public string cadenaconexion; protected string sql; protected int resultado; protected SqlConnection cnn; protected SqlCommand comandosql; protected string mensaje; protected string sql1;...
asked by 23.11.2017 / 23:07
1
answer

Clause CASE in PIVOT? SQL Server 2008 r2

Good people, I have this query with a pivot that gives me this data: DECLARE @cols AS NVARCHAR(MAX), @query AS NVARCHAR(MAX), @date1 AS NVARCHAR(MAX), @date2 AS NVARCHAR(MAX), @space NVARCHAR (10), @x NVARCHAR (10)...
asked by 16.11.2017 / 15:00
1
answer

Change Oracle port 11g

I would like to know how to change the port of oracle 11g and what to occupy, that is, to know one that is free, since port 8080 is occupied by sql server and the 8081 Mysql. Greetings and thanks.     
asked by 20.10.2017 / 06:30
0
answers

Replication Sql Server 2008 R2

I try to enable the transactional replication with updatable subscriptions and it throws me an error, but I looked for information and it tells me to run the following procedure, but it does not work for me: exec sp_link_publication @publisher...
asked by 17.08.2018 / 15:11
0
answers

Script task parallels using common variables

I'm modifying an SSIS (SQL Server 2008 R2), which originally had a Script Task that did two different things, which I divided into two Script Task. Both have some common variables and when they execute they return the following error: A deadlo...
asked by 10.07.2018 / 09:31
1
answer

Place the value of one column in another column of different rows

I need to create a select where it is placed in value of one column in another column which belong to different rows, using the criteria of the type column. In other words, place the value of column_one in column_dos when type is = 'B'. Type...
asked by 01.06.2018 / 01:35
0
answers

Select in SQL the current date and time of the assigned time zone even if the user changes the date of the S.O.

Is there any way to be able to select in SQL the current date and time of the time zone assigned to the database, even if the user changes the date of the operating system? I have tried with the following sentences but if I change the date of...
asked by 31.05.2018 / 00:02
2
answers

Error updating records of type Varchar to INT using form with comboBox

I have a problem updating the fields in my table. Within the form I have a comboBox where I show the fields of my table of type Varchar but when selecting one of them I save the id of that department. My problem is generated when u...
asked by 16.05.2018 / 21:27