What do you want to save?
Add Code snippet
New code examples
-
SQL 2021-11-14 05:18:22
fix your error mysql
# ************************************************************ # Sequel Pro SQL dump # Version 4096 # # http://www.sequelpro.com/ # http://code.google.com/p/sequel-pro/ # # Host: localhost (MySQL 5.6.14) # Database: SocialNetwork # Generation Time: 2017-0... Add solution -
SQL 2021-11-13 16:05:07
sql server historical table
CREATE TABLE Department ( DeptID INT NOT NULL PRIMARY KEY CLUSTERED , DeptName VARCHAR(50) NOT NULL , ManagerID INT NULL , ParentDeptID INT NULL , SysStartTime DATETIME2 GENERATED ALWAYS AS ROW START NOT NULL , SysEndTime DATETIME2 GENERATED... Add solution -
TypeScript 2021-11-12 05:38:23
constraints in sql
NOT NULL # Ensures a column cannot have a NULL value UNIQUE # Ensures all values in a column are unique PRIMARY KEY # Identifies a record in a table, is NOT NULL & UNIQUE FOREIGN KEY # References a unique record from another table CHECK # Ens... Add solution -
Other 2021-11-11 19:00:18
postorder traversal without recursion
1.1 Create an empty stack 2.1 Do following while root is not NULL a) Push root's right child and then root to stack. b) Set root as root's left child. 2.2 Pop an item from stack and set it as root. a) If the popped item has a right child and t... Add solution -
SQL 2021-11-11 18:32:12
how to create system versioned table in sql server
CREATE TABLE Department ( DeptID INT NOT NULL PRIMARY KEY CLUSTERED , DeptName VARCHAR(50) NOT NULL , ManagerID INT NULL , ParentDeptID INT NULL , SysStartTime DATETIME2 GENERATED ALWAYS AS ROW START NOT NULL , SysEndTime DATETIME2 GENERATED... Add solution -
SQL 2021-11-11 18:08:10
doctors appointment
-- Table structure for table 'appointment_schedule' CREATE TABLE IF NOT EXISTS 'appointment_schedule' ( 'id' int(11) NOT NULL AUTO_INCREMENT, 'doctors_id' int(11) NOT NULL, 'working_days' varchar(50) NOT NULL, 'morning_time_start' time DEFAULT NUL... Add solution