fork download
copy 
  1. CREATE TABLE #TempTBL (ID INT IDENTITY(1,1), KC1 varchar(10), KC2 varchar(10), KC3 varchar(10), NC1 int, NC2 money, IsON bit)
  2.  
  3. INSERT INTO #TempTBL
  4. SELECT 'ABC','MNO','XYZ',1,1.00,1
  5. UNION ALL
  6. SELECT 'ABC','MNO','XYZ',1,1.00,0
  7. UNION ALL
  8. SELECT 'ABD','MNO','XYZ',1,1.10,1
  9. UNION ALL
  10. SELECT 'ABD','MNO','XYZ',1,1.10,0
  11. UNION ALL
  12. SELECT 'ABD','MNO','XYZ',2,1.00,0
  13. UNION ALL
  14. SELECT 'ABE','MNO','XYZ',1,1.10,1
  15.  
  16. SELECT * FROM #TempTBL
  17.  
Success #stdin #stdout #stderr 0s 3008KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
stderr
copy 
Error: incomplete SQL: CREATE TABLE #TempTBL (ID INT IDENTITY(1,1), KC1 varchar(10), KC2 varchar(10), KC3 varchar(10), NC1 int, NC2 money, IsON bit)

INSERT INTO #TempTBL
SELECT 'ABC','MNO','XYZ',1,1.00,1
UNION ALL
SELECT 'ABC','MNO','XYZ',1,1.00,0
UNION ALL
SELECT 'ABD','MNO','XYZ',1,1.10,1
UNION ALL
SELECT 'ABD','MNO','XYZ',1,1.10,0
UNION ALL
SELECT 'ABD','MNO','XYZ',2,1.00,0
UNION ALL
SELECT 'ABE','MNO','XYZ',1,1.10,1

SELECT * FROM #TempTBL
https://ideone.com/HSLynu
language:
SQLite (sqlite 3.27.2)
created:
11 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!