T-SQL IDENTITY & FK #9

Hard 40 pts New · no attempts yet sql

Topics

Toolliyo edge

SQL Server: T-SQL IDENTITY & FK #9. Write T-SQL against the sample schema.

Static hints

Use TOP instead of LIMIT
ROW_NUMBER() OVER (...)

Toolliyo Coach

Stuck? Get a nudge — not the answer

Progressive help: Nudge → Guide → Approach. Full solution stays behind the Solution tab.

Your solution

Editor is open — no login wall to practice.

Ready — edit the code above and click Run or Submit.

Official solution

CREATE TABLE Orders (
  Id INT IDENTITY(1,1) PRIMARY KEY,
  CustomerId INT NOT NULL,
  Amount DECIMAL(12,2) NOT NULL,
  CreatedAt DATETIME2 DEFAULT SYSUTCDATETIME(),
  CONSTRAINT FK_Orders_Customer FOREIGN KEY (CustomerId) REFERENCES Customers(Id)
);

Prefer Coach (Nudge → Guide → Approach) before revealing. No forced signup.

Explanation

T-SQL: TOP, IDENTITY, DATETIME2, CREATE OR ALTER, window functions — common in .NET/SQL Server interviews.

Prev Next All problems

T-SQL IDENTITY & FK #9

Stuck? Get a nudge — not the answer

Your solution

Official solution

Explanation

Your submissions

Discussion