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
Subscribe to:
Post Comments (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, ...
-
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...
-
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 ...
No comments:
Post a Comment