Sql delete all values in a column
sql delete all values in a column UPDATE TableName SET ColumnName = NULL remove from table where DELETE FROM table_name WHERE condition;
Sql date functions
sql date functions ADDDATE Add a date interval (eg: 10 DAY) to a date (eg: 20/01/20) and return the result (eg: 20/01/30). ADDTIME Add a time interval (eg: 02:00) to a time or datetime (05:00) and return the result (07:00). CURDATE Get the current date. CURRENT_DATE Same as CURDATE. CURRENT_TIME Get the current time. CURRENT_ […]
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