I'm working on SQL Server 2008, and the problem I have is that I can not (I do not know if it's really possible) to insert records from a query from a Store Procedure from another server:
declare @DRIVER Table
(drive char(1), FreeMB int)
I...
I want to make it impossible to insert or update when there is already a coordinador in the same departamento in a table empleados .
CREATE OR REPLACE TRIGGER UnCoordinador
AFTER UPDATe
ON EMPLEADOS
DECLARE
BEGIN...
Good morning,
I have this select:
select
count(ob.obj_id) as appeareances,
cl.id as classs,
cl.intl_id as class_intl,
cl.name as class_name,
cf.name as classif_name,
cf.intl_id as classif_intl,
cf.id as classif...
I want to know stories times a subscriber_id liked a hashtag that are about ads that we call eclipse_id .
I have two tables in my database:
Swipe that gives me if a subscriber liked an advertisement:
A subscriber like...
I use this sentence:
$skills = $SQL->query('SELECT * FROM table1 INNER JOIN table2 WHERE table1.account_id <> table2.account_id LIMIT 10')->fetchAll();
But when I use print_r($skills); to see the data thrown, it appears t...
I tell you ... I have a very large database, and the truth is that I would not have problems in elbowing 20 or 25 tables within the migrations of PHP / Laravel. The problem is that they are 97 tables, mostly moderately large. ..
To the point...
I have a table called Modifiers :
This is the structure:
-----------------------------------------------------
| ModId | ModText | AdditionalCost |
-----------------------------------------------------
| 58 | RANC...
where it is commented, prints me for example a date
where in loan the day has a 06, but on the return date it does not have it and this record is being excluded, being that I put an AND so that when the return is different from 06 and the loan i...
Good, I have a Web application in which the front end is javaScript and the back java, which connects to SQL Server, I have an SP which queries the data on a table, which if not generated a function, the question is that the web screen shows me...
It is a table that shows different information one of them is that it shows a date of entry, but in that table sometimes I change the format per month. day and year and I want dd-MM-YY. There is some way to change the format in the query I have...