Free Online MS SQL Server 2019 Playground: Practice & Master SQL Skills

SQL code: Upload Copy Format Clear

-- 开启事务 BEGIN TRANSACTION; -- 创建一个名为 NAMES 的表 CREATE TABLE NAMES ( Id int PRIMARY KEY, Name varchar(32) ); -- 在这个表中插入一些记录 INSERT INTO NAMES (Id, Name) VALUES (1, 'Tom'), (2, 'Lucy'), (3, 'Frank'), (4, 'Jane'), (5, 'Robert'); -- 显示表中的所有记录 SELECT * FROM NAMES; -- 创建一个名为 vstu 的视图 CREATE VIEW vstu AS SELECT * FROM NAMES; -- 查询视图中的所有记录 SELECT * FROM vstu; -- 向视图中插入一条记录 INSERT INTO vstu VALUES (6, 'recan'); -- 查询视图中的所有记录 SELECT * FROM vstu;

SQL Server:

Stuck with a problem? Got Error? Ask AI support!

SQL Result: ( preserve ) Copy Clear

The site powered by:

PHP versions: PHP 7.4, PHP 8.0, PHP 8.1, PHP 8.2, PHP 8.3, PHP 8.4
RDBMS versions: MySQL 8.0, MySQL 8.0 Sakila (ReadOnly), MySQL 9.3.0, MariaDB 11.4, MariaDB 11.8, MariaDB 11.8 OpenFlights (ReadOnly), MariaDB 10, MariaDB 10 Sakila (ReadOnly), SQLite 3, SQLite 3 Preloaded, PostgreSQL 10 Bookings (ReadOnly), PostgreSQL 14, PostgreSQL 15, PostgreSQL 16, PostgreSQL 17 + PostGIS, PostgreSQL 17 + PostGIS WorkShop (ReadOnly), PostgreSQL 18, MS SQL Server 2017, MS SQL Server 2019, MS SQL Server 2022, MS SQL Server 2022 AdventureWorks (ReadOnly), MS SQL Server 2025, Firebird 4.0, Firebird 4.0 (Employee), Firebird 5.0, RedDatabase 5.0, Oracle Database 19c (HR), Oracle Database 21c, Oracle Database 26ai, SOQOL, ClickHouse

SQLize | PHPize | SQLtest

Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code

Stuck with a problem? Got Error? Ask AI support!

Save Snippet

SQLize | PHPize | SQLtest

Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code

Stuck with a problem? Got Error? Ask AI support!