代码搜索:sql
找到约 10,000 项符合「sql」的源代码
代码结果 10,000
www.eeworm.com/read/464469/1529110
sql employeesdirectreportscte.sql
USE Northwind
GO
WITH DirectReports (Name, EmployeeID, ReportsTo) AS
--Anchor member
(SELECT FirstName + ' ' + LastName, EmployeeID, ReportsTo
FROM Employees
WHERE ReportsTo IS NULL
UNION ALL
www.eeworm.com/read/464469/1529127
sql createnwindendpoint.sql
USE Northwind
GO
IF (SELECT COUNT(*) FROM sys.endpoints WHERE name='NorthwindEP') > 0
DROP ENDPOINT NorthwindEP
GO
CREATE ENDPOINT NorthwindEP
STATE = STARTED
AS HTTP(
PATH = '/wsnwindep'
www.eeworm.com/read/464469/1529173
sql test.sql
-- Execute the scalar user-defined function and stored procedure,
PRINT dbo.cfs_OrderCountByCustomerID('ALFKI');
EXEC dbo.csp_OrdersByCustomerID 'ALFKI';
-- Create a PointUDT
DECLARE @pt PointU
www.eeworm.com/read/464469/1529204
sql xxxtest.sql
EXEC csp_CustomerDataRecord 'RATTC';
EXEC csp_CustomerDataRecord 'ALFKI';
EXEC csp_CustomerDataStream
EXEC csp_SalesOrderXML 11077
EXEC csp_SalesOrderXML_NS 11077
--Following requires installatio
www.eeworm.com/read/464469/1529227
sql point.sql
DECLARE @pt Point
SET @pt = CONVERT(Point, '0,0')
SET @pt.X = 1
SET @pt.Y = 2
PRINT @pt.ToString()
PRINT ''
SET @pt = CONVERT(Point, '2.5,3.6')
PRINT @pt.X
PRINT @pt.Y
PRINT @pt.ToString()
www.eeworm.com/read/464469/1529228
sql address.sql
--Parse separated string and display mailing label (USA)
DECLARE @Addr1 Address
SET @Addr1 = CONVERT(Address, 'Rattlesnake Canyon Grocery;2817 Milton Dr.;Albuquerque;NM;94610-5708;USA')
PRINT @Add
www.eeworm.com/read/464469/1529230
sql addressdefault.sql
--Parse separated string and display mailing label (USA)
DECLARE @Addr1 Address
SET @Addr1 = CONVERT(Address, 'Rattlesnake Canyon Grocery;2817 Milton Dr.;Albuquerque;NM;94610-5708;USA')
PRINT @Addr
www.eeworm.com/read/464469/1529231
sql pointdefault.sql
DECLARE @pt Point
SET @pt = CONVERT(Point, '0,0')
SET @pt.X = 1
SET @pt.Y = 2
PRINT @pt.ToString()
PRINT ''
SET @pt = CONVERT(Point, '2.5,3.6')
PRINT @pt.X
PRINT @pt.Y
PRINT @pt.ToString()
www.eeworm.com/read/464469/1529238
sql test.sql
DECLARE @pt Point
SET @pt = CONVERT(Point, '0,0')
SET @pt.X = 1
SET @pt.Y = 2
PRINT @pt.ToString()
PRINT ''
SET @pt = CONVERT(Point, '2.5,3.6')
PRINT @pt.X
PRINT @pt.Y
PRINT @pt.ToString()
www.eeworm.com/read/464469/1529239
sql createudts.sql
--DROP TYPE [Point];
--DROP TYPE [PointClass];
--DROP TYPE [Address];
--DROP TYPE [AddressBasic];
--DROP ASSEMBLY [UserDefinedTypesCLR];
--Change the path below to correspond to your sample proje