Conclusion

Microsoft SQL Server 2005 is a very powerful tool with which to query databases. SQL Server 2005 helps you to obtain data from one or several tables, thereby allowing you to filter, join, and order different sets of data within the same language. By using scalar functions, you can write more comprehensive queries. Output parameters allow you to return scalar data. The new xml datatype presents a new way to not only query relational data, but also to store and return irregular information.