MSSQL Data formatter

Below is a list of formats and an example of the output.  The date used for all of these examples is "2006-12-30 00:38:54.840".

DATE ONLY FORMATS
Format #	Query	Sample
1	select convert(varchar, getdate(), 1)	12/30/06
2	select convert(varchar, getdate(), 2)	06.12.30
3	select convert(varchar, getdate(), 3)	30/12/06
4	select convert(varchar, getdate(), 4)	30.12.06
5	select convert(varchar, getdate(), 5)	30-12-06
6	select convert(varchar, getdate(), 6)	30 Dec 06
7	select convert(varchar, getdate(), 7)	Dec 30, 06
10	select convert(varchar, getdate(), 10)	12-30-06
11	select convert(varchar, getdate(), 11)	06/12/30
12	select convert(varchar, getdate(), 12)	061230
23	select convert(varchar, getdate(), 23)	2006-12-30
101	select convert(varchar, getdate(), 101)	12/30/2006
102	select convert(varchar, getdate(), 102)	2006.12.30
103	select convert(varchar, getdate(), 103)	30/12/2006
104	select convert(varchar, getdate(), 104)	30.12.2006
105	select convert(varchar, getdate(), 105)	30-12-2006
106	select convert(varchar, getdate(), 106)	30 Dec 2006
107	select convert(varchar, getdate(), 107)	Dec 30, 2006
110	select convert(varchar, getdate(), 110)	12-30-2006
111	select convert(varchar, getdate(), 111)	2006/12/30
112	select convert(varchar, getdate(), 112)	20061230
TIME ONLY FORMATS
8	select convert(varchar, getdate(), 8)	00:38:54
14	select convert(varchar, getdate(), 14)	00:38:54:840
24	select convert(varchar, getdate(), 24)	00:38:54
108	select convert(varchar, getdate(), 108)	00:38:54
114	select convert(varchar, getdate(), 114)	00:38:54:840
DATE & TIME FORMATS
0	select convert(varchar, getdate(), 0)	Dec 12 2006 12:38AM
9	select convert(varchar, getdate(), 9)	Dec 30 2006 12:38:54:840AM
13	select convert(varchar, getdate(), 13)	30 Dec 2006 00:38:54:840AM
20	select convert(varchar, getdate(), 20)	2006-12-30 00:38:54
21	select convert(varchar, getdate(), 21)	2006-12-30 00:38:54.840
22	select convert(varchar, getdate(), 22)	12/30/06 12:38:54 AM
25	select convert(varchar, getdate(), 25)	2006-12-30 00:38:54.840
100	select convert(varchar, getdate(), 100)	Dec 30 2006 12:38AM
109	select convert(varchar, getdate(), 109)	Dec 30 2006 12:38:54:840AM
113	select convert(varchar, getdate(), 113)	30 Dec 2006 00:38:54:840
120	select convert(varchar, getdate(), 120)	2006-12-30 00:38:54
121	select convert(varchar, getdate(), 121)	2006-12-30 00:38:54.840
126	select convert(varchar, getdate(), 126)	2006-12-30T00:38:54.840
127	select convert(varchar, getdate(), 127)	2006-12-30T00:38:54.840
ISLAMIC CALENDAR DATES
130	select convert(nvarchar, getdate(), 130)
131	select convert(nvarchar, getdate(), 131)	10/12/1427 12:38:54:840AM

You can also format the date or time without dividing characters, as well as concatenate the date and time string:

Sample statement	Output
select replace(convert(varchar, getdate(),101),'/','')	12302006
select replace(convert(varchar, getdate(),101),'/','') + replace(convert(varchar, getdate(),108),':','')	12302006004426

ref link: https://www.mssqltips.com/sqlservertip/1145/date-and-time-conversions-using-sql-server/

MySql script to provide tables names and its row count in a DB

SELECT table_name, table_rows
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = '**YOUR SCHEMA**';

SELECT CONCAT(
    'SELECT "', 
    table_name, 
    '" AS table_name, COUNT(*) AS exact_row_count FROM `', 
    table_schema,
    '`.`',
    table_name, 
    '` UNION '
) 
FROM INFORMATION_SCHEMA.TABLES 
WHERE table_schema = '**my_schema**';

ref link: https://stackoverflow.com/questions/286039/get-record-counts-for-all-tables-in-mysql-database

MSSQL server script to provide tables names and its row count in a DB

SELECT 
    TableName = t.NAME,
    TableSchema = s.Name,
    RowCounts = p.rows
FROM 
    sys.tables t
INNER JOIN 
    sys.schemas s ON t.schema_id = s.schema_id
INNER JOIN      
    sys.indexes i ON t.OBJECT_ID = i.object_id
INNER JOIN 
    sys.partitions p ON i.object_id = p.OBJECT_ID AND i.index_id = p.index_id
WHERE 
    t.is_ms_shipped = 0
GROUP BY
    t.NAME, s.Name, p.Rows
ORDER BY 
    s.Name, t.Name

ref link: https://stackoverflow.com/questions/9954775/script-that-provides-the-row-counts-and-table-names