SQL Query to select the rows with same id but different value in another column.

Description:

In this example we explain that how to select the rows with same id but different value in another column (parent column) in SQL Server. Or how to get all rows that have same ID but different value in other column. Or select only those records that have different/multiple values for a particular column in sql server. Or find record in same table with different company id but some other some values.

SQL Query to list number of records in each table in a database

Description:

In this example we explain that how to get total number of record in each table in SQL Server or SQL Query to fetch the total number of record in each table in SQL Server. Sometime you have requirements like list the number of records in each table in a database so different query for different user like sql query that provide the row counts and table names in a database. Or how to fetch the row count for all tables in a SQL Server database.

Keeping track of your row counts can be very useful for budgeting and capacity planning.

Suppose I have 100 table in my SQL Server database and I want to fetch all the table that have more than 500 record in each table so in this situation below is the sql query useful for us.

Below is the query to get exact row counts for all tables in sql server

Retrieve a List of Installed Printers on the Network Using C# in asp.net

Description:

In this example we explain that how to display list of printers in client computer in asp.net using C#.or how to find installed printers on client machine in asp.net.retrieve a list of installed printers on network using C#.

Suppose you have requirements likes to display list of printers on the network so below is the code to display it.