DECLARE @EmpIDVariable int; SELECT @EmpIDVariable = MAX(EmployeeID) FROM HumanResources.Employee;
Here is what the above code is Doing:
1. Declaring a variable called @EmpIDVariable.
2. Assigning the value of the maximum EmployeeID in the HumanResources.Employee table to the @EmpIDVariable variable.
LENGTH(string) Code language: SQL (Structured Query Language) (sql) Here is what the above code is Doing: 1. We are using the LENGTH function to get the length of the string. 2. We are using the LENGTH function to get the length of the string after removing the spaces. 3. We are subtracting the length of…
SELECT setval(‘tbl_tbl_id_seq’, max(tbl_id)) FROM tbl; Here is what the above code is Doing: 1. It’s creating a sequence called tbl_id_seq. 2. It’s setting the next value of the sequence to be the maximum value of the tbl_id column in the tbl table. 3. It’s setting the default value of the tbl_id column to be the…
mix archive.install hex phx_new mix phx.new . Here is what the above code is Doing: 1. Install the latest version of Elixir. 2. Install the latest version of Erlang. 3. Install the latest version of Phoenix. 4. Create a new Phoenix project.
SELECT sum(BYTES) / 1e6 AS SIZE_MB FROM DBA_SEGMENTS WHERE OWNER = ‘schema_name’; — By type SELECT SEGMENT_TYPE, sum(BYTES) / 1e6 AS SIZE_MB FROM DBA_SEGMENTS WHERE OWNER = ‘schema_name’ GROUP BY SEGMENT_TYPE; — By schema SELECT OWNER, sum(BYTES) / 1e6 AS SIZE_MB FROM DBA_SEGMENTS GROUP BY OWNER ORDER BY SIZE_MB DESC; Here is what the above…
— Copy a table (datas, columns and storage parameters) CREATE TABLE my_new_table AS SELECT * FROM my_source_table; — Use NOLOGGING, and PARALLEL if allowed for faster copy CREATE TABLE my_new_table PARALLEL 10 NOLOGGING AS SELECT /*+ parallel(10) */ * FROM my_source_table; — To create an empty table: CREATE TABLE my_new_table AS SELECT * FROM my_source_table…
ALTER TABLE dbo.User ADD CONSTRAINT ucCodes UNIQUE (fcode, scode, dcode) Here is what the above code is Doing: 1. Create a table called User with the following columns: – id (int, primary key, identity) – fcode (varchar(10), not null) – scode (varchar(10), not null) – dcode (varchar(10), not null) 2. Create a unique constraint on…