Color code name and values
Saturday, 21 January 2017
Subscribe to:
Posts (Atom)
SQL Query Table Name with Rows Counts
SELECT TableName = t.NAME, TableSchema = s.Name, RowCounts = p.rows FROM sys.tables t INNER JOIN sys.schemas s ...
-
CREATE TAblE #temp ( T_Name VARCHAR(50), T_Times BIGINT ) INSERT INTO #temp(T_Name,T_Times) VALUES ('ASHISH',4) IN... -
Character data is represented in a computer by using standardized numeric codes which have been developed. The most widely accepted code is... -
SELECT distinct(volume_mount_point), total_bytes/1048576 as Size_in_MB, total_bytes/1048576/1024 as Size_in_GB, available_bytes/1048576 ...