Total number of records of all tables in a MSSQL database

Total number of records of all tables in a MSSQL database


Run the below query agganist the database you want the result

SELECT      QUOTENAME(SCHEMA_NAME(sOBJ.schema_id)),QUOTENAME(sOBJ.name) AS [TableName]      , SUM(sdmvPTNS.row_count) AS [RowCount]FROM      sys.objects AS sOBJ      INNER JOIN sys.dm_db_partition_stats AS sdmvPTNS            ON sOBJ.object_id = sdmvPTNS.object_id
WHERE      sOBJ.type = 'U'
      AND sOBJ.is_ms_shipped = 0x0      AND sdmvPTNS.index_id < 2GROUP BY
      sOBJ.schema_id
      , sOBJ.name      having SUM(sdmvPTNS.row_count)>0ORDER BY [TableName]
GO

If u had any trouble just ask, Happy to help u :)
Stay Tune...
Have a nice day... 'N happy Coding :)

Introducing MathCap for Asp.Net [ Math Captcha Plugin ]

MathCap is a plugin for .net application and its a 100% effective and easy to use.the more you understand on a deep look.

Here i shared is the base version of Mathcap 1.0.0. More feature are coming on a newer versions.

How it use?

add mathcapp dll reference

invoke the namespace on the webpage using MathCapcha;

Add the below code
                var bitmapImage = new Capcha();
                var properties = new MathCapchaProperties();
now customise the properties

now get the response and point to image control, using below code.

               var imgur = bitmapImage.CreateThumbnail(properties);
 
               img.Src = imgur.bmpImageSource; 

               Response.Write(imgur.answer);

Output

NOTE: In near by future itself 'm planning to make it a control but before that i need to add some cool feature that by i made it like this :)

DOWNLOAD dll From here

If u had any trouble just ask, Happy to help u :)
Stay Tune...
Have a nice day... 'N happy Coding :)

GET SET in C#

Get:
The get { } implementation must include a return statement. It can access any member on the class.

Set:
The set { } implementation receives the implicit argument 'value', which is the value to which the property is assigned.