Tag: sql
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
How to Retrieve Data From More Than One Row into Columns
Suppose we have one Table named Account as below Act_id Act_Name Tr_Type Amount Balance 1001 Xyz Credit 20000 20000 1001…
SQL
How to get the result as 00 format for month or date of a datetime from SQL?
Hi, One day i need to fetch the month part of a date field of my sql database. i tried…
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…