how to run querry on microsoft sqlserver

Solutions on MaxInterview for how to run querry on microsoft sqlserver by the best coders in the world

showing results for - "how to run querry on microsoft sqlserver"
Eleonora
15 Apr 2018
1USE [TutorialDB]
2-- Create a new table called 'Customers' in schema 'dbo'
3-- Drop the table if it already exists
4IF OBJECT_ID('dbo.Customers', 'U') IS NOT NULL
5DROP TABLE dbo.Customers
6GO
7-- Create the table in the specified schema
8CREATE TABLE dbo.Customers
9(
10   CustomerId        INT    NOT NULL   PRIMARY KEY, -- primary key column
11   Name      [NVARCHAR](50)  NOT NULL,
12   Location  [NVARCHAR](50)  NOT NULL,
13   Email     [NVARCHAR](50)  NOT NULL
14);
15GO
16