代码搜索：sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/361774/2944062
sql testaggregate.sql
SELECT OrderId, SUM(ItemsOrdered) AS SUM, dbo.BakersDozen(ItemsOrdered) AS BakersDozen FROM tblAggregateTest GROUP BY OrderId
SELECT dbo.BakersDozen(13) AS BakersDozen
www.eeworm.com/read/361774/2944063
sql testtypbakersdozen.sql
DECLARE @t AS dbo.typBakersDozen
SET @t = '12'
--SET @t = typBakersDozen::ParseDouble(12)
PRINT @t.RealQty
PRINT @t.AdjustedQty
SET @t.RealQty = 24
PRINT @t.AdjustedQty
SET @t.AdjustedQty
www.eeworm.com/read/361774/2944064
sql testtablevaluedfunction.sql
SELECT * FROM fnPortfolioTable('IBM;MSFT;SUN')
www.eeworm.com/read/361774/2944072
sql predeployscript.sql
IF EXISTS (SELECT * FROM sys.tables WHERE object_id = OBJECT_ID(N'[dbo].[tblPoint]'))
DROP TABLE dbo.tblPoint
IF EXISTS (SELECT * FROM sys.triggers WHERE object_id = OBJECT_ID(N'[Person].[trgUpdateC
www.eeworm.com/read/361774/2944074
sql postdeployscript.sql
CREATE TRIGGER trgUpdateContact
ON Person.Contact
FOR UPDATE
AS EXTERNAL NAME Chapter03.Triggers.trgUpdateContact
go
CREATE TABLE tblPoint(
ID NUMERIC(18, 0) IDENTITY(1,1) NOT NULL,
ThePoint
www.eeworm.com/read/361774/2944085
sql xmlandxquery.sql
/*
Programming SQL Server 2005 (MS Press)
By: Andrew Brust and Stephen Forte
Chapter 4
XQuery, XML, and the XML DataType
Samples By: Stephen Forte (stephenforte@hotmail.com)
*/
--Working wi
www.eeworm.com/read/361774/2944107
sql servicebroker.sql
-- Enable Service Broker
ALTER DATABASE AdventureWorks SET ENABLE_BROKER
USE AdventureWorks
-- Create Message Types
CREATE MESSAGE TYPE [PicklistRequest]
VALIDATION = NONE;
CREATE MESSAGE TYP
www.eeworm.com/read/361774/2944109
sql createcurrencysprocs.sql
/*
This script implements the stored procedures created by the TableAdapter
Wizard in the creation of the Currency DataTable in the AdventureWorks
typed DataSet (in the Chapter08 Visual Studio sa
www.eeworm.com/read/361774/2944110
sql createuspgetnamesandemails.sql
CREATE PROCEDURE uspGetNamesAndEmails
AS
BEGIN
SELECT LastName, EmailAddress FROM Person.Contact
END