WHY I CAN'T WRITE QUERY ANH RUN? PLEASE HELP ME! PLEASE.

63 views
Skip to first unread message

K.Huynh.

unread,
Sep 13, 2020, 12:52:59 PM9/13/20
to rextester

lOOOOOOOOOOOOOOOO.png

I write SQL Server query but it can run.
errors in here.

I don't know how to run code in https://rextester.com/l/sql_server_online_compiler.

Please help me run it.

Thank you <3 

Varun Sood

unread,
Nov 30, 2020, 10:34:18 PM11/30/20
to rextester
You cannot create a database in rextester editor because you are already in the database. You can directly create tables...


--Sql Server 2014 Express Edition
--Batches are separated by 'go'

--select @@version as 'sql server version'

CREATE TABLE Persons (
    PersonID int,
    LastName varchar(255),
    FirstName varchar(255),
    Address varchar(255),
    City varchar(255)
);
insert into Persons values (1, 'ln', 'fn', 'address', 'cty')
select * from Persons
Reply all
Reply to author
Forward
0 new messages