Questions tagged as 'sql'

Tagged questions
1
answer

How to know if a date exists between two months?

How can I know in SQL Sysbase if "22-12-1994" is between September and December     
asked by 14.11.2017 / 20:33
1
answer

how to add new fields to a table at the time of execution of a vb.net system? [closed]

Thank you in advance for reading my question. I am developing a system on VB.net and Sql Server, they ask me to add a part where the system finished they can add a new field or delete an existing one from some table but from the system (So th...
asked by 27.03.2018 / 14:47
1
answer

Search Number repeated in SQL SERVER

How can I find a repeated number in a Table Items in different Columns called Gem1, Gem2, Gem3, Gem4, Gem5, Gem6 but that are repeated in the same row. example: UsuarioID, Gem1, Gem2, Gem3, Gem4, Gem5, Gem6 0001 23 23 23 23...
asked by 18.03.2017 / 01:51
1
answer

Problem with SQL Server script? Help

I have the following sql server code with the tables site, neighborhood, location and province. The scrip throws some syntax error? What is the result that throws? thank you for hours I'm struggling with this SELECT S.razonSocial, count(*) FRO...
asked by 09.06.2018 / 05:46
1
answer

'MSDASQL' does not support the required transaction interface

I have created a linked server between a Microsoft SQL Server 2000 and MariaDB Server 10.1.17. For this I used the ODBC connector version 5.1 downloaded from the MySQL website. The problem that arises is when doing distributed transactions...
asked by 21.09.2017 / 11:47
1
answer

SQL Script error - Do not create all the complete tables

Good afternoon! I hope you can help me. I am creating a BD for a project. The logical design I did with MySql Workbench and generate the Sql Script to create the database. The issue is that when executing the Script in...
asked by 24.08.2017 / 13:33
1
answer

Stack overflow in stored procedure (PostgreSQL)

I have this procedure stored in PostgreSQL: CREATE FUNCTION ratpais_indcicloinmo() RETURNS trigger AS $ratpais_indcicloinmo$ BEGIN UPDATE sde.ratpais SET indcicloinmo=(pond1cicloinmo)*(pond2cicloinmo)*(cicloinmo); END; $ratpai...
asked by 21.12.2017 / 20:27
1
answer

how it works not for replication in the triggers

Hi, I'm trying to understand how the triggers work when you specify not for replication, if for example I have a trigger instead of update not for replication that works on a view and instead of updating that view what it does is up...
asked by 31.10.2017 / 16:21
1
answer

Select dificil with Laravel

I need to pass this select that cost me a lot to do it, to Laravel and there is no way, I would like to know if there is any way to put the query direct without passing each clause by the Laravel functions or if someone hel...
asked by 01.11.2017 / 11:33
1
answer

Not all fields in my table are created

I am trying to make a CREATE TABLE that results from the query of 2 different tables. What I want to know is the number of products that each user has. Some help? Thank you very much in advance. usuarios --------...
asked by 05.11.2017 / 18:33