Max() function in SQL Server
Max():- This function gives the maximum value of the selected column
Syntax:-
Select Max (col1) from table_name
In this article, we are...
2014-08-13
831 reads
Vivek Johari
- Interests: SQL, database, Oracle, Big Data, Azure
- Website: https://www.techmixing.com
RTRIM() function in SQL Server
RTRIM():-This function is used to get the string after the removal of all trailing blanks.
Syntax:-
RTRIM ( character_expression )
For example:-
Select RTRIM('Vivek Johari ...
2014-08-13
899 reads
Except command in SQL Server
This function returns the distinct values from the left query that are not also found on the right query. For...
2014-08-12
768 reads
Round() function in SQL Server
Round():-This function is used to round a numeric field to the number of decimals specified.
Syntax:-
ROUND ( numeric_expression , length [ ,function ]
numeric_expression...
2014-08-12
851 reads
SUM() function in SQL Server
Sum():- This function is used to get the sum of values of the specified numeric column.
Syntax:-
Select Sum (column_name) from tablename
Example:-...
2014-08-12
699 reads
Best practices for Database Programming
1. All the tables in the database have properly defined relationship using primary keys and foreign keys .
2. Indexes should...
2014-08-11
2,270 reads
Between function in SQL Server
This function is used to select the values within a specified range. These values can be of Int type or...
2014-08-11
336 reads
Intersection command in SQL Server
This function is used to returns distinct values that are returned by both the query on the left and right...
2014-08-11
1,051 reads
LEFT() function in SQL Server
Left():- This function returns the specified number of characters from the left part of the given character string.
Syntax:-
Select LEFT ( character_expression...
2014-08-11
943 reads
Like() function in SQL Server
Like:- This operator is used in a WHERE clause to search for a specific pattern in the values of the...
2014-08-11
411 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
Running Steve's Code
Comments posted to this topic are about the item Running Steve's Code
New SQL Server 2022 Functions
Comments posted to this topic are about the item New SQL Server 2022 Functions
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers