Browse DevX
Sign up for e-mail newsletters from DevX

Search the Tips
Tip Bank > Database Development > SQL > Transact-sql


1-20 of 395     Previous     Next
Working with the IIF Statement in T-SQL
by Hannes du Preez
Language: SQL, Expertise: Beginner - See how to quickly check for certain conditions.
Determine Which Version of SQL You Are Running
by Hannes du Preez
Language: SQL, Expertise: Beginner - Check out these two T-SQL methods that determine which version of SQL you are running.
Disable Indexes with SQL
by Hannes du Preez
Language: SQL, Level: Intermediate: - Learn how to disable an index, temporarily or otherwise, with this T-SQL Query.
Identifying Unused Tables with T-SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn how to easily identify unused Tables.
Using TRY and CATCH Blocks in T-SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn how to handle errors in T-SQL.
Using xp_create_subdir to Create Windows Folders with SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Create folders in T-SQL with the help of the built-in Extended Stored Procedure named xp_create_subdir.
Using the @@rowcount Global Variable in SQL
by Hannes du Preez
Language: SQL||Expertise: Intermediate
How to Read Environment Variables in SQL Server Using T-SQL
by Deepak Choudhari
The xp_cmdshell extended stored procedure in SQL Server enables you to read environment variables in T-SQL.
A Better Way to Retrieve the ID of the Last Inserted Record
by Martin Vitek
An update to a previous tip on retrieving the ID of the last inserted record, this version uses less code and avoids a search of the jobs table.
Choosing a Large-Text Data Type for SQL Server Table Columns
by Deepak Choudhari
SQL Server offers several different data types for storing large amounts of data in table columns. But which should you use?
Avoid Multiple Queries When Querying for Max and Min Values
by Cindy Rodriguez
Instead of making one query to get the Max and Min values for a column, and then making another query to get additional information about those rows, you can do it all in one query.
Discover Long-Running Queries
by Srinath MS
Let SQL Server tell you which queries take the longest to run.
Find All User-Defined Functions in a SQL Server Database
by Jaya Nehru
This query returns all the user-defined functions in the specified database.
Run a Partial Query in TOAD
by Chithra Vijayan
You can run any portion of a SQL command in TOAD, even if it's embedded in a larger query.
Table Variables Are More Efficient than Temporary Tables In Some Cases
by Srinath MS
Using @TABLE rather than temporary tables improves performance for small tables that don't require indexes.
Rebuild All Table Indexes in a SQL Server Database with One Command
by Srinath MS
An undocumented stored procedure lets you refresh all the table indexes in a SQL Server database with a single command.
Explore the Statements and Parameters Passed to SQL Server
by Cindy Rodriguez
Find out exactly what statements and parameters are passed to SQL Server.
Execute a Block of Text in SQL Server Management Studio
by Cindy Rodriguez
In SQL Server Management Studio, you can use the Alt key in your keyboard to select blocks of text to execute.
Create XML from an Array
by Cindy Rodriguez
Passing arrays as arguments to stored procedures is not currently possible in SQL Server, but you can use XML to accomplish this.
Debugging SQL Server Stored Procedures Through Visual Studio.NET
by Srinath MS
Learn how to use Visual Studio.NET to debug SQL Server stored procedures.
1-20 of 395     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date