-- Create a sample database CREATE DATABASE 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 sql server 2019 developer edition
-- 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 -- Create a sample database CREATE DATABASE DevDatabase;
-- Create a stored procedure with error handling CREATE PROCEDURE dbo.sp_AddUser @Username NVARCHAR(100), @Email NVARCHAR(200) AS BEGIN BEGIN TRY BEGIN TRANSACTION; Email) VALUES ('john_doe'
USE DevDatabase; GO