T-SQL in Microsoft SQL Server 7

Microsoft SQL Server 7 is leading the way in introducing revolutionary changes to the RDBMS market. Perhaps you have heard about how many of its new features make it easier to manipulate data and objects, and features that improve self-administration and data warehousing. However, the greatest improvements in SQL Server 7 are in the Transact SQL (T-SQL) language, and these deserve special attention.

• Varchar Up to 8000
  The maximum length of char, varchar, binary and varbinary data types has been increased to 8000.
  
• TOP n [PERCENT] extension to the SELECT statement
  This construct returns only the top part of the complete recordset.
  
• Unicode support
  New Unicode data types, nchar, nvarchar, and ntext, have been added to the language.
  
• Deferred name resolution.
  Developers can create a stored procedure that targets a table that does not yet exist (e.g.: during development).
  
• Multiple triggers on a table.
  The ability create more than one trigger on a table allows developers to put each business rule into a separate trigger.
  
• Source Safe support
  You can now make full use Visual Source Safe to maintain control of your code.
  
• Stored procedures debugging
  The ability to debug stored procedures is greatly enhanced.
  
• New functions, stored procedures and SQL statements
  New types provide even greater flexibility.
  
• Use of ADO from TSQL
  You can open an ADO (OLEDB) connection with any data provider from TSQL.