Search
 
SCRIPT & CODE EXAMPLE
 

SQL

Assign value to var in SQL

DECLARE @EmpIDVariable int;
SELECT @EmpIDVariable = MAX(EmployeeID)
FROM HumanResources.Employee;
Comment

PREVIOUS NEXT
Code Example
Sql :: postgres check for foreign key 
Sql :: add column if not exists mysql 
Sql :: identify number of rows in sql 
Sql :: use concat in group_concat 
Sql :: postgres set column equal to another 
Sql :: oracle desc table primary key 
Sql :: show all tables postgres 
Sql :: select count 
Sql :: renombrar tabla mysql 
Sql :: concatenate two strings in sql 
Sql :: select nextval from sequence sql 
Sql :: run sql file in terminal 
Sql :: postgresql add column 
Sql :: store select query result in variable sql server 
Sql :: sql select last id 
Sql :: create or replace view postgress 
Sql :: sql pagination 
Sql :: create temporal table in sql 
Sql :: postgresql check privileges on schema 
Sql :: SQL DEFAULT Constraint With Alter Table 
Sql :: convert varchar column to int in sql server 
Sql :: add column postgres with default value 
Sql :: SQL NOT BETWEEN Operator 
Sql :: Get first 10 in sql 
Sql :: print integer and string in SQL 
Sql :: SQL Multiple Cases 
Sql :: SQL Greater Than or Equal to Operator 
Sql :: mysql get first n characters of string 
Sql :: between sql 
Sql :: raiserror nowait sql server 
ADD CONTENT
Topic
Content
Source link
Name
9+5 =