I have created a sql statement that traverses a string and generates columns with data.
CODE:
select p.FK_workitem,
p.numero_sd,
p.PARRAFO,
LTRIM(substring(p.PARRAFO, 0, CHARINDEX(':', p.PARRAFO))) Tipo,...
I have a small problem when trying to extract all the data of a weak entity that I have created between a table called Doctor and another patient. When I do the query, I extract the data correctly but in triplicate, that is, instead of returning...
I'm trying to create the following trigger:
DELIMITER //
CREATE TRIGGER 'smdraux_after_insert' AFTER INSERT ON 'smdraux' FOR EACH ROW BEGIN
IF(LENGTH(NEW.llamante) = (4) AND NEW.nombreinterlocutor1 NOT LIKE 'VM Channel%'
AND NEW.nombreint...
I have read several open cases of this type but I do not really see one that fits my case. Well I raise my case;
I have a DataGridview which, by consulting the BD, I filled it and I want to add rows through TextBox that are in the same form....
I have a query in SQL server:
SELECT [nIdLogTG]
,[nUsuario]
,[nConsDetalle]
,[nConsDoOrigen]
,(case when a.cCodigoComplementarioDo IS NULL THEN b.cCodigoComplementarioDo
ELSE a.cCodigoComplementarioDo END) AS Cod...
Along with saying hello and thanks for this space, I ask for help with the following.
I have two tables .. the table1. is a historical sales record with the fields fecha_vta, código_producto, cantidad. in the other table I have the variation of...
I am executing a query with C # and I get the following error ..
This is the query that I'm executing, something fails, I do not know why, it still is not good sql ...
CREATE TABLE Empresa( id_empresa int IDENTITY(1,1) NOT NULL...
Please, I need your help with this. I have this table in the view:
What I need is that in the ID column I get a list to select the IDs that I have in this database, and when selecting an ID I load the item and the unit price in the view...
What I try to do is capture the last code that was entered from my table in sql and show it in my txt that is in c #
try with this code but it did not work for me I hope your help
SqlConnection con = new SqlConnection(ConfigurationManager.Co...