GET LIST OF TABLES WITH ROWS COUNT in SQL SERVER

-

 SELECT o.NAME,

  i.rowcnt 

FROM sysindexes AS i

  INNER JOIN sysobjects AS o ON i.id = o.id 

WHERE i.indid < 2  AND OBJECTPROPERTY(o.id, 'IsMSShipped') = 0

ORDER BY i.rowcnt desc

Comments

Post a Comment

Popular posts from this blog

Uploading Image to Sql Server Image Datatype in asp.net using fileupload Control

-
Uploading Image to Sql Server Image Datatype in asp.net using fileupload Control  Byte[] imgbyte = null;  if (FileUpload1.HasFile)             {                 string fileName = Path.GetFileName(FileUpload1.PostedFile.FileName);                 FileUpload1.PostedFile.SaveAs(Server.MapPath("~/UserPhoto/") + DateTime.Now.ToString("_MMddyyyy_HHmmss") + fileName);                 photo = "UserPhoto/" + DateTime.Now.ToString("_MMddyyyy_HHmmss") + fileName;                 string fpathPhoto = Server.MapPath(photo);                 FileInfo fInfo = new FileInfo(fpathPhoto);                 long numBytes = fInfo.Length;                 //Open FileStream to read...
Read more

Get Running Sum of Query SQL Query

-
 select RequestNo,FileName,PaymentStatus,count(0) as TxnCount,SUM(PaidAmount) as Amount ,SUM(SUM(PaidAmount)) over(Order by RequestNo) as RunningSum from Tbl_T_CommunityPaymentOnline where  IsDeleted is null and RequestNo>=131 and PaymentStatus='Inprocess' group by RequestNo,PaymentStatus,FileName
Read more
-
Image
G H RAISONI INSTITUTE OF BUSINESS MANAGEMENT HAS ORGANISED PINNACLE 2014. THAT INVOLVES PROGRAMS LIKE POSTER PRESENTATION, IT QUIZ , C & C++ PROGRAMMING CONTEST & COMPUTER GAMING COMPITITION.DATE WILL BE ANNOUNCED SOON.
Read more