SQL

PL/SQL

� SQL

Transact-sql

1-20 of 625 Previous Next
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.
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
1-20 of 625 Previous Next