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 667     Previous     Next
The sp rename SQL Stored Procedure
by Hannes du Preez
Language: SQL, Level: Intermediate: - See how to use the sp_rename stored procedure if you do not want to drop and recreate the table again.
Pass Comma Separated Values as a Parameter to an SQL Stored Procedure
by Hannes du Preez
Language: SQL, Expertise: Intermediate - There will be times when you need to pass a list of values as a singular parameter to an SQL Stored Procedure. Problem is: SQL doesn't support this. See how to get around this issue.
Using the SQL FORMAT Function
by Hannes Du Preez
Language: SQL, Expertise: Intermediate - Learn how to easily format how a field should be displayed.
Create and Schedule an SQL Job
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Sometimes you want a certain query, or Stored Procedure to be repeated on a daily, weekly or monthly basis. Learn to create an SQL Job and schedule it.
Check if a Primary Key Exists on a Table
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn how to check whether a Primary Key is missing, and if so, add it.
Identifying Unused Tables with T-SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn how to easily identify unused Tables.
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.
1-20 of 667     Previous     Next
Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date