---------------------------------------------------------------------
-- SQL Server 2005XgAhvV[WvO~O
-- 7 ȃXgAhvV[W
---------------------------------------------------------------------

---------------------------------------------------------------------
-- 7.2 VXeXgAhvV[W
---------------------------------------------------------------------

EXEC sys.sp_who

---------------------------------------------------------------------
-- 7.4 gXgAhvV[W
---------------------------------------------------------------------

EXEC sys.xp_cmdshell 'dir C:\'

---------------------------------------------------------------------
-- 7.5 ꎞXgAhvV[W
---------------------------------------------------------------------

CREATE PROCEDURE #dbo.ap_EqId_List
    @Make varchar(50),
    @Model varchar(50)
AS
    SELECT EqId
    FROM dbo.Equipment
    WHERE Make = @Make
    AND Model = @Model
    RETURN

---------------------------------------------------------------------
-- 7.6 O[oꎞXgAhvV[W
---------------------------------------------------------------------

CREATE PROCEDURE ##apEquipment_Insert
    @Make VARCHAR(50),
    @Model VARCHAR(50),
    @EqType VARCHAR(50)
AS
    DECLARE @EqTypeId SMALLINT
    SELECT @EqTypeId = EqTypeId  -- ̃R[h́Ai^Cv̐
    FROM dbo.EqType              -- i^CvIDł邱ƂOƂȂ邪A
    WHERE EqType = @EqType       -- ɂ͖肪̂ŁAǂKvB

INSERT dbo.Equipment(Make, Model, EqTypeId)
VALUES(@Make, @Model, @EqTypeId)

---------------------------------------------------------------------
-- 7.7 [gXgAhvV[W
---------------------------------------------------------------------

EXEC sp_addlinkedserver
    @server = N'RemoteSrv1',
    @srvproduct = N'SQL Server'

EXEC sp_addlinkedsrvlogin
    @rmtsrvname = N'RemoteSrv1',
    @useself = 'false',
    @locallogin = 'usrlocal01',
    @rmtuser = 'usrremote01',
    @rmtpassword = 'passwd'


EXEC [RemoteSrv1].sampledb.dbo.up_proc01

