Tag: sql server
SQL
SQL Server Database Shrink or Compress
We are always see that our database file(.mdf) is very low, but the log file is too high nearly 10-100%…
SQL
How to Display A for one Condition and B for another condition in single result window of Select statement in SQL Server
To get the result in a single result window, but depending on two different condition you have to display the…
SQL
How to get Row Number with the result of SQL select query?
Try the following code to get Row Number… Thank You
SQL
Temporary Tables in SQL Server
Introduction Temporary table is very useful tool in SQL Server for developer. It provided short term use of data. These…