Friday, January 10, 2020

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)
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Ad hoc queries

 select max(cast(convert(varchar, convert(datetime, [CR_DATE], 103), 101) as date))  from OPENDATASOURCE (        'SQLNCLI'         ...

  • EMAIL WITH C#
    private void sendMail()     {         MailMessage msg = new MailMessage();         string ToMail = "*******@gmail.com";      ...
  • Order By REGEX exp
    select * from RES_MSTPLOTMASTER order by regexp_substr(NVL (plotnumber, PLOTNUMBER), '^\D*') nulls first,   to_number(regexp_subs...
  • Difference Between SOAP And REST
       SOAP And REST😋 SOAP REST Slower due to defined specification Faster as there is no defined specifications Request and response format is...