Sql counter column
sql counter column SELECT my_first_column, my_second_column, ROW_NUMBER() OVER (ORDER BY my_order_column) AS Row_Counter FROM my_table
Roblox hotkey script
roblox hotkey script local UserInputService = game:GetService(“UserInputService”) local spaceHeld = UserInputService:IsKeyDown(Enum.KeyCode.Space)
Lua round number
lua round number local number = 15.57 local number2 = 15.23 print(math.floor(number + 0.5)) –16 print(math.floor(number2 + 0.5)) –15
Lua in pairs
lua in pairs –Table is the table to iterate through –Index is the current index –Value is the value at the current index for index, value in pairs(table) do end
Lua data types
lua data types nil, boolean, number, string, function, userdata, thread, and table
What is a trigger in sql
what is a trigger in sql — Azure SQL Database Syntax — Trigger on an INSERT, UPDATE, or DELETE statement to a table or view (DML Trigger) CREATE [ OR ALTER ] TRIGGER [ schema_name . ]trigger_name ON { table | view } [ WITH <dml_trigger_option> [ ,…n ] ] { FOR | AFTER | […]
Tsql reseed identity
tsql reseed identity USE AdventureWorks2012; GO DBCC CHECKIDENT (‘Person.AddressType’, RESEED, 10); GO
Sqlites studio red exclamation mark when poening databse
sqlites studio red exclamation mark when poening databse Go to view and make sure the databses column is ticked
Sqlite make primary key
sqlite make primary key # SQLite -> //if the primary key has only one column, //you use the PRIMARY KEY column constraint //to define the primary key as follows: CREATE TABLE table_name( column_1 INTEGER NOT NULL PRIMARY KEY, … ); // in case primary key consists of two or //more columns, you use the PRIMARY […]
Sql upsert
sql upsert update table1 set name = ‘val2’, itemname = ‘val3’, itemcatName = ‘val4’, itemQty = ‘val5’ where id = ‘val1’ if @@ROWCOUNT = 0 insert into table1(id, name, itemname, itemcatName, itemQty) values(‘val1’, ‘val2’, ‘val3’, ‘val4’, ‘val5’)