Replace SQL Server new line with HTML
Useful for displaying on HTML when using SQL Server as database For SQL Server In order to replace \r\n with...
SQL Server
Replace SQL Server new line with HTML
Rounding a number to 2 decimal places in SQL SERVER
Use T-SQL Convert Function. Select convert ( decimal(8,2) , 9.4125 ) Output: 9.41
Formatting DateTime to Date in SQL SERVER
Select convert(varchar(10),GetDate(),101) Output: 04/16/2009 Select convert(varchar(10),GetDate(),103) Output: 16/04/2009
Finding duplicates with SQL?
Suppose Col1 is the field name for which you want to find duplicates: Select Col1, Count(Col1) as count from table1...
Difference between Stored Procedures and Views
Here are some of the differences between stored procedures and views Stored Procedures Can accept parameters Can contain multiple statements...
