Questions tagged as 'sql-server'

Tagged questions
2
answers

Stored procedure from MYSQL to SqlServer

Create a stored procedure in SqlServer , I'm used to using MYSQL but now I have to do a stored procedure that inserts values but that the code id increases every time data is entered this would be in MYSQL : delimiter create...
asked by 04.05.2017 / 07:02
1
answer

Is it required to have excel installed to use OPENDATASOURCE? [closed]

Good morning, in the following link I found the way to import data from an Excel to SQL Server: link However, since the application from which I am going to execute said command is in PHP, I would like to know if it is necessary that in...
asked by 26.04.2017 / 17:43
2
answers

Connection of SQL SERVER 2012 with Codeigniter

Hello everyone, I am developing a system with CI, Mysql and Sql Server 2012, I am configuring in php 5.6.30 and I put all the exemptions in php.ini and nothing I get this error when I pick it up and that's in my databse, php $db['sqls...
asked by 10.04.2017 / 17:55
1
answer

Error creating and executing stored procedure

I am trying to create a stored procedure which verifies all the projects in my database and gives me for each project a series of elements that I need. When trying to do this, the procedure bugs me with an error Must declare the scalar var...
asked by 24.04.2017 / 21:34
1
answer

IDENTITY_INSERT error in SQL

My problem is that I try to make a simple insert in my Database, but at the moment of executing the sentence it marks me the following error:    An explicit value for the identity column in table 'tNationalization'   can only be specified whe...
asked by 30.03.2017 / 00:33
1
answer

Pass an instruction from sql to an asp: SqlDataSource

I have the following statement tested on the sql server: select AsignaturaNombre from Asignatura where CodigoAsignatura=(SELECT [idMateria] FROM [Permisos] WHERE ([idProfesor] = 19398676) union SELECT [idMateria] FROM [Permisos] WHERE ([idAlum...
asked by 24.03.2017 / 15:27
2
answers

How to join two queries in sql for me to total?

Hello friends, I'm here to request your important contribution I have this Script SELECT ISNULL(mes,0)[mes], ISNULL(Cod_Area,0)[Codigo Area], ISNULL(nom_emp,0)[Nombre Empleado], ISNULL(Cod_Puesto,0)[Codigo Puesto], ISNULL(Puesto,0)[Puesto], I...
asked by 10.03.2017 / 17:23
1
answer

Problems with sqlsrv_errors in php

I am using PHP 5.6 on IIS 10 with SQL Server 2014, and I have the following function to make inserts, updates and deletes to the database: <?php public function ejecutarSQL($sql,$parametrosSQLServer=array()){ $bandera=false; $msg=""...
asked by 07.03.2017 / 21:25
1
answer

Publish asp.net site [closed]

I want to publish my web project in harass but I have no idea how to do it. Can someone give me a hand? It is an asp.net and sql server 2008 application. Thanks!     
asked by 07.03.2017 / 20:06
1
answer

How to get a value from a SQL Server T-SQL record

I have the following code USE [database] GO /****** Object: StoredProcedure [dbo].[spPacienteEnCola] Script Date: 02/23/2017 08:31:26 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[spPacienteEnCola] @ta...
asked by 23.02.2017 / 18:31