Easy way to Compare two SQL Server table schemas

SELECT DEV.name as DEV_ColumnName,
PROD.name as PROD_ColumnName,
DEV.is_nullable as DEV_is_nullable,
PROD.is_nullable as PROD_is_nullable,
DEV.system_type_name as DEV_Datatype,
PROD.system_type_name as PROD_Datatype,
DEV.is_identity_column as DEV_is_identity,
PROD.is_identity_column as PROD_is_identity  
FROM sys.dm_exec_describe_first_result_set
(N'SELECT * FROM [Database1].dbo.Employee', NULL, 0) DEV
FULL OUTER JOIN  sys.dm_exec_describe_first_result_set
(N'SELECT * FROM [Database2].dbo.Employee', NULL, 0) PROD
ON DEV.name = PROD.name
 

Comments

Post a Comment

Popular posts from this blog

How to Convert Word Document to PDF using C#

  Document wordDocument = null;             string Sourcepath = ConfigurationSettings.AppSettings["SourcePath"];             string DestinationPath = ConfigurationSettings.AppSettings["DestinationPath"];             DirectoryInfo dirInfo = new DirectoryInfo(Sourcepath);             FileInfo[] wordFiles = dirInfo.GetFiles("*.doc");             foreach (FileInfo wordFile in wordFiles)             {                 object paramSourceDocPath = (Object)wordFile.FullName;                 //(Object)wordFile.Name                 string paramExportFilePath = paramSourceDocPath.ToString().Replace(".doc", ".pdf"); //  string paramExportFilePath = DestinationPath + wordFile.Name.ToString().Replace(".doc", ".xps");                 if (!File.Exists(paramExportFilePath.ToString()))                 {                     Application wordApplication = new Application();                        object paramMissing = Type.M
Read more

How to Get First Day and Last Day of a Current Quarter in SQL Server

To get the first day of the current quarter : SELECT DATEADD(qq, DATEDIFF(qq, 0, GETDATE()), 0) To get the last day of the current quarter : SELECT DATEADD (dd, -1, DATEADD(qq, DATEDIFF(qq, 0, GETDATE()) +1, 0)) To get the first day of the previous quarter SELECT DATEADD(qq, DATEDIFF(qq, 0, GETDATE()) - 1, 0) To get the last day of the previous quarter : SELECT DATEADD(dd, -1, DATEADD(qq, DATEDIFF(qq, 0, GETDATE()), 0)) To get the first day of the next quarter : SELECT DATEADD(qq, DATEDIFF(qq, 0, GETDATE()) + 1, 0) To get the last day of the next quarter : SELECT DATEADD (dd, -1, DATEADD(qq, DATEDIFF(qq, 0, GETDATE()) +2, 0))
Read more