Thursday, November 19, 2009

How to return data from a table column with white spaces.

Some time data table contains some records with with spaces in starting, if you trying to get all those records of that then you can use bellow mentioned queries.

1) SELECT * FROM table_name WHERE column_name LIKE ' %'

2) SELECT COUNT(*) FROM table_name WHERE PATINDEX(' %', column_name)>0

How to get count of records of any table?

we can get record count using bellow three types:

1) SELECT COUNT(*) FROM table_Name
Output: 306784

1) SELECT COUNT_BIG(*) FROM table_Name
Output: 306784

2) SELECT rows FROM sysindexes WHERE id = OBJECT_ID('table_Name') AND indid < 2
Output: rows:306784

3)exec sp_spaceused 'table_Name',true
Output: table_Name 306784 97112 KB 67328 KB 29384 KB 400 KB

Split the String values with a special character in MS Flow to convert this into Array

 Many times we have a requirement to prepare the Mailing address for some of the documents, suppose there are Address Line1, Address Line2, ...