Norway


Full Text Search: The to Better Natural Language Queries for NoSQL in Node.js

Date: 1/31/ @ 2 p.m. ET

Use the following query to get the of for each in your database:

CREATE TABLE #TempTable  
(  
[Table Name] [varchar](max),  
  
[Total Records] int  

);  
  
EXEC sp_MSForEachTable @command1 = ' Insert Into #Tab(Table_Name, Total_Records) SELECT ''?'', COUNT(*) FROM ?'  
  
SELECT * FROM #TempTable t ORDER BY t.[Total Records] DESC;  
  
DROP TABLE #TempTable;

 

Visit the DevX Tip Bank

 



Source link

LEAVE A REPLY

Please enter your comment!
Please enter your name here