From the course: Microsoft SQL Server 2019 Essential Training
Unlock the full course today
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Use built-in functions - SQL Server Tutorial
From the course: Microsoft SQL Server 2019 Essential Training
Use built-in functions
- [Instructor] All of the functions that SQL Server ships with can be found inside of your database. You can find that by expanding the program ability folder, and then going into the functions folder, and then expanding the system's functions folder. This will reveal a number of different categories. Now if you've ever used Excel, these are comparable to the formula books that organize all of the functions in that program. Expanding each of these folders, for example, the aggregate functions folder will reveal the individual functions that we can use in our sequel scripts. When you hover your mouse over one of these functions, you'll get this little pop up menu that gives you a brief description about what this function does. And if you expand the function, by clicking on the little plus to the left of it, It'll give you information about the parameters, for example, the input and output types. For instance, this counting function will take any data type as an input, text, numbers…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.