SQL Scenario based Interview Questions - 3
Script – DDL and INSERT Sample Data
--Create Table
CREATE TABLE tableDots
(
ID INT
,Value VARCHAR(100)
)
--Insert Data
INSERT INTO tableDots VALUES
(1,'2.3.1.1'),
(2,'4.1.a'),
(3,'a.b.b.b.b.a'),
(4,'3.4.5.6')
--Verify Data
SELECT * FROM tableDots