Skip to content

Instantly share code, notes, and snippets.

USE [master]
GO
/****** Object: Database [productDatabase] Script Date: 12/18/2025 5:20:11 AM ******/
CREATE DATABASE [productDatabase]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N'productDatabase', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL17.MSSQLSERVER\MSSQL\DATA\productDB.mdf' , SIZE = 15360KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
LOG ON
( NAME = N'productDatabase_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL17.MSSQLSERVER\MSSQL\DATA\productDBlog.ldf' , SIZE = 5120KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
WITH CATALOG_COLLATION = DATABASE_DEFAULT, LEDGER = OFF
@IcedW
IcedW / hw1.sql
Created December 18, 2025 02:38
USE [master]
GO
/****** Object: Database [productDatabase] Script Date: 12/18/2025 4:37:13 AM ******/
CREATE DATABASE [productDatabase]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N'productDatabase', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL17.MSSQLSERVER\MSSQL\DATA\productDB.mdf' , SIZE = 15360KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
LOG ON
( NAME = N'productDatabase_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL17.MSSQLSERVER\MSSQL\DATA\productDBlog.ldf' , SIZE = 5120KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
WITH CATALOG_COLLATION = DATABASE_DEFAULT, LEDGER = OFF
USE [master]
GO
/****** Object: Database [productDatabase] Script Date: 12/16/2025 6:11:33 PM ******/
CREATE DATABASE [productDatabase]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N'productDatabase', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL17.MSSQLSERVER\MSSQL\DATA\productDB.mdf' , SIZE = 15360KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
LOG ON
( NAME = N'productDatabase_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL17.MSSQLSERVER\MSSQL\DATA\productDBlog.ldf' , SIZE = 5120KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
WITH CATALOG_COLLATION = DATABASE_DEFAULT, LEDGER = OFF
USE [master]
GO
/****** Object: Database [favMusic] Script Date: 12/11/2025 7:24:11 PM ******/
CREATE DATABASE [favMusic]
CONTAINMENT = NONE
ON PRIMARY
( NAME = N'favMusic', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL17.MSSQLSERVER\MSSQL\DATA\music.mdf' , SIZE = 15360KB , MAXSIZE = UNLIMITED, FILEGROWTH = 10%)
LOG ON
( NAME = N'favMusic_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL17.MSSQLSERVER\MSSQL\DATA\musicLog.ldf' , SIZE = 5120KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
WITH CATALOG_COLLATION = DATABASE_DEFAULT, LEDGER = OFF