dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
Search the Tips

SQL - Page 4

PL/SQL
  SQL
Transact-sql
61-80 of 738     Previous     Next
Understanding UNION in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to identify unique records in MySQL.
Using dm_exec_function_stats in SQL Server 2016
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Check the execution details of a function in SQL.
A Handy Delete Stored Procedure
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Ensure that your data is safe when you make use of Transactions to do any data manipulation with this sample stored procedure.
Identifying all the Index(s) Available on a Table in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn a way to increase performance in MySQL.
Transpose Columns into Rows in SQL
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn a different, albeit complicated, way to transpose columns into rows.
Quickest Way to Copy the Structure of a Table
by Hannes du Preez
Language: SQL, Level: Intermediate: - This quick tip demonstrates how to copy a table's data, as well as only the structure of a table.
Create a Snapshot of Your Database
by Hannes du Preez
Language: SQL, Level: Intermediate: - Use this code to create a snapshot of your current database.
Identify Tables Without an Identity Column
by Hannes du Preez
Language: SQL, Level: Beginner: - This query will enable you to list all the tables in your database that don't have an IDENTITY column.
Get the Total Number of Rows for Each Table in Your Database
by Hannes du Preez
Language: SQL, Level: Beginner: - Use the following query to get the total number of rows for each table in your database
Extract All Numbers from a String in SQL
by Hannes du Preez
Language: SQL, Level: Intermediate: - Learn this easy way to extract numbers from a string.
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.
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.
61-80 of 738     Previous     Next
Thanks for your registration, follow us on our social networks to keep up-to-date