SQL Queries
Ø
For List of All tables from database
select
name from sys.tables;
SUBSTRING ( expression ,start , length )
SELECT SUBSTRING('Nilesh', 1, 1) AS Initial
Result : N
SELECT SUBSTRING('Nilesh', 2, 1) AS InitialResult : i
SELECT SUBSTRING('Nilesh', 3, 1) AS InitialResult : l
SELECT SUBSTRING('Nilesh', 2, 2) AS InitialResult : il