Problem solve

SQL Transact SQL T SQL

• SQL vs. T-SQL

  SQL Server 2005 and T-SQL do have differences. The advantages and disadvantages would depend user environment as described by SQL Server 2005 expert Adam Machanic. Continue Reading

• How to debug T-SQL stored procedures

  These easy-to-use graphical debugging tools in Visual Studio 2005 will help simplify the process of unit testing your T-SQL code. Continue Reading

• SQL Server 2005 T-SQL debugging alternatives

  With no T-SQL debugger in SQL Server Management Studio you can use Visual Studio 2005's T-SQL debugger, but if you're not a fan of step-debugging, SQL Server 2005 expert Adam Machanic has detailed some alternatives. Continue Reading

• How to find and delete file names

  SQL Server Development expert Joe Toscano suggests working with the FileSystemObject and ActiveX Script Tasks when listing file names in .bak and .trn extensions. View his helpful sample codes. Continue Reading

• Trouble seeing source fields

  SQL Server Development expert Greg Low offers a suggestion about invisible source fields. Continue Reading

• Personalized time column

  SQL Server Development expert Greg Low explains how to display time in the date column.Continue Reading

• Resolving a query error

  SQL Server Development expert Greg Low troubleshoots a WHERE clause error within a query.Continue Reading

• Varchar column errors

  SQL Server Development expert Greg Low troubleshoots the error message, "The sum or average aggregate operation cannot take a varchar data type as an argument".Continue Reading

• Fixing bad coding within a SQL query

  SQL Server Development expert Greg Low troubleshoots a programming issue within a SQL query.Continue Reading

• View SQL Server transaction logs using DBCC

  View SQL Server transaction logs using this undocumented DBCC command.Continue Reading

• Restore basics: How to restore using T-SQL commands

  SQL Server Enterprise Manager may be a quick and easy way to run backups and restores, but T-SQL commands offer much greater flexibility. Find out how to script your SQL Server backups or restores.Continue Reading

• How and where to use CASE

  Business Intelligence expert Eric Brown provides a helpful resource about when to use CASE and other SQL Server tools.Continue Reading

• T-SQL performance problems and solutions

  Don't assume all SQL Server performance problems are database-related. Poorly written T-SQL code could be to blame. Learn about common problems and workarounds in this clinic.Continue Reading

• Stored procedure: Generate code for ad hoc data operations

  Performing ad hoc operations on data typically means having to manually enter T-SQL code in Query Analyzer. Save yourself some trouble with the sp_GenerateQuery routine.Continue Reading

• Script to select specific record from a multiple-records table

  Expert Greg Low explains how to select the correct records when they share an ID.Continue Reading