Software Applications Programming Errors and solutions.

To create View using Union query from one database to another database in SQL you can get hints from below example its very simple your column should be the same type and number of the column should be same to create union query view. USE [TestDB] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO Create VIEW [dbo].[Test_FinancialDimension] AS ( SELECT [key_] ,[NAME] ,[Value] FROM MicrosoftDynamicsAX.dbo.dimattributecompanyinfo union SELECT [key_] ,[NAME] ,[Value] FROM MicrosoftDynamicsAX.dbo.DimAttributeOMCostCenter --union -- SELECT [key_] ,[NAME],[Value] FROM MicrosoftDynamicsAX.dbo.DimAttributeHcmWorker union SELECT [key_] ,[NAME] ,[Value] FROM MicrosoftDynamicsAX.dbo.DIMATTRIBUTEOMDEPARTMENT union SELECT [key_] ,[NAME] ,[Value] FROM MicrosoftDynamicsAX.dbo.DimAttributeOMBusin

Following are the Computer memory measurement details 0 or 1=1bit 8 bits = 1Byte 1024 Bytes =1 Kilobyte 1024 Kilobytes =1Megabyte 1024 Megabytes = 1 Gigabyte 1024 Gigabytes = 1 Terabyte 1024 Terabytes =1 Petabyte 1024 Petabytes =1 Exabyte 1024 Exabytes =1 Zettabyte 1024 Zettabytes=1 Yottabyte 1024 Yottabytes=1 Brontobyte 1024 Brontobytes=1 Geopbyte Geopbyte is the current highest memory measurement.

I want to share one clip which will show you how to check each Table size for all tables, Total Number of records, Disk usage on tables, free spaces for tables in SQL Database. You can see how to write the query to get details of all tables in terms of size, records, space utilization and free space on disk for tables. Just visit this clip to get all details.