Get first date of next month SQL

Get first date of next month SQL


SELECT CONVERT(VARCHAR(25),DATEADD(DAY,-(DAY(GETDATE())), DATEADD(MONTH,1,GETDATE())+1),105) First_Date_Next_Month;  

Get last date of current month SQL

Get last date of current month SQL

SELECT CONVERT(VARCHAR(25),DATEADD(DAY,-(DAY(GETDATE())), DATEADD(MONTH,1,GETDATE())),105) Last_Date_Current_Month; 

Get last date of previous month SQL

Get last date of previous month SQL


SELECT CONVERT(VARCHAR(25),DATEADD(DAY,-

(DAY(GETDATE())),GETDATE()),105) Last_Date_Previous_Month;  

Get First Date of Current Month SQL

Get First Date of Current Month SQL

SELECT CONVERT(VARCHAR(25),DATEADD(DAY,-

(DAY(GETDATE()))+1,GETDATE()),105) First_Date_Current_Month; 

Get All table that don’t have identity column

Get All table that don’t have identity column



SELECT name AS Table_Name  
  
FROM sys.tables  
  
WHERE OBJECTPROPERTY(OBJECT_ID,'TableHasIdentity') = 0  
  
ORDER BY Table_Name;

Get All table that don’t have foreign key

Get All table that don’t have foreign key


SELECT name AS Table_Name  
  
FROM sys.tables  
  
WHERE OBJECTPROPERTY(OBJECT_ID,'TableHasForeignKey') = 0  
  
ORDER BY Table_Name; 

Get All table that don’t have primary key

Get All table that don’t have primary key



SELECT name AS Table_Name  
  
FROM sys.tables  
  
WHERE OBJECTPROPERTY(OBJECT_ID,'TableHasPrimaryKey') = 0  
  
ORDER BY Table_Name;