my question is presented, in Sql Server 2000 and Vb6, what I want to do is access with my application to the PC-server from the PC-client to access the data of the database. How do I make that connection? Where do I start ?, Thank you very much...
In a function in SQL Server there is some way to create a table and assign it the value of a query, something like
CREATE TABLE AuxAlumnos
(
Id int,
Nombre varchar (10),
Apellido varchar(10)
);
And to that table assign the...
Hi, I want to create a variable OUT that I will use later, but the following error appears when creating the block:
DECLARE
@COD_PERI INT,
@COD_ESTA_LOG INT OUT
BEGIN
SET @COD_ESTA_LOG = 5
END
Mens. 102, Level 15, State 1,...
I would like to be able to update a field in the same table where the Trigger is triggered, I have read that when the trigger is triggered the table is blocked and can not be modified but it can be done in another way.
CREATE TRI...
How do I make this query:
I have 3 tables A B and C
Table A is related to ID's of Table B .
I need to get the ids of B whose xcampo equals xcampo of C .
now you must update...
Good morning,
With the following C # code, I generate a DropDownList.
public void CargarViaSolicitud()
{
Class.EntidadConexion cnn = new Class.EntidadConexion();
cnn.Conexion().Open();
SqlCommand cmd = new SqlCo...
I have a database with several related tables, a product table related to one of categories, what I want is to show through a <select> all the categories (that I can do) but when selecting a give me all the products that belong to t...
I'm in a PL / SQL database and I need to put together an anonymous script to insert into a configuration table (config and value fields). Something like this:
Config: ‘country’ Value: ‘Argentina’
Config: ‘moneysign’ Value: ‘$’
Config...
Hi, I'm trying to make a temporary row in mysql but I can not do it, if you can achieve how to create a column but I do not know how to make a row. Can somebody help me?
This is the original column
_________________ _______...
I have the following consultation
SELECT
f.SE_Factura,
SE_Consecutivo_Embarque,
f.SE_Orden_De_Compra,
f.SE_Orden_De_Venta,
f.SE_Fecha_OV,
f.SE_Cliente_Despachar_A,
(f.SE_Peso*e.SE_Cantidad_Embarcada)*400 as Peso,...