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

PL/SQL
  SQL
Transact-sql
1-20 of 622     Previous     Next
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
Work Around to Fix Datetime - Primary Key Violation Issue
by Jaya Nehru Kumar
Work around to fix datetime - primary key violation issue
How to Read Environment Variables in SQL Server Using T-SQL
by Deepak Choudhari
The xp_cmdshell extended stored procedure in SQL Server enables you to read environment variables in T-SQL.
Use Comparison Operators in SQL to Remove/Return Columns with Null Values
by Srinath MS
When you use the comparison operators in SQL with the Where clause, you can remove the columns with null values.
1-20 of 622     Previous     Next
Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date