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.
Must read
- T-SQL subquery basics: When and how to apply them in SQL Server Tip - Subqueries in T-SQL give admins flexibility when it comes to analyzing the inner details of subsets of data. Learn how to apply subqueries with this comprehensive rundown.
- Combining T-SQL subqueries with operators in SQL Server Tip - Using subqueries with different operators allows admins to collect even more information from T-SQL statement. Learn the basics of each and how to implement them here.
- Programming SMO applications for improved management, automation Tip - SQL Server Management Objects can be very helpful when used with (or even instead of) T-SQL, particularly when it comes to monitoring database backups and space utilization.
News:
1 - 2 of 2-
SQL Server freebie: PromptSQL for word completion
SearchSQLServer.com | 23 Nov 2005
News - This add-on application, available for a 30-day free trial, provides auto-complete functionality as you type for programs used to create SQL statements.
-
Step 3: Consider using implicit transactions
13 May 2005
Article - Get up to speed on server-level options to add another layer of integrity protection.
Reference & Learning:
1 - 3 of 42-
Top 10 SQL Server development tips of 2008
07 Jan 2009
The Year in Review - Here are the top 10 most viewed SQL Server development tips of 2008. From converting date/time values into character types, working with DATETIME and SMALLDATETIME in SQL Server 2005, using a stored procedure to find the size of SQL Server tables and...
-
Supertype and subtype tables in SQL Server
16 Sep 2008
Book Excerpt - Learn how to physically implement supertype and subtype tables and clusters on a SQL Server in this excerpt from "A Developer's Guide to Data Modeling for SQL Server, Covering SQL Server 2005 and 2008" by Eric Johnson and Joshua Jones.
-
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...
Expert Technical Advice:
1 - 3 of 117-
Dissecting the SELECT query syntax in T-SQL
05 Aug 2010
The Reluctant DBA - With so many possible options and extensions, translating complex SELECT statements can be a challenge. DBAs can clear the air by breaking them down piece by piece.
-
T-SQL subquery basics: When and how to apply them in SQL Server
16 Jul 2010
Tip - Subqueries in T-SQL give admins flexibility when it comes to analyzing the inner details of subsets of data. Learn how to apply subqueries with this comprehensive rundown.
-
Combining T-SQL subqueries with operators in SQL Server
16 Jul 2010
Tip - Using subqueries with different operators allows admins to collect even more information from T-SQL statement. Learn the basics of each and how to implement them here.
VIEW ALL Expert Technical Advice ON SQL-Transact SQL (T-SQL)