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
I am running this Blog to help other guys, who are looking some bits and pieces in terms of MS technology....
Thursday, November 19, 2009
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
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
Subscribe to:
Posts (Atom)
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, ...
-
Use the following line of code to Reopen the closed task in CRM 2011 // Re-open the Task to update it SetStateRequest ssr = new SetStat...
-
Use the following line of code to create complete workflow activity with two output parameters. 1) Open Visual Studio 2010 ID. 2) Open ...
-
Sometimes you experienced when you have subgrid in your CRM Form, but when you click the ‘expand’ button to expand the view then it will re...