Questions tagged as 'sql-server'

Tagged questions
2
answers

create an sp that receives the necessary parameters to enter a new element in "x" table, but that the name of the new element does not duplicate

my question is how to compare in the if, the variable that I created called @name with the attribute of the table called Name?     
asked by 19.07.2016 / 19:52
1
answer

Error System.Data.SqlClient.SqlException (0x80131904) Error Form with sql [duplicate]

I want help with a small error that is giving me a program that I am doing for my class, it is a small program of a hardware store where products are kept, clients (in order that if it is a distributor to apply a discount), types of product...
asked by 26.08.2016 / 06:07
1
answer

Assign Cursor to List

How can I assign the results of a cursor to a List using SQL Server and Visual Studio ? The cursor is in a stored procedure, which must be called from the Controller: Stored Procedure CREATE PROCEDURE Lista_mun...
asked by 13.09.2016 / 07:16
1
answer

Rename computer with SQL 7 installed

I have 300 terminals that run Windows XPMode on Windows 7 x64. Each XPMode has installed a system that uses SQL-Express which I can not update because the system that interacts with it, does not support new versions. The 300 terminals have th...
asked by 23.09.2016 / 18:22
1
answer

Error executing program java error 740

I have a java desktop application that must unzip a rar file I execute it with command as if it were console by means of the Runtime.getRuntime().exec(l); method in debug mode works perfectly but when I run it does not extract all the fil...
asked by 08.09.2016 / 22:54
1
answer

How to view local database through internet [closed]

I have a local database in my house with MS Sql Server, from this database I only need to show a data from a table through the internet or an application, I would like to know which is the easiest way to achieve this, to exemplify , if in the lo...
asked by 07.05.2016 / 17:34
1
answer

"SQL Server" Server Error "DELETE" and "INSERT" from Excel

I have created a procedure that first deletes the records from my table and then imports them from excel. DELETE tabla WHERE columna='dato' INSERT INTO tabla SELEC * FROM OPENDATASOURCE ('Microsoft.ACE.OLEDB.12.0', 'Data Sourc...
asked by 20.10.2016 / 01:32
2
answers

Connect SQLServer 2014 with PHP

I'm trying to connect SQLServer 2014 with PHP, when trying this code works $servidor = "NOMBREPC\SQLEXPRESS"; $database = "PRUEBA"; $info = array('Database'=>$database); $cn = sqlsrv_connect($servidor, $info); But when trying using a cla...
asked by 25.07.2016 / 05:45
1
answer

Create user $ webserver in SQL Server

I made a Web Service, use windows authentication, and I need to have permissions in the MSSQL database There are other databases that have a user added "$ webserver" Security / Users / $WebServer I am trying to add my user in the same wa...
asked by 18.03.2016 / 17:12
1
answer

Modify URL to download report

I am using SQL Server Reporting Services (SSRS) and I want to download a report without the need to access the server to see the report, but automatically download the report on the user's computer. I want to see the possibility of m...
asked by 20.07.2016 / 19:29