Friday, July 14, 2023

Ad hoc queries

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

        ,'Data Source=*********;Initial Catalog=****;User ID=**;Password=***

        ).table

at No comments:
Subscribe to: 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...