如何在查询链接服务器中输入ip [英] how to enter ip in query linked server

问题描述

我有以下查询如何在查询中输入服务器 IP，请帮助我，

i have follwing query how to enter server IP in my query, please help me,

DECLARE @ScopeIdentity int;

    EXEC 175.120.124.162.Taxi.sp_executesql N'INSERT INTO [175.110.104.162].Taxi.dbo.booking (FromLocTypeId,ToLocTypeId,FromLocId,ToLocId,VehicleTypeId,DriverId,ReturnDriverId,CustomerId,CustomerName,CustomerEmail,CustomerPhoneNo,CustomerMobileNo,JourneyTypeId,BookingNo,BookingDate,NoofPassengers,NoofLuggages,NoofHandLuggages,PickupDateTime,ReturnPickupDateTime,IsCompanyWise,CompanyId,FareRate,PaymentTypeId,SpecialRequirements,FromAddress,ToAddress,FromPostCode,ToPostCode,FromDoorNo,ToDoorNo,FromStreet,ToStreet,FromFlightNo,FromComing,BookingStatusId,DistanceString,AutoDespatch,AutoDespatchTime,AddOn,AddBy,AddLog,EditOn,EditBy,EditLog,OrderNo,PupilNo,ParkingCharges,WaitingCharges,ExtraDropCharges,MeetAndGreetCharges,CongtionCharges,TotalCharges,DepartmentId,ReturnFareRate  
    ,ArrivalDateTime,MasterJobId,DisablePassengerSMS,DisableDriverSMS,IsCommissionWise,DriverCommission,DespatchDateTime,JobOfferDateTime,BookingTypeId,DriverCommissionType,IsBidding,IsQuotation,CostCenterId,CashRate,AccountRate,WaitingMins  
    ,ExtraMile,AcceptedDateTime,POBDateTime,STCDateTime,ClearedDateTime,CancelReason,TotalTravelledMiles,CompanyPrice,SubCompanyId,PartyId,
    FromOther,ToOther,TransferJobId,TransferJobCommission,BookingTypeId,ViaString) 

    SELECT   
    FromLocTypeId,ToLocTypeId,FromLocId,ToLocId,VehicleTypeId,null,ReturnDriverId,CustomerId,CustomerName,CustomerEmail,CustomerPhoneNo,CustomerMobileNo,JourneyTypeId,BookingNo,BookingDate,NoofPassengers,NoofLuggages,NoofHandLuggages,PickupDateTime,ReturnPickupDateTime,IsCompanyWise,null,FareRate,PaymentTypeId,SpecialRequirements,FromAddress,ToAddress,FromPostCode,ToPostCode,FromDoorNo,ToDoorNo,FromStreet,ToStreet,FromFlightNo,FromComing,BookingStatusId,DistanceString,AutoDespatch,AutoDespatchTime,AddOn,AddBy,AddLog,EditOn,EditBy,EditLog,OrderNo,PupilNo,ParkingCharges,WaitingCharges,ExtraDropCharges,MeetAndGreetCharges,CongtionCharges,TotalCharges,DepartmentId,ReturnFareRate
    ,ArrivalDateTime,MasterJobId,DisablePassengerSMS,DisableDriverSMS,IsCommissionWise,DriverCommission,DespatchDateTime,JobOfferDateTime,BookingTypeId,DriverCommissionType,IsBidding,IsQuotation,CostCenterId,CashRate,AccountRate,WaitingMins  
    ,ExtraMile,AcceptedDateTime,POBDateTime,STCDateTime,ClearedDateTime,CancelReason,TotalTravelledMiles,CompanyPrice,1,@PartyId
    ,FromOther,ToOther,@JOB_id,@Commission,10,ViaString

    FROM Booking  
    WHERE Id = @JOB_id  ;select SCOPE_IDENTITY()';
    SELECT  @ScopeIdentity;

IP 地址显示错误如何输入链接服务器名称，我想要 Scopeidentity，

IP address show me error how to enter linked server name, i want Scopeidentity,

推荐答案

Remote Stored Procedure可以称为四部分名称:

Remote Stored Procedure can be called as four part name:

EXEC [RemoteServer] .DatabaseName.DatabaseOwner.StoredProcedureName

我不确定您为什么使用动态 SQL.试试这个.

I am not sure why are you using dynamic SQL. Try like this.

DECLARE @ScopeIdentity INT;

INSERT INTO [175.110.104.162].Taxi.dbo.booking (
    FromLocTypeId
    ,ToLocTypeId
    ,FromLocId
    ,ToLocId
    ,VehicleTypeId
    ,DriverId
    ,ReturnDriverId
    ,CustomerId
    ,CustomerName
    ,CustomerEmail
    ,CustomerPhoneNo
    ,CustomerMobileNo
    ,JourneyTypeId
    ,BookingNo
    ,BookingDate
    ,NoofPassengers
    ,NoofLuggages
    ,NoofHandLuggages
    ,PickupDateTime
    ,ReturnPickupDateTime
    ,IsCompanyWise
    ,CompanyId
    ,FareRate
    ,PaymentTypeId
    ,SpecialRequirements
    ,FromAddress
    ,ToAddress
    ,FromPostCode
    ,ToPostCode
    ,FromDoorNo
    ,ToDoorNo
    ,FromStreet
    ,ToStreet
    ,FromFlightNo
    ,FromComing
    ,BookingStatusId
    ,DistanceString
    ,AutoDespatch
    ,AutoDespatchTime
    ,AddOn
    ,AddBy
    ,AddLog
    ,EditOn
    ,EditBy
    ,EditLog
    ,OrderNo
    ,PupilNo
    ,ParkingCharges
    ,WaitingCharges
    ,ExtraDropCharges
    ,MeetAndGreetCharges
    ,CongtionCharges
    ,TotalCharges
    ,DepartmentId
    ,ReturnFareRate
    ,ArrivalDateTime
    ,MasterJobId
    ,DisablePassengerSMS
    ,DisableDriverSMS
    ,IsCommissionWise
    ,DriverCommission
    ,DespatchDateTime
    ,JobOfferDateTime
    ,BookingTypeId
    ,DriverCommissionType
    ,IsBidding
    ,IsQuotation
    ,CostCenterId
    ,CashRate
    ,AccountRate
    ,WaitingMins
    ,ExtraMile
    ,AcceptedDateTime
    ,POBDateTime
    ,STCDateTime
    ,ClearedDateTime
    ,CancelReason
    ,TotalTravelledMiles
    ,CompanyPrice
    ,SubCompanyId
    ,PartyId
    ,FromOther
    ,ToOther
    ,TransferJobId
    ,TransferJobCommission
    ,BookingTypeId
    ,ViaString
    )
SELECT FromLocTypeId
    ,ToLocTypeId
    ,FromLocId
    ,ToLocId
    ,VehicleTypeId
    ,NULL
    ,ReturnDriverId
    ,CustomerId
    ,CustomerName
    ,CustomerEmail
    ,CustomerPhoneNo
    ,CustomerMobileNo
    ,JourneyTypeId
    ,BookingNo
    ,BookingDate
    ,NoofPassengers
    ,NoofLuggages
    ,NoofHandLuggages
    ,PickupDateTime
    ,ReturnPickupDateTime
    ,IsCompanyWise
    ,NULL
    ,FareRate
    ,PaymentTypeId
    ,SpecialRequirements
    ,FromAddress
    ,ToAddress
    ,FromPostCode
    ,ToPostCode
    ,FromDoorNo
    ,ToDoorNo
    ,FromStreet
    ,ToStreet
    ,FromFlightNo
    ,FromComing
    ,BookingStatusId
    ,DistanceString
    ,AutoDespatch
    ,AutoDespatchTime
    ,AddOn
    ,AddBy
    ,AddLog
    ,EditOn
    ,EditBy
    ,EditLog
    ,OrderNo
    ,PupilNo
    ,ParkingCharges
    ,WaitingCharges
    ,ExtraDropCharges
    ,MeetAndGreetCharges
    ,CongtionCharges
    ,TotalCharges
    ,DepartmentId
    ,ReturnFareRate
    ,ArrivalDateTime
    ,MasterJobId
    ,DisablePassengerSMS
    ,DisableDriverSMS
    ,IsCommissionWise
    ,DriverCommission
    ,DespatchDateTime
    ,JobOfferDateTime
    ,BookingTypeId
    ,DriverCommissionType
    ,IsBidding
    ,IsQuotation
    ,CostCenterId
    ,CashRate
    ,AccountRate
    ,WaitingMins
    ,ExtraMile
    ,AcceptedDateTime
    ,POBDateTime
    ,STCDateTime
    ,ClearedDateTime
    ,CancelReason
    ,TotalTravelledMiles
    ,CompanyPrice
    ,1
    ,@PartyId
    ,FromOther
    ,ToOther
    ,@JOB_id
    ,@Commission
    ,10
    ,ViaString
FROM Booking
WHERE Id = @JOB_id;

SELECT SCOPE_IDENTITY()

这篇关于如何在查询链接服务器中输入ip的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！