sql crate database CREATE DATABASE databasename; create new database CREATE DATABASE database;

where id is in list sql select * from table where id in (id1,id2………long list)

where date major today mysql SELECT * FROM users WHERE created >= CURRENT_TIMESTAMP;

what sql stand for Structured Query Language

user defined variables in sql SET @var_name = expr [, @var_name = expr] …

trigger before insert DELIMITER $$ CREATE TRIGGER before_workcenters_insert BEFORE INSERT ON WorkCenters FOR EACH ROW BEGIN DECLARE rowcount INT; SELECT COUNT(*) INTO rowcount FROM WorkCenterStats; IF rowcount > 0 THEN UPDATE WorkCenterStats SET totalCapacity = totalCapacity + new.capacity; ELSE INSERT INTO WorkCenterStats(totalCapacity) VALUES(new.capacity); END IF; END $$ DELIMITER ; trigger before insert CREATE TRIGGER trigger_name […]

sqlite populate database from file command shell sqlite3 test.db sqlite3> .read create-tables.sql

sql ssrs SQL Server Reporting Services(SSRS) is a reporting software that allows you to produce formatted reports with tables in the form of data, graph, images, and charts. These reports are hosted on a server that can be executed any time using parameters defined by the users. It is part of Microsoft SQL Server Services […]

sql server information_schema temp tables SELECT * FROM tempdb.INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME LIKE ‘%XYZ%’ ORDER BY ORDINAL_POSITION

SQL server datetime compare Pressupondo uma tabela utilizador u. year(u.DataInicio) –> Retorna o ano month() –> Retorna o mês day() –> dia Exemplo: u.Ativo = 1 AND year(u.DataInicio)<= 2018