Questions tagged as 'sql-server'

Tagged questions
1
answer

Travel variable with a Store

I'm doing store procedure. But I have a doubt about the query that its results are two values. (@VarId) I need to pass the two values in the second query, so that I can return the data that is not found in the tb_change CREATE PROCEDU...
asked by 28.10.2018 / 19:59
1
answer

Error 404 in Codeigniter project published in Azure Cloud Web App

Well, I am new by launching this type of project and for the moment I am trying to configure a codeigniter project within the Azure cloud portal, through a web app. The issue is that I get a 404 error when trying to access the credential validat...
asked by 14.10.2018 / 01:28
2
answers

How to make a query in sql to get a field by entering several parameters in the where

I'm doing a sql database on foods. The tables I have are meals from the sierra jungle coast and ingredients. And its intermediate tables. What I want to do is a query that allows me to obtain a meal by entering several ingredients in the where....
asked by 28.10.2018 / 02:28
0
answers

Error installing SQLServer 2014

Does anyone know how to solve this error? I would appreciate it.     
asked by 11.10.2018 / 00:31
1
answer

Create query in several tables with Laravel 5.6

I want to prevent the user from deleting a record if it is already in use, for example: Patient-id_patient table have interaction with table Accidents or Table Appointments Clear by the primary key id_patient. The idea is that if it already h...
asked by 11.10.2018 / 00:32
1
answer

Use data from a table for login

I want to use the data of a table in SQL Server to verify the user data, whether it is registered or not. I already manage to connect to the database, and save the data, what should I do? protected void Button1_Click(object sender, EventArgs e...
asked by 10.10.2018 / 06:25
1
answer

Invoice table in system of different types of invoices

Good I wonder how I could create the invoice table and invoice detail in a system where not only are items sold. The question is the following in a business there is a restaurant and also sell items or products then how could you structure the d...
asked by 11.10.2018 / 03:23
0
answers

Arithmetic operations in an insert into

Good morning, I am working on making a sales database BASICO (so as not to complicate me because I just want to understand the basic logic of how to handle tickets in a BD) I have the following tables create table cliente( pk_Cliente int,...
asked by 10.10.2018 / 07:24
0
answers

Sqlcmd: Error: Microsoft ODBC Driver 11 for SQL Server: SQL Server Network Interfaces: Error Locating Server / Instance Specified [xFFFFFFFF]

I am trying to automate the Back Up of a database that runs in SQL Server 2014 Express. For this I copied a Store Procedure from the Microsoft support page, this works since I ran it from the Sql Server Management Studio and it generates with...
asked by 09.10.2018 / 22:27
1
answer

Run powershell from SQL SERVER

I am trying to obtain a PowerShell query, where I get back the free space in all the disks of my linked servers, this by means of a distributed query, nevertheless when executing this query with the xp_cmdshell I get an error, I will leave the q...
asked by 05.10.2018 / 17:04