代码搜索结果
找到约 10,000 项符合
Design 的代码
design_page 39 to page 68.txt
SELECT * FROM Employees
SELECT * FROM Employees_View
ALTER TABLE Employees ADD CONSTRAINT DF_DateHired DEFAULT '1/1/2000' FOR DateHired
INSERT Employees_View (FirstName, LastName, D
design_page 109 to page 136.txt
CREATE PROCEDURE UpdateProductWithLog
@ProductID int,
@DeductQty int
AS
DECLARE @Err int, @Rcount int, @Msg varchar(100)
UPDATE ProductList SET QtyInStock = QtyInStock - @DeductQty
WHERE Pr
design_page 69 to page 108.txt
ALTER TABLE ProductList
ADD CONSTRAINT CK_QtyInStock CHECK (QtyInStock >= 0)
SELECT * FROM ProductList
UPDATE ProductList SET QtyInStock = QtyInStock - 20 WHERE ProductID = 3
CR
design_page 1 to page 38.txt
CREATE DATABASE MyData ON
(NAME = DataFile, FILENAME = 'C:\MyData\DataFile.mdf', SIZE = 2)
LOG ON (NAME = LogFile, FILENAME = 'C:\MyData\LogFile.ldf', SIZE = 2)
USE Sample
CREATE TABLE Produ