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 2266     Previous     Next
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
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.
Displaying the Row Number in a SELECT Query with SQL Server 2005
by Deepak Choudhari
SQL Server 2005 introduced a function that is very handy when you want the result set to have row numbers assigned to each returned row.
Retrieving Table Size in SQL Server
by Deepak Choudhari
Use this handy tip to determine the size of your SQL Server tables, which can be very useful for estimating the size and growth of a database over time.
A Better Way to Retrieve the ID of the Last Inserted Record
by Martin Vitek
An update to a previous tip on retrieving the ID of the last inserted record, this version uses less code and avoids a search of the jobs table.
Choosing a Large-Text Data Type for SQL Server Table Columns
by Deepak Choudhari
SQL Server offers several different data types for storing large amounts of data in table columns. But which should you use?
Avoid Multiple Queries When Querying for Max and Min Values
by Cindy Rodriguez
Instead of making one query to get the Max and Min values for a column, and then making another query to get additional information about those rows, you can do it all in one query.
Discover Long-Running Queries
by Srinath MS
Let SQL Server tell you which queries take the longest to run.
1-20 of 2266     Previous     Next
Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date