1-10 of 131 Hubssort by Hot Best Latest
90How-To Develop Dynamic CrossTab Queries in T-SQL(Transact-SQL)
This articles provides examples on how to use the pivot function in t-sql, dynamic sql and xml to create dynamic (programmatic) columns in a cross tab or pivot query similar to olap.
0 comments
90How-To Synchronize Data Between Excel and SQL Server | Linked Server
SQL Server offers many different technologies for system integration. This tutorial demonstrates how to link an Excel 2007 file with SQL Server 2008.
0 comments
91Mastering Oracle SQL Date Arithmetic
Describes the interpretation of arithmetic computations in Oracle PL/SQL.
16 comments
90More Oracle Interview Questions : SQL and PL/SQL
I can say Oracle database is a box of chocolates. You never know what you're gonna get. The more I learn about it, the more there is to learn. It's getting so much better with each new release too. See what Oracle 10g has to give us.. recycle bin,...
64 comments87T-SQL (Transact-SQL) | MERGE (Inserting and Updating) | SQL Server
Tutorial and example on how to use the Merge function in Transact-SQL to perform inserts and updates.
0 comments
85Oracle 10g Interview Tips and Questions
Frequently Asked Question in Oracle by Interviewers and some time by beginners.
4 comments
85How To Set Up A Live Test Server For Wordpress
One of the easiest ways to learn WordPress is to setup a live test sever before you build your WordPress site. A testing environment is going to make your life so much easier in the long run because it allows you the freedom to test WordPress...
8 comments
83SQL Server Database Consistency Check Errors are Reported by DBCC CHECKDB
Microsoft SQL Server includes an inbuilt utility, called DBCC CHECKDB, to check the consistency and integrity of MDF (Master Database File). However, sometimes the DBCC CHECKDB process does not complete...
3 comments
84Simple PHP web based address book using MySql
Today we will be creating a web based address book using PHP and MySql, it will be using the $_GET superglobal, as a means of reviewing the database contents. Before we start here are the source files: ...
45 comments
83Oracle Analytic Functions (10g)
An easy approach and quick start to Oracle Analytic Functions.
9 comments
