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


advertisement
Search the Tips
Tip Bank > Database Development

Database Development

Active Server Pages
Data Access
Database Administration
Database Apis
  ADO   ADOX   JDBC   ODBC   OLE DB   SQL-DMO
Database Tuning
DB2
Informix
MySQL
Oracle
Relational Databases
SQL
  PL/SQL   Transact-sql
Sql Server
Visual Foxpro
1-20 of 2413     Previous     Next
Employ This SQL Stored Procedure to Rename a Column
by Hannes du Preez
Language: SQL, Expertise: Intermediate - See how to use sp_rename to rename a column in a table.
Selecting the Max, Min and Sum of Values from a Table in MySQL
by Sridhar M S
Language: SQL, Level: Intermediate: - Learn how to find the Max, Min and Sum of values from a column in a table in MySQL.
Generating Random Numbers in SQL
by Hannes Du Preez
Language: SQL, Expertise: Intermediate - Learn how to easily generate a random number.
Getting the Current Date and Time in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to use the NOW() function in MySQL to get the current time and date.
Understanding IFNULL in MySQL
by Sridhar M S
Language: MySQL, Expertise: Intermediate - See why IFNULL is a suitable function that can be used where you want to treat null values methodically.
Compress and Decompress SQL Functions
by Hannes Du Preez
Language: SQL, Expertise: Intermediate - Learn how to use compress and decompress in SQL Server 2016.
Obtaining ASCII Values from Characters in SQL
by Hannes Du Preez
Language: SQL, Expertise: Intermediate - See how to use the ASCII function to return a character's ASCII value.
Using the HASHBYTES Function in SQL
by Hannes Du Preez
Learn how to use the hashbytes function in SQL.
Easy One-Step Process to Rename a Table in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn an easy one-step process for renaming a table in MySQL.
Knowing the Sign of a Given Number in MySQL
by M S Sridhar
Language: SQL, Expertise: Beginner - See how to learn the sign of the number for computation purposes.
Know if LIKE Results are True or False
by M S Sridhar
Language: SQL, Expertise: Beginner - See how to know if LIKE results are true or false in MySQL.
Learn the Storage Engine Type of a Table in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - There are plenty of commands in MySQL that are supported for particular types of storage engines. Use this command to know the engine type.
Find Indices on a Table in MySQL
by Srinath M S
Language: Enterprise, Expertise: Intermediate - Find the indices on a table in MySQL.
Adding a New Column in a Specific Position
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to specify the location of a new column, rather than just adding it to the end of the current table.
Get Detailed Information on Tables in MySQL
by M S Sridhar
Language: SQL, Expertise: Intermediate - See how to get detailed information on available tables, record counts, etc., in MySQL.
Find Tables with an XML Column
by Hannes du Preez
Language: SQL, Expertise: Intermediate - See how to find tables with an XML column.
Finding Duplicate Data Available for Multiple Records
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn how to find data available for multiple records with MySQL.
Update the Metadata of a Database Object
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Learn how to refresh a database object with the help of the sp_refreshsqlmodule function.
Understanding the INSTR Function
by M S Sridhar
Language: SQL, Expertise: Intermediate - Learn more about using the INSTR function in MySQL.
Find Tables Referenced by Foreign Keys
by Hannes du Preez
Language: SQL, Expertise: Intermediate - Find tables referenced by foreign keys with a script similar to this one.
1-20 of 2413     Previous     Next
Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date