ch03

来源：互联网发布：剑网3秀太捏脸数据编辑：程序博客网时间：2024/06/06 17:55

--1
sp_helpdb
GO
USE Northwind;
EXEC sp_helpfile;
GO
sp_helpserver
GO
sp_helpuser
GO
SP_HELPTEXT SP_HELPDB
GO
SP_HELPTEXT SP_HELPTEXT
GO
sp_who
GO
sp_rename
GO
USE test;
EXEC sp_rename 'alterTable','TEST';
GO

--2-2
CREATE PROC getcurrentdate
AS
BEGIN
PRINT Convert(varchar(15),GETDATE())
RETURN
END
EXEC getcurrentdate

EXEC sp_help 'getcurrentdate'
EXEC sp_helptext 'getcurrentdate'

--4-1
CREATE PROC #SEARCHCUSTOMER
@SearchStr AS VARCHAR(30)
AS
SELECT CustomerID, CompanyName,ContactName,City,Address,Phone
FROM Customers
WHERE CompanyName LIKE '%'+@SearchStr
Return

DECLARE @SearchSTR varchar(30)
SET @SearchSTR ='1'
EXEC #SEARCHCUSTOMER @SearchSTR

--5
EXECUTE sp_serveroption 'JIAYONG-A8UZA20','RPC OUT','true';
EXECUTE [JIAYONG-A8UZA20].northwind.dbo.CountOFOrders --pro
--6
EXECUTE sp_serveroption 'JIAYONG-A8UZA20','RPC OUT','true';
EXECUTE [JIAYONG-A8UZA20].northwind.dbo.[Sales by Year] '1996-1-1','1998-1-1'

--7
SELECT OrderID, ShippedDate, Subtotal
FROM OPENROWSET('SQLOLEDB.1',
'Provider=SQLOLEDB.1;Server=JIAYONG-A8UZA20;
Trusted_Connection=yes;',
'EXECUTE northwind.dbo.[Sales by Year] "1996-1-1","1998-1-1"')

--8
DECLARE @SqlStr AS VARCHAR(50)
DECLARE @SqlParm AS VARCHAR(10)

SET @SqlParm = '1948-1-1'
SET @SqlStr = 'SELECT * FROM Employees WHERE Birthdate<'+''''+ @SqlParm +''''
PRINT @SqlStr
EXEC SP_EXECUTESQL @SqlStr

select * from Hotel where ( HI_Name like '%酒店%'
or HI_ShortName like '%酒店%' )