What are the pre-defined functions in the sql server?
- 1 Answers
- 1234 Views
- I also Faced
- E-Mail Answers
Answer Posted / Yashpal Singh
"SQL Server offers a wide variety of built-in or pre-defined functions. Here are some examples:
1. Aggregate Functions (SUM, AVG, MAX, MIN, COUNT)
2. String Functions (CONCAT, LEFT, RIGHT, SUBSTRING)
3. Date and Time Functions (GETDATE, DATEADD, DATEDIFF)
4. Mathematical Functions (ABS, SQRT, POWER)
5. Logical Functions (AND, OR, NOT)
6. System Functions (DB_NAME, SERVERPROPERTY, @@SPID)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain “row_number()” in sql server with an example?
What is in place upgrade in sql server?
What is the primary use of the model database?
Is it possible to have clustered index on separate drive from original table location?
How do I start sql server 2017?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Can one drop a column from a table?
Can you index views?
Can we do dml on views?
Does view occupy space?
What kind of problems occurs if we do not implement proper locking strategy?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
Why we use the openxml clause?
What are different types of constraints?
What is a view in sql?
