Questions tagged as 'sql'

Tagged questions
1
answer

Avoid duplicate records in C # in modify

I have a function that does not allow me to enter the same data in the same row. at the time of entering a new product if it works I can not enter a product that is already in the database, the problem if I want to change and I only want to chan...
asked by 31.03.2018 / 02:08
2
answers

get id after inserting a record in sqlserver

How can I get the id of a record after it is inserted into a SQL table, I'm working with .net and sql server, if I have this stored procedure example CREATE PROCEDURE dbo.sp_Students_INS_byPK @student_id INT...
asked by 12.03.2018 / 21:35
1
answer

How to capture a selected item from a combobox filled from a BD

I need help with a bit of code. It turns out that I have a combobox that I fill using a database: private void frmMain_Load(object sender, EventArgs e) { //TEXT BOX DISABLED txtDv.Enabled = false; txtNombre.Enabled...
asked by 12.03.2018 / 22:03
3
answers

Search SQL Server table

I'm working with a database with a huge amount of tables and views. The program that calls that database peta and gives me an error when it tries to call a certain table. Is there any option to look up that table? Search engine or something?   ...
asked by 12.03.2018 / 12:24
1
answer

PROBLEM WITH SQL QUERY IN C # ASP.NET

I have a webform project in asp .net with c # and in my query sql I need data that the user will provide. The week field is entered in a textbox in the webform1 and the query is in the webform2. According to that data, it will show me certain...
asked by 08.03.2018 / 20:06
1
answer

Generate Ordered Records of Different Tables

I have a problem that has frustrated me for days, I am developing a DB in SQL with the structure of the image, I explain a little: Each "Completed Part" has several "Parts of Blanquins" and in turn each "Blanquin Part" has several "Stamped Pa...
asked by 08.03.2018 / 19:05
1
answer

SQL multitasking query

I'm using the world database in SQL server 2016, and I have a little doubt, I'm practicing and one of the questions is to select the countries and their respective capitals, my problem is that in cities I have 5 or 6 country, and I do not know h...
asked by 09.03.2018 / 16:54
1
answer

difference between the use of functions, views, triggers and stored procedures in sql server and mysql

Well I hope to do this well, it's the first time I ask on this site. What are triggers, functions, views and stored procedures? The truth is I'm starting in this database and I have many doubts in the use of functions, views, trigger and PA f...
asked by 24.03.2018 / 00:25
2
answers

Result of a field in several sql server

How do I generate a query that gives me results like this: Nombre nombre_sigue David Lopez danilo cruz Carlos perez sebastian corea Juana maria maria dinora Patricia aguilar kurt heiz in this exam...
asked by 27.03.2018 / 23:03
1
answer

Query with conditions operating with ALIAS in SQL

Keeping in mind that A and C are subqueries ... that represent the stipulated articles and the counted articles COUNT(OSZE.X_OrgSubZonaElem_ID) CANT_ELEMENTOS, COUNT (A.X_OrgSubZonaElem_ID) CANT_ASIG, COUNT (C.X_OrgSubZonaElem_ID) CANT_CONT,...
asked by 06.03.2018 / 18:16