What a good day,
I have a question with SQL Server, how can I use a variable to choose if I want to add the not like or if I do not want to add it, I have this code but it does not work, it puts an error in the temporary table:
DECLARE @option...
I need to know the number of records a field has in SQL SERVER 2008. If I execute the statement:
select count(*) from 'tabla'
the result that throws me is 996.561
but if I execute the sentence:
select count(e-mail) from 'tabla'
the...
I'm trying to save a value in a variable.
I create the table and insert records.
CREATE TABLE #TEMP (IDSOL INT not null PRIMARY KEY ,USUARIO VARCHAR(50) ,LastName varchar(255) NOT NULL,FirstName varchar(255),Age int, )
INSERT INTO #TEMP
V...
Dear,
It turns out that I have a system in visual studio which I wanted to generate a visible query in a datagridview, this gave me error at first, but I realized that as it added a very high amount for an int for it did not work , so I chang...
Good I would like you to help me, I have 100 database and I would like to find a stored procedure, with a query to show me the location of the database that has that procedure:
I have made this script but as long as I am in a specific databas...
I am trying to save a file in a database of SQL SERVER 2008 and I am not managing to send the data to the server side or I am not receiving it well not what I know.
Here is my code:
Front-End
@model PCotiza_compras.Models...
I want to compare the ALIAS hours with the ALIAS
PlanWorkHours and assign the result to a new variable,
however this is not possible since these ALIAS are temporary or do not represent as such
a column of the table, there is some way to implemen...
I'm trying to dig deeper into the connection from VBA using Excel versus MS SQL.
All right with the forced connection putting all the parameters in the data of the macro (name of the server, database, etc.) But I would like to do something mo...
I have the following tables
create table Puesto
(
id_puesto int identity(1,1) primary key not null,
piso int,
cantidad_sillas int,
frente_ventana bit,
cantidad_computadoras int,
cantidad_sillas_adicionales int,
acce...
I have experience programming in Java and I have taken as a personal project to learn .NET languages (VB.NET and C #).
In JAVA, the following is used to create MySQL prepared queries to avoid SQL injection:
public void consultaPreparada()...