SELECT
name AS ProcedureName,
SCHEMA_NAME(schema_id) AS SchemaName,
create_date,
modify_date
FROM sys.objects
WHERE type = 'P'
ORDER BY name;| ProcedureName | SchemaName | create_date | modify_date |
|---|
SELECT
name AS ProcedureName,
SCHEMA_NAME(schema_id) AS SchemaName,
create_date,
modify_date
FROM sys.objects
WHERE type = 'P'
ORDER BY name;| ProcedureName | SchemaName | create_date | modify_date |
|---|
CREATE PROCEDURE GetCategories
AS
BEGIN
-- Select all data from the Categories table
SELECT *
FROM production.categories;
ENDSELECT
name AS ProcedureName,
SCHEMA_NAME(schema_id) AS SchemaName,
create_date,
modify_date
FROM sys.objects
WHERE type = 'P'
ORDER BY name;| ProcedureName | SchemaName | create_date | modify_date |
|---|---|---|---|
| GetCategories | dbo | 2026-11-19 07:03:45 | 2026-11-19 07:03:45 |
EXEC GetCategories;| category_id | category_name |
|---|---|
| 1 | CHILDREN BICYCLES |
| 2 | COMFORT BICYCLES |
| 3 | CRUISERS BICYCLES |
| 4 | CYCLOCROSS BICYCLES |
| 5 | ELECTRIC BIKES |
| 6 | MOUNTAIN BIKES |
| 7 | ROAD BIKES |
| 88 | Hybrid Bikes |
| 90 | Super-Hybrid Bikes (done with a commit transaction) |
| 99 | Hybrid Bikes Turbo |
CREATE PROCEDURE GetCategoryById @CategoryID INT
AS
BEGIN
-- Select data from the Categories table for the specified CategoryID
SELECT *
FROM production.categories
WHERE category_id = @CategoryID;
END| ProcedureName | SchemaName | create_date | modify_date |
|---|---|---|---|
| GetCategories | dbo | 2026-11-19 07:03:45 | 2026-11-19 07:03:45 |
| GetCategoryById | dbo | 2026-11-19 07:03:45 | 2026-11-19 07:03:45 |
EXEC GetCategoryById @CategoryID = 1;| category_id | category_name |
|---|---|
| 1 | CHILDREN BICYCLES |
DROP PROCEDURE GetCategories;
DROP PROCEDURE GetCategoryById;SELECT
name AS FunctionName,
SCHEMA_NAME(schema_id) AS SchemaName,
type_desc AS FunctionType,
create_date,
modify_date
FROM sys.objects
WHERE type IN ('FN', 'TF', 'IF')
ORDER BY name;| FunctionName | SchemaName | FunctionType | create_date | modify_date |
|---|
CREATE FUNCTION GetBrands()
RETURNS TABLE
AS
RETURN (
SELECT *
FROM production.brands
);SELECT
name AS FunctionName,
SCHEMA_NAME(schema_id) AS SchemaName,
type_desc AS FunctionType,
create_date,
modify_date
FROM sys.objects
WHERE type IN ('FN', 'TF', 'IF')
ORDER BY name;| FunctionName | SchemaName | FunctionType | create_date | modify_date |
|---|---|---|---|---|
| GetBrands | dbo | SQL_INLINE_TABLE_VALUED_FUNCTION | 2026-11-19 07:03:45 | 2026-11-19 07:03:45 |
SELECT * FROM GetBrands();| brand_id | brand_name |
|---|---|
| 1 | Electra |
| 2 | Haro |
| 3 | Heller |
| 4 | Pure Cycles |
| 5 | Ritchey |
| 6 | Strider |
| 7 | Sun Bicycles |
| 8 | Surly |
| 9 | Trek |
CREATE FUNCTION GetBrandName ( @BrandID INT )
RETURNS NVARCHAR(100)
AS
BEGIN
DECLARE @BrandName NVARCHAR(100);
SELECT @BrandName = brand_name
FROM production.brands
WHERE brand_id = @BrandID;
RETURN @BrandName;
END;| FunctionName | SchemaName | FunctionType | create_date | modify_date |
|---|---|---|---|---|
| GetBrandName | dbo | SQL_SCALAR_FUNCTION | 2026-11-19 07:03:45 | 2026-11-19 07:03:45 |
| GetBrands | dbo | SQL_INLINE_TABLE_VALUED_FUNCTION | 2026-11-19 07:03:45 | 2026-11-19 07:03:45 |
SELECT GetBrandName(1) AS BrandName;| BrandName |
|---|
| Electra |
DROP FUNCTION GetBrands;
DROP FUNCTION GetBrandName;