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
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 2274     Previous     Next
Using FOR XML PATH and STUFF SQL String Concatenation
by Hannes du Preez
Language: SQL||Expertise: Intermediate
Convert Oracle Queries into Microsoft SQL Format
by Andrew Kuprianov
Language: SQL||Expertise: Intermediate
Renaming an SQL Server Database
by Hannes du Preez
The SQL Intersect Operator
by Hannes du Preez
Language: SQL||Expertise: Intermediate
Using the SQL MINUS Operator
by Hannes du Preez
Using the @@rowcount Global Variable in SQL
by Hannes du Preez
Language: SQL||Expertise: Intermediate
Skip Weekends SQL Function
by Hannes du Preez
Language: SQL||Expertise: Intermediate
Obtaining the Next Number in a Sequence Using a Stored Procedure and an Output Parameter
by Hannes du Preez
Language: SQL||Expertise: Beginner
Find out Whether a Value Exists in a List of Values
by Hannes du Preez
You can use a normal SELECT query joined with a bunch of AND statements to determine if a certain value exists, but this can become cumbersome and tedious. Language: SQL||Expertise: Beginner
Doing Upserts with the Help of MERGE
by Hannes du Preez
Language: SQL||Expertise: Intermediate
Get All Tables and Views Inside a Database
by Hannes du Preez
Language: SQL||Expertise: Intermediate
Getting All Stored Procedures Inside a Database
by Hannes du Preez
Language: SQL||Expertise: Intermediate
PIVOTing Data in SQL
by Hannes du Preez
Language: SQL||Expertise: Advanced
Putting a NULL Date Value Last
by Hannes du Preez
Language: SQL||Expertise: Beginner
Determine who and what Caused a Deadlock in one of your Database Objects
by Hannes du Preez
Language: SQL||Expertise: Intermediate
Find out When the Last Full Backup was Taken
by Hannes du Preez
SQL query that displays the last time a full backup was taken, as well as the user who took the last backup.
Obtaining Actual & Estimated Execution Plans for SQL Queries
by Hannes du Preez
Language: SQL||Expertise: Intermediate
Backup and Restore an SQL Database
by Hannes du Preez
Language: SQL||Expertise: Intermediate
Importing Data from Excel into SQL Server
by Hannes du Preez
A very quick way to import data from Excel into SQL Server.
Work Around to Fix Datetime - Primary Key Violation Issue
by Jaya Nehru Kumar
Work around to fix datetime - primary key violation issue
1-20 of 2274     Previous     Next
Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date