Summary

This chapter discussed the programming extensions beyond typical implementations of SQL that make Transact-SQL a specialized programming language. These extensions include control of flow, conditional branching, looping, variables, logical operations, bitwise operations, and a variety of scalar functions. The extensions let you write sophisticated routines directly in Transact-SQL and execute them directly in the SQL Server engine. Without them, you would have to write much more logic into client applications, which would hurt performance because more conversation would need to take place across the network. We also took a long look at how to use SQL Server 2000 in conjunction with the Search service to maintain and query full-text indexes on your data.

From here, we'll move on to using the Transact-SQL extensions in stored procedures and triggers.



Inside Microsoft SQL Server 2000
Inside Microsoft SQL Server 2000
ISBN: 0735609985
EAN: 2147483647
Year: 2005
Pages: 179
Authors: Kalen Delaney

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net