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
835 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
905 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
774 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
857 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
710 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,286 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
344 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,072 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
950 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
419 reads
Blogs
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Setting PK Names in Redgate Data Modeler
By Steve Jones
A customer was testing Redgate Data Modeler and complained that it auto-generated PK names....
Flyway Tips: AI Deployment Script Descriptions
By Steve Jones
With the AI push being everywhere, Redgate is no exception. We’ve been getting requests,...
Forums
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Semantic Search in SQL Server 2025
Comments posted to this topic are about the item Semantic Search in SQL Server...
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers