What is a functions and types in sql server?



What is a functions and types in sql server?..

Answer / Shiv Ram Verma

In SQL Server, a function is a precompiled piece of Transact-SQL code that returns a single value. Functions can be used to perform repetitive tasks or calculations.nTypes are user-defined data types (UDT) that allow you to create custom data structures to better manage and validate data in your database.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Mention the different types of replication in sql server.

1 Answers  


Difference between report and query parameter. Why do we need different type of parameter?

1 Answers  


what is for foreign key ??

4 Answers   CarrizalSoft Technologies, Sabic,


What are the different types of joins and what does each do?

2 Answers  


How to provide values to stored procedure parameters in ms sql server?

1 Answers  


What stored by the msdb?

1 Answers  


Explain the steps to create and execute a user-defined function in the sql server?

1 Answers  


What is triggers and its types?

1 Answers  


What is standby servers? Explain types of standby servers.

0 Answers  


When we should use and scope of @@identity?

1 Answers  


What is the main purpose of having conversation group?

1 Answers  


Explain about sql server login?

1 Answers  


Categories