SQL Server Topics:
SQL-Transact SQL (T-SQL)
Transact SQL, often called T-SQL, is Microsoft's implementation of the SQL language. Developers for SQL Server database management systems are using T-SQL statements for any application communicating with an instance of SQL Server does so by sending Transact SQL statements to the server. Improve your T-SQL skills with these T-SQL overviews, best practices and stored procedures. In this reference, find out how to script SQL Server backups, why T-SQL in SSIS has pros and cons and what to do about poorly written T-SQL code that's causing SQL Server performance problems.
News:
1 - 2 of 2-
SQL Server freebie: PromptSQL for word completion
SearchSQLServer.com | 23 Nov 2005
News - ...
-
Step 3: Consider using implicit transactions
13 May 2005
Article - ...
Reference & Learning:
1 - 3 of 19-
Supertype and subtype tables in SQL Server
16 Sep 2008
Book Excerpt - ...
-
SQL Server and data manipulation in T-SQL
16 Sep 2008
Book Excerpt - Learn about stored procedures, parameters, triggers and how other T-SQL code functions allow for the manipulation of data in this excerpt from "A Developer's Guide to Data Modeling for SQL Server, Covering SQL Server 2005 and 2008" by Eric Johnson and...
-
How to use SQL Trace definition
19 Mar 2007
Step-by-Step Guide - Use SQL Profiler in your production environment to target poorly performing T-SQL commands in SQL Server 2000 and SQL 2005. Microsoft database expert Michelle Gutzait guides you through SQL Trace, from how to use trace definition through incorporating...
Expert Technical Advice:
1 - 3 of 61-
Programming SMO applications for improved management, automation
07 Jul 2010
Tip - ...
-
Getting ‘trigonometric’ with T-SQL mathematical functions
22 Jun 2010
Tip - ...
-
Applying algebraic and numeric functions in SQL Server 2008
22 Jun 2010
Tip - ...
VIEW ALL Expert Technical Advice ON SQL-Transact SQL (T-SQL)