SQL-Transact SQL (T-SQL)

SQL-Transact SQL (T-SQL) Get Started

Bring yourself up to speed with our introductory content

• SQL CONSTRAINT clauses: FOREIGN KEY, CHECK and DEFAULT

  In SQL Server, SQL CONSTRAINT clauses let you control values entered into a column. Learn about FOREIGN KEY, CHECK and DEFAULT constraints here. Continue Reading

• How to create a SQL inner join and outer join: Basics to get started

  When you're querying a SQL Server database and want to pull related data from more than one table, you'll need to create a join, and here's how. Continue Reading

• Top 10 SQL Server development questions

  Development in SQL Server can put you in a crunch and seeking for a quick solution. We've compiled a Top 10 list of your frequently asked questions when it comes to SQL Server development. In this quick reference you'll get solutions to combat ... Continue Reading

Evaluate SQL-Transact SQL (T-SQL) Vendors & Products

Weigh the pros and cons of technologies, products and projects you are considering.

• How to improve OLTP with SQL Server 2014 In-Memory

  Basit Farooq explains how to improve the performance of OLTP applications using SQL Server 2014 In-Memory. He details what makes SQL Server 2014 In-Memory different from other in-memory database engines and how to use that to your advantage. Continue Reading

• Digging deeper with T-SQL system functions and language tools

  Learn how system functions can be used in T-SQL to view general session and system information along with other types of data in Microsoft SQL Server. Continue Reading

• Top 10 SQL Server development tips of 2008

  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 ... Continue Reading

Product Reviews

• Pros: Flexible, Open-ended, Useful default values and fields. Cons: Deep and complex, it takes a while to familiarize

  Powered by IT Central Station

  Want Project Management Tool? I tried OpenProject.org and got frustrated with its performance (because it's Ruby-based ?) and skimpy features. ...Continue Reading

  Rating:

• Our development team and it's functional staff have gained a better overview of the issues that are being worked on

  Powered by IT Central Station

  Valuable Features: <ul> <li>Ability to search old issues.</li> <li>Ability to create your own tags and fields, ie...Continue Reading

  Rating:

• My deployment was expensive due to the complexities I implemented. Other deployments have been less expensive.

  Powered by IT Central Station

  Valuable Features: Workflow configuration (escalation, workflow chaining, conditions, validators, post-scripting, etc) • Improvements to...Continue Reading

  Rating:

Manage SQL-Transact SQL (T-SQL)

Learn to apply best practices and optimize your operations.

• Create a user-defined server role in SQL Server 2012 with T-SQL, SSMS

  Ashish Mehta shows two ways – with T-SQL and with SSMS -- to make a user-defined server role in SQL Server 2012. Continue Reading

• Nine T-SQL best practices

  Choosing the right data type and avoiding dynamic SQL are two of the nine T-SQL best practices that author Basit Farooq explains here. Continue Reading

• SQL Server views: Creating indexes and adding base data

  SQL Server views allow you to give information to users without compromising security. Find out how to create indexes on them and add base data. Continue Reading