misaki1301

sp_help categories

sp_help orders

select * from Orders;

select * from Customers;

select * from Suppliers;

misaki1301

--lista de pedidos registrados
create procedure usp_list_employees_2
as
select * from Empleados;

create procedure usp_filter_by_employee
@employeeId int
as
select *
from  Pedidos

misaki1301

CREATE DATABASE PC02
use PC02
go
create table users(
	access char(10) primary key,
	password char(10)
)
go
create table category(
	idCategory char(10) primary key,

misaki1301

create database dw_example2
-----------------------------
use dw_example2
-----------------------------
create table articles(
id int primary key,
name nvarchar(50),
provider int,
category int,
price money,