代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/361774/2943805
sql grantsecurity.sql
-- Before running: change 'DataServer' to your server name
USE master
GO
EXEC sp_grantlogin @loginame='DataServer\AdventureWorksSalesTeam'
EXEC sp_grantdbaccess @loginame='DataServer\AdventureWork
www.eeworm.com/read/361774/2943822
sql tblmonthnames.sql
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblMonthNames]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tblMonthNames]
GO
SET ANSI_NULLS ON
GO
SET Q
www.eeworm.com/read/361774/2943824
sql tblfact.sql
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblFact]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tblFact]
GO
CREATE TABLE [dbo].[tblFact] (
[OrderD
www.eeworm.com/read/361774/2944007
sql vwsuppliers.sql
CREATE VIEW dbo.vwSuppliers
AS
SELECT Products.ProductID, Products.ProductName,
Suppliers.CompanyName AS SupplierName
FROM Products INNER JOIN
Suppliers ON Products.SupplierID = Supplier
www.eeworm.com/read/361774/2944008
sql vwemployees.sql
CREATE VIEW vwEmployees AS
SELECT EmployeeID, LastName + ', ' + FirstName AS EmployeeName
FROM Employees
www.eeworm.com/read/361774/2944009
sql vwshippers.sql
CREATE VIEW vwShippers AS
SELECT ShipperId, CompanyName AS ShipperName
FROM Shippers
www.eeworm.com/read/361774/2944010
sql tbltime.sql
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblTime]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tblTime]
GO
CREATE TABLE [dbo].[tblTime] (
[TimeKe
www.eeworm.com/read/361774/2944012
sql vwgeography.sql
CREATE VIEW vwGeography AS
SELECT DISTINCT PostalCode, City, Region AS State, Country
FROM Customers
www.eeworm.com/read/361774/2944013
sql tblfact.sql
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tblFact]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[tblFact]
GO
CREATE TABLE [dbo].[tblFact] (
[OrderD
www.eeworm.com/read/361774/2944014
sql vwproducts.sql
CREATE VIEW vwProducts AS
SELECT Products.ProductID, Products.ProductName, Categories.CategoryName
FROM Products INNER JOIN Categories ON Products.CategoryID = Categories.CategoryID