Questions tagged as 'sql-server'

Tagged questions
0
answers

open port with windows server 2012 r2 digitalocean

Install in the digitalocean vps windows server 2012 r2, but it does not allow me to open ports. I already did it with the firewall configuration and I have disabled the firewall but it does not open any port for me     
asked by 06.11.2018 / 17:48
1
answer

SQL Server connection from xml file

my question is this I must pass my current connection string, which is this: internal Clsconexion() { cadena = ConfigurationManager.ConnectionStrings["ConSicap"].ConnectionString; } But they ask me to improve it and pass...
asked by 14.11.2018 / 14:44
1
answer

Align concatenated column in a query in SQL Server

I have this query: SELECT A.CODIGO_MINSA, A.DESCRIPCION, B.DESCRIPCION AS COLEGIO, A.CODIGO_MINSA + ' - ' + A.DESCRIPCION + SPACE(60 - LEN(A.DESCRIPCION)) + '- ' + B.DESCRIPCION AS PRESENTACION FROM [HEVES_RRHH].[dbo].[T_TIPO_ESPECIALIDAD...
asked by 06.11.2018 / 16:19
1
answer

How to make a sql-server 2008 connection in php when it is already on a web host?

I already made a connection to sql server from xammp and it works perfect, the question is how should I change the connection parameters to access from a web host on the internet? what ports should I open or what ip should I put? I hope you can...
asked by 06.11.2018 / 05:24
0
answers

management studio sqlServer DOES NOT enable alter function partition script?

Partition a table (two partitions) by date. The original function is: CREATE PARTITION SCHEME [EsquemaParticion2] AS PARTITION [FuncionParticion] TO ([Historico1], [PRIMARY]) I need to modify this partition by adding a new partition, an...
asked by 05.11.2018 / 21:24
1
answer

Format Date of a query

I have an sql query in which I get dates ... I give this format but I get the error ---- Fatal error: Call to a member function format() on null in... My code is: $FechaInicio = $fila2[FechaInicio]->format('Y-m-d');     
asked by 09.11.2018 / 17:02
0
answers

Problem with PHPExcel format

I'm doing a query in Sql Server to bring some numbers and put them in an Excel file (.xls) with the library PHPExcel . $consulta = "selec celular FROM clientes where celular <> '' AND LEN(celular) = '10' AND ind_estado = '1...
asked by 02.11.2018 / 17:01
1
answer

Create a trigger that does not allow editing a record that has been referenced

I need help with a slogan of a job that I have been given at the university to study, and I have been trying to solve it but I can not think of how .. I am starting in SQL Server. These are the tables of the statement : The statement say...
asked by 03.11.2018 / 23:29
1
answer

How to validate that the status of a product can not be changed if it is registered in one or more orders

Good day to all I hope you can help me with this doubt in advance thanks. I have a product table with the following fields Id_Producto, Descripcion, Id_Categoria, Id_Color, Activo, The Active field is a bit type and it helps me to ch...
asked by 09.11.2018 / 00:21
0
answers

Automated Full Backup, what is it? SQL SERVER 2012

A udpate was made casually without where and when wanting to find a way to find a way back, I found this, is this a backup? I put task, restore, database     
asked by 09.11.2018 / 00:03