Wednesday, March 1, 2023

SQL Date Format

This query will return date and time required fields.

 SELECT ENTRY_DATE ,

  CONVERT(varchar,ENTRY_DATE,100) DateTime,

  CONVERT(varchar,ENTRY_DATE,10) Date ,

  CONVERT(varchar,ENTRY_DATE,108) Time ,

  substring(CONVERT(varchar,ENTRY_DATE,106),1,2) Day,

  substring(CONVERT(varchar,ENTRY_DATE,106),4,3) CMonth,

  substring(CONVERT(varchar,ENTRY_DATE,105),4,2) NMonth,

  substring(CONVERT(varchar,ENTRY_DATE,106),8,4) Year,

  left(right(CONVERT(varchar,ENTRY_DATE,100),7),2) Hours_12,

  substring(CONVERT(varchar,ENTRY_DATE,108),1,2) Hours_24,

  substring(CONVERT(varchar,ENTRY_DATE,108),4,2) Minutes,

  substring(CONVERT(varchar,ENTRY_DATE,108),7,2) Second,

  right(CONVERT(varchar,ENTRY_DATE,100),2) AM_PM from DCR_AUTO_INSERT_LOG

Tuesday, March 30, 2021

SQL Server Service Start Error

Workaround Problem and Solution

 1. Error: 

"The request failed or the service did not respond in a timely fashion.

    Consult the event log or other applicable error logs for details."

Script Level Upgrade for Database ‘master’ Failed Because Upgrade Step

2. Solution for this . Use command to start SQL Service

Whenever script failure issue we are using trace flag 902.

NET START MSSQL$SQLEXPRESS /T902

EXEC sys.sp_configure N'query governor cost limit', N'0'
GO
RECONFIGURE WITH OVERRIDE
GO



When restoring database it is showing below error.

'5 (Access is denied.)' error during restoring database

Check Log On As with Local System.


Wednesday, March 17, 2021

#1 Pencil Art

Pencil Art

Pencil Art

Types of pencil for drawing

  1. H(Hard)
    1. softer to hardness
    2. 9H,8H,7H,6H,5H,4H,3H,2H,H
  2. B(Black)
    1. softer to hardness
    2. B,2B,3B,4B,5B,6B,7B,8B, 9B
  3. HB(Hard Black)
    1. HB
Follow the below blog for more details regarding penchil art.

Pencils.com

Sunday, October 4, 2020

COVID-19 lockdown and unlock in India

Coronavirus disease 2019 (COVID-19) pandemic in India

The first Covid-19 confirm case on 30 Jan 2020 in the state of Kerala.
Government step for lockdown.
1. 22 Mar 2020 Public Curfew.
2. First lockdown for 21 days between 25 Mar 2020 to 14 Apr  2020.
3. Second lockdown for 19 days between 15 Apr 2020 to 3 May 2020.
4. Third lockdown for 14 days between 4 May 2020 to 17 May 2020.
5. Fourth lockdown for 14 days between 18 May 2020 to 31 May 2020.

Government step for unlock.

1.Unlock 1.0 for 30 days between 1 Jun 2020 to 30 Jun 2020.
2. Unlock 2.0 for 31 days between 1 Jul 2020 to 31 Jul 2020.
3. Unlock 3.0 for 31 days between 1 Aug 2020 to 31 Aug 2020.
4. Unlock 4.0 for 30 days between 1 Sep 2020 to 30 Sep 2020.
5. Unlock 5.0 for 31 days between 1 Oct 2020 to 31 Oct 2020.
6. Unlock 6.0 for 30 days between 1 Nov 2020 to 30 Nov 2020.
7. Unlock 7.0 for 31 days between 1 Dec 2020 to 31 Dec 2020.
8. Unlock 8.0 for 31 days between 1 Jan 2021 to 31 Jan 2021.

COVID-19 vaccine is scheduled for roll-out in the country on 16th January 2021.

1st vaccine- Covishield (AstraZeneca and Oxford University) Serum Institute of India
2nd vaccine- Covaxin (Bharat Biotech, Indian Council of Medical Research)

These two vaccine allow for emergency use approved by the drugs controller general of India.

The COVID-19 Vaccine Intelligence Network (Co-WIN) system, a digital platform will be used to track the enlisted beneficiaries for vaccination and COVID-19 vaccines on a real-time basis in India.