I need to create a stored procedure to insert a game into my database. A game relates to a league through the campeonatoJogo table.
The tables are basically:
create table jogo(
codJogo int identity primary key,
nomeTime1 v...
Hello, I have in my database in all tables the following fields
DateTime CreatedEm | Modified DateTime
I wanted to know if there is a way to do a generic trigger to control these fields, since
when you enter, CriadoEm and Modif...
I'm testing Dapper and when I try to use a class I found the error:
Must declare the scalar variable
Follow the code:
public class Teste
{
public int id;
public string nome;
public int idade;
}
using (IDbConnectio...
If I generate my database for MySQL using the concept of Code First can I change it to SQL Server in the future? Do you need to change the classes or just the config and provider ?
Well folks I have a problem with my code. In my database I have a field of type date only that after calling it to the program it also passes me the time, it's something of the genre: 03-18-2015 00:00:00.
What I wanted was just the part o...
Example scenario
I have a database with 1000 tables .
A table named log .
Objective
I would like to create a default trigger on each of these tables, automatically .
This trigger , whenever there is any change (inser...
I need to make a script to convert all user records into a table in this format (single field):
INFORMATICA\desenvolvedor
ADMINISTRACAO\contador
That is, before the uppercase bar and then the lower bar. How to do this in SQL Server?
Cu...
I have to generate an auto increment of type "000"+id , but I can not get to something concrete, my base is this below, I just wanted a light how to do it, I do not need the answer itself. >
@Id
@GeneratedValue...
I need to import a excel file into a SQL table.
However, I need to pick up the lines and go through them, since it will not be
all the information I will get from excel.
I have exactly what I need but get TXT file, but the informat...