adspace


What are functions in the sql server?

Answer Posted / Varun Kumar Vivek

Functions in SQL Server are predefined procedures that perform a specific action, returning a single value. They can be used to manipulate and transform data within a database. Examples include built-in functions like COUNT(), SUM(), AVG() etc., or user-defined functions (UDFs) created by the developer.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is subquery? Explain the properties of a subquery?

1059


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2295


How do I find query history in sql server?

1024


Can one drop a column from a table?

1089


Does view occupy space?

1019


What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1197


Why use identity in sql server?

1199


How to provide default values to function parameters?

1258


How can you append an identity column to a temporary table?

1070


How to enter binary string literals in ms sql server?

1244


What is the difference between for xml raw and for xml auto?

1117


What are wait types?

1249


What is a coalesce function?

1283


What is sql or structured query language?

1227


Why and when do stored procedure recompile?

1060