I am trying to transpose a table of a row with 10 columns and I use this but I get an error in the code:
SELECT descripcion
,Check01
,Check02
,Check03
,Check04
,Check05
,Check06
,Check07
,Check08
,Check09...
That is, create a trigger that prevents me from deleting a record from the 'person' table, but only if the name contains the following characters: 'JUAN' and print the message that can not be deleted
CREATE TRIGGER borrar
ON PERSONA
INSTEAD OF...
I generate a report with area, Type, and two dates within which the area and the type can contain or not values, with the four parameters works correctly, but how can I get the query executed correctly when the value is null? ?
Thanks!...
I am analyzing a database and there is a view that I do not know where the information comes from, is there a sentence to know where the data is coming from?
I know they always ask for code, but my question is basic. I also know that you can qualify it as "general knowledge" or "subjective response", but although it seems incredible, there are not many topics in Spanish that speak of the subject....
I have a query, which gives me the following results.
**cedis validacion_clientes Totales**
Celaya No visito a todos los clientes 17.33
Celaya Visito todos los cl...
I have two tables with the same structure but I have to compare their contents to find differences. The records with differences I get back correctly but I would like to know if you can get back the columns that have different value.
declare @...
How can I solve this problem of NullReferenceException was unhandled by user code, where I have a table inserted and it tells me that the value that returns to me is null?
using System;
using System.Collections.Generic;
using System.Linq;...
I have a service which when entering a number of an invoice brings me some fields and information, what I need to do is insert those same fields with the information to a sql table
I am what I have, the moment only brings me the data, but I d...