T-SQL stored procedure raise #44

Medium 30 pts New · no attempts yet sql

Topics

Toolliyo edge

SQL Server: T-SQL stored procedure raise #44. 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

-- SQL Server sample schema
CREATE TABLE Departments (Id INT PRIMARY KEY, Name NVARCHAR(100));
CREATE TABLE Employees (Id INT PRIMARY KEY, Name NVARCHAR(100), Salary INT, DeptId INT, Hired DATE);
INSERT INTO Departments VALUES (1,'Engineering'),(2,'Sales');
INSERT INTO Employees VALUES (1,'Alice',90000,1,'2020-01-15'),(2,'Bob',75000,1,'2021-03-01'),(3,'Carol',82000,2,'2019-06-20'),(4,'Dan',68000,2,'2022-11-05');
CREATE OR ALTER PROCEDURE dbo.RaiseSalary
  @EmpId INT,
  @Pct DECIMAL(5,2)
AS
BEGIN
  SET NOCOUNT ON;
  UPDATE Employees SET Salary = Salary * (1 + @Pct/100.0) WHERE Id = @EmpId;
END;

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 stored procedure raise #44

Stuck? Get a nudge — not the answer

Your solution

Official solution

Explanation

Your submissions

Discussion