Casting in SQL

/****** Script for SelectTopNRows command from SSMS  ******/
SELECT TOP 1000 [Date]
      ,[Time]
      ,[Total_Discharge_Rate]
      ,CAST(Todays_Discharge  AS FLOAT) as Todays_Discharge,Todays_Discharge as old
      ,[Total_Inflow]
      ,[Dam_Available_Quantity]
      ,[Upstream_Level]
      ,[Downstream_Level]
  FROM [BIPS_SYS].[dbo].[Other_Data] where [Date]=cast('10/01/2020' as date)

ad hoc distributed queries

EXEC sp_configure 'show advanced options', 1
RECONFIGURE
GO
EXEC sp_configure 'ad hoc distributed queries', 1
RECONFIGURE
GO

USE [test]

SELECT *
INTO mytable1
FROM OPENDATASOURCE (
        'SQLNCLI'
        ,'Data Source=182.76.144.132;Initial Catalog=****;User ID=***;Password=****'
        ).BARRAGE.dbo.Jamrar
    /*  steps - 
            1-  [mydb1] means our opend connection database 
            2-  mytable1 means create copy table in mydb1 database where we want insert record
            3-  XXX.XX.XX.XXX - another server name.
            4-  mydb2 another server database.
            5-  write User id and Password of another server credential
            6-  mytable2 is another server table where u fetch record from it. */