-- Create a sample table CREATE TABLE Users ( UserID INT IDENTITY(1,1) PRIMARY KEY, Username NVARCHAR(100) NOT NULL, Email NVARCHAR(200) UNIQUE, CreatedDate DATETIME2 DEFAULT GETDATE(), IsActive BIT DEFAULT 1 ); GO
-- Create a sample database CREATE DATABASE DevDatabase; GO sql server 2019 developer edition
-- Set max degree of parallelism (adjust as needed) EXEC sp_configure 'max degree of parallelism', 4; RECONFIGURE; -- Create a sample table CREATE TABLE Users
USE DevDatabase; GO
-- Create a useful function CREATE FUNCTION dbo.GetActiveUsers() RETURNS TABLE AS RETURN ( SELECT UserID, Username, Email, CreatedDate FROM Users WHERE IsActive = 1 ); GO 1) PRIMARY KEY
-- Insert sample data INSERT INTO Users (Username, Email) VALUES ('john_doe', 'john@example.com'), ('jane_smith', 'jane@example.com'), ('bob_wilson', 'bob@example.com'); GO