Showing posts with label Aircel. Show all posts
Showing posts with label Aircel. Show all posts

Friday, 19 July 2019

Bulk SMS Sender ID Codes


Bulk SMS Sender ID Codes



Following table is of Telecom Operator Code.
Provider Code
Airtel A
BSNL B
Datacom Solutions C
Aircel D
Reliance Telecom E
HFCL Infotel H
Idea Cellular I
BPL Mobile/Loop Telecom L
MTNL M
Spice Telecom P
Reliance Communications R
S tel S
Tata Teleservices T
Unitech Group U
Vodafone Group V
Swan Telecom W
Shyam Telecom Y
Following is the table of Regional Code.
Region Code
Andhra Pradesh A
Bihar B
Delhi D
UP-East E
Gujarat G
Haryana H
Himachal Pradesh I
Jammu & Kashmir J
Kolkata K
Kerala L
Mumbai M
North East N
Orissa O
Punjab P
Rajasthan R
Assam S
Tamil Nadu T
West Bengal V
UP-West W
Karnataka X
Madhya Pradesh Y
Maharashtra Z

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 ...