SQL vs. T-SQL

by
Adam Machanic

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.

Dear Adam Machanic: Could you provide some detailed information about SQL vs. T-SQL? What are the differences and advantages of using one over the other?

SQL is the Structured Query Language, the ANSI/ISO Standard database language. SQL Server's implementation of the language is called Transact-SQL (T-SQL). T-SQL is based primarily on the version of the ISO standard released in 1992, with bits added from the 1999 standard. In addition, various proprietary enhancements have been made by Microsoft.

There are a number of differences between Standard SQL and T-SQL -- too many to name here. And, yes, there are advantages to using the proprietary extensions if you are working with SQL Server. Due to the nature of many of SQL Server's features, you simply cannot harness its full power without using some nonstandard commands. If you'd like to find out whether your SQL conforms to the standard, you can use the SET FIPS_FLAGGER comma...

Step 2 of 2:

By submitting your personal information, you agree to receive emails regarding relevant products and special offers from TechTarget and its partners. You also agree that your personal information may be transferred and processed in the United States, and that you have read and agree to the Terms of Use and the Privacy Policy.

Safe Harbor

nd.

This was first published in July 2006

Step 3: Consider using implicit transactions

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

E-Handbook

Pricing out the new Windows Azure SQL Database
E-Handbook

Developments in SQL Server BI point to focus on self-service, users

Related Q&A; from Adam Machanic

Determining number of servers needed for large member site

Database servers needed for a site with thousands of users can vary depending on a number of factors, including your necessary level of load ...continue reading

Stored procedure concurrency problems in SQL Server 2005

Multiple readers can sometimes read the same row simultaneously causing a false result. SQL Server 2005 expert Adam Machanic suggests modifying the ...continue reading

Database Snapshots: Creating read-only copies of a database

Database Snapshots feature in SQL Server 2005 Enterprise Edition creates read-only files. For these separate databases, our site expert Adam Machanic...continue reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our SQL Server experts

View all SQL Server questions and answers

SearchBusinessAnalytics

Magic Quadrant shows business intelligence and analytics shift, rift

Gartner's 2015 Magic Quadrant report on business intelligence says more users are gravitating toward decentralized BI platforms -...

Four steps to integrating social media metrics into the BI process

In a book excerpt, Krish Krishnan and Shawn Rogers explore how organizations can take advantage of insights provided by social ...

Cloud integration services emerge strong

The cloud integration services market is one of the fastest growing segments of the platform-as-a-service market. Dozens of ...

SearchDataCenter

New eco UPS systems save energy, minimize operational risks

Eco UPS installations promise higher energy efficiency in the data center, with new designs that respond quickly to an outage.

IoT device explosion challenges data center security

The billions of Internet connected devices in the IoT wave introduce new data center security concerns that IT managers must head...

Two ways to manage different server operating systems

Several tools and techniques let data center systems administrators work with multiple server OSes on one host system, and manage...

SearchDataManagement

How to determine if an in-memory DBMS is right for your company

Database expert Craig S. Mullins examines the pros and cons of the in-memory database management system, and the criteria you ...

Can cognitive computing help users combine big data and analytics?

In a Q&A;, consultant and author Judith Hurwitz discusses the use of cognitive computing systems in big data and analytics ...

Data integration strategy holds together data-driven businesses

Mountains of data are useless to businesses if there is no good way to view and interact with that data. A strong data ...

SearchAWS

Elastic Load Balancing tricks for AWS applications

Improperly configuring Elastic Load Balancing and Auto Scaling Groups in Elastic Beanstalk can harm AWS app performance. Avoid ...

Know the Amazon Elastic Beanstalk app warning signs

Developers can build Web or back-end applications in Elastic Beanstalk. Once the apps are up and running, they can use the ...

Cloud pricing only one factor in bottom line

To get an actual cost of public cloud, look at more than just price per instance. Factor in security, types of service and ...

SearchOracle

Internet of Things and BI meet at Collaborate conference

Shyam Nath will present on the Internet of Things, business intelligence and the analytics cloud at this year's Collaborate 15 ...

Analytics drives Las Vegas at the Collaborate conference

Las Vegas is an analytics-driven city. With the rarity of cities collecting data like Las Vegas does, Oracle has an interest in ...

Collaborate conference needs to go back to square one, says presenter

Michael Brown thinks that the Collaborate conference has gotten away from its roots in education. At Collaborate 15, he is ...

SearchContentManagement

What to expect in SharePoint 2016

How will SharePoint 2016 migrate users to hybrid clouds, and what's in store for integration with SQL Server, Power BI and Office...

DAM spending should stem from digital content needs

A recent survey indicates widespread dissatisfaction with digital asset management software. Unrealistic expectations are likely ...

Microsoft announces SharePoint 2016 beta and details

Microsoft will release a beta version of SharePoint 2016 later this year, and claims it'll feature better mobile, hybrid cloud ...

SearchWindowsServer

Getting acquainted with PowerShell Desired State Configuration

Desired State Configuration is a solid choice for administrators who have PowerShell chops. Here's an introduction.

Patch Tuesday fixes issued for HTTP, Internet Explorer

Microsoft issued patches across 11 bulletins addressing 25 vulnerabilities for April's Patch Tuesday, and rolled out Skype for ...

Microsoft goes small with Nano Server

What's more (or less) Server Core than Server Core? Microsoft's Nano Server, expected in the next release of Windows Server, will...

Dig Deeper on SQL-Transact SQL (T-SQL)

E-Handbook

E-Handbook

Related Q&A; from Adam Machanic

Have a question for an expert?

0 comments

E-Mail

Username / Password

Password

Forgot Password?

Your password has been sent to: