Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
Search the Tips

SQL

PL/SQL
  SQL
Transact-sql
1-20 of 661     Previous     Next
Identify Tables with Large Column Counts
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Check out this simple way to identify tables with a large number of columns.
Find Out the Column Name Using the COL_NAME() Function
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Use this code snippet to quickly find out a column's name.
Summing a COUNT Aggregate SQL Function
by Hannes du Preez
Language: SQL, Expertise: Intermediate - See how to sum the result of a count aggregate function.
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 FILEPROPERTY to Check for Free Space in a Database
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn how to use FILEPROPERTY to check for free space in a database.
Identify All the Foreign Keys in Your Database
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn how to quickly identify all of your foreign keys in a particular database.
Import Large SQL Files into MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Follow these steps to import large SQL files into MySQL.
Get All Tables Referenced by at Least One View
by Hannes du Preez
Language: SQL, Expertise: Intermediate - The following query will produce a list of tables that are referenced by one or more Views.
Get Stored Procedure Content and Details
by Hannes du Preez
Language: .NET, Expertise: Intermediate - This query can be used to get details regarding stored procedure content.
SQL JOINs
by Octavia Anghel
Language: Web, Expertise: Intermediate - A JOIN clause is used to combine rows from two or more tables.
Search for Text Inside All the SQL Procedures in Your Database
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn how to find all Stored Procedures containing the specific text when you can't remember the name.
Identifying Tables Without Primary Keys in SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Use this script to find out which tables in your database(s) do not have Primary Keys.
Get a User that has Deleted Rows with SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Finding a user who has deleted rows is a multi-part process. Get some tips on how to get it done.
Restrict the Connection to a Database in SQL
by Hannes du Preez
Language: SQL, Expertise: Beginner - Learn how to restrict the connection to a database.
The sp_spaceused Procedure in SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate - See an example of how to use the sp_spaceused special SQL procedure.
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 xp_ dirtree to List Folders, Subfolders and Files with SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate — Learn how use an undocumented Extended Stored Procedure named xp_dirtree to list folders, subfolders, and files for a given path.
Working with an SQL Output Parameter in C#
by Hannes du Preez
Language: .NET, Expertise: Beginner - How to specify the SQL Output parameter's Direction property once you have created it.
Using Boolean Logic Instead of CASE WHEN
by Hannes du Preez
Language: SQL, Expertise: Intermediate — Once you get the hang of the CASE WHEN SQL Statement it can be easy to overuse it. Sometimes you can simply replace it with Boolean logic.
Enumerating all SQL Servers
by Hannes du Preez
Language: SQL, Expertise: Beginner — Learn how easy it is to enumerate (list) all the possible SQL servers to which you want to connect.
1-20 of 661     Previous     Next
Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date