Personal I need to calculate the monthly consumption of licenses used here in the company I work with.
I have a table with the product (dbo.Product) , the number of licenses installed on the server (dbo.License) the date the product was in...
Good evening, friends.
I have installed in a SERVER machine a system that uses SQL SERVER, the client machine is in another city, to connect the two on the same network we made a VPN using the own WIN 7.
The client machine can not access t...
Attempting to call PROC sp_UsuariosVariasTentativasCadastro_Result , which brings up a list according to the form data. But nothing is happening. Can someone help me ?
NOTE: I created all these "layers" but I do not know if they have...
CREATE TABLE pacotes
(
id INT IDENTITY(1,1) PRIMARY KEY NOT NULL,
nome VARCHAR(100),
valor FLOAT,
percentual_max_desconto TINYINT,
);
CREATE TABLE pontos_turisticos
(
id INT IDENTITY(1,1) PRIMARY KEY NOT NULL,
id_ende...
I would like you to exclude the desired record not only from the list but from the bank too, how can I proceed? It is going with the id "0" instead of getting the id of the record I want to delete.
Thisismylist...
//NA CONTROLLER...
[H...
I'm working with PHP and I have about 8000 records currently in DB.
As it is for a web page, I need to make a pagination to be viable reading the data.
As I understand it, I have to do something similar to limit and offset to...
I'm working on an application with asp .net-core + entity -framework-core and with mapping and configuration via fluent-api .
When I insert into the database I get the error that IDENTITY_INSERT is set to OFF .
Follow the Im...
Hello
I would like to know if by means of a SQL statement there is some possibility of aligning the column values to the right. Here's an example below that I can do via C #, but I wanted to do the alignment only via T-SQL:
C # code that w...
Does anyone know how to relate the differences between MySQL and SQL Server, including using LIMIT n,n ? Or if they have a link that lists the differences would be cool.
Example
SELECT * FROM tabela LIMIT 50, 100
What would be the...
I would like a help, I need to change a status of a field in a table, after generating an xml using XStream. How could I do to update the table? At the very moment of executing the xml, or after adding all objects to the list.
public class Cri...