Jump to content

Santos

From Wikipedia, the free encyclopedia

This is an old revision of this page, as edited by 219.90.91.131 (talk) at 06:07, 30 January 2014 (→‎People). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

Santos may refer to:

People

-- USE NORTHWIND SELECT C.CategoryID, P.ProductID FROM Categories AS C CROSS JOIN Products AS P;

-- USE Northwind; SELECT E1.EmployeeID, E1.FirstName, E1.LastName, E2.EmployeeID, E2.FirstName, E2.LastName FROM Employees AS E1 CROSS JOIN Employees AS E2;

-- USE Northwind; SELECT C.CategoryID, C.CategoryName, C.Description, P.* FROM Categories AS C INNER JOIN Products AS P ON C.CategoryID = P.CategoryID

-- USE Northwind; SELECT C.CategoryID, C.CategoryName, C.Description, P.* FROM Categories AS C INNER JOIN Products AS P ON C.CategoryID = P.CategoryID WHERE C.CategoryID = 2

-- USE Northwind; SELECT C.CustomerID, C.CompanyName, O.OrderID, O.OrderDate, E.EmployeeID, E.Lastname, E.Firstname FROM Customers C INNER JOIN Orders O ON C.CustomerID = O.CustomerID INNER JOIN Employees E ON O.EmployeeID=E.EmployeeID WHERE E.EmployeeID=1 AND C.CustomerID LIKE 'T%'

-- USE Northwind; CREATE TABLE OrderDetailsAudit1 ( lsn INT NOT NULL IDENTITY, --log serial number orderid INT NOT NULL, --the key of the modified row productid INT NOT NULL, --the key of the modified row dt DATETIME NOT NULL, --when the change took place loginname sysname NOT NULL, --who made the change columnname sysname NOT NULL, --name of the modified column oldval SQL_VARIANT, --the old value newval SQL_VARIANT, --the new value CONSTRAINT PK_OrderDetailsAudit1 PRIMARY KEY(lsn), CONSTRAINT FK_OrderDetailsAudit1_OrderDetails FOREIGN KEY(orderid, productid) REFERENCES [Order Details](orderid, productid) );

Places

Football clubs

Other uses

See also