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 - Page 3

PL/SQL
  SQL
Transact-sql
41-60 of 667     Previous     Next
Limiting the Amount of Characters Output in a Column Using the SQL TEXTSIZE Command
by Hannes du Preez
Language: SQL||Expertise: Beginner
Using DATEFROMPARTS SQL Function
by Hannes du Preez
Language: SQL||Expertise: Beginner
Using REPLICATE for SQL Strings
by Hannes du Preez
Language: SQL||Expertise: Beginner
Check if a Temporary Table Exists
by Hannes du Preez
Language: SQL||Expertise: Intermediate
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.
41-60 of 667     Previous     Next
Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date