|
| Showing Page: 1 of 2 Next > |
|
Order by
Date |
Hits |
Total Votes
|
|
|
| SQL Quiz Package Free Download |
in Database |
| by techguru on 30 May 2006, 08:08 |
| exclusive sql quiz containing 100 questions. Feel free to download the quiz package and practice offline at your end. All 100 questions are provided with answers and explination (wherever necessary). You can time your quiz. You can analyse your performance. You can keep track of quiz history. You can... |
| Total Hits: 1336 3 Comments Add Comment Visit |
|
|
|
| Passing Optional Parameters to a Stored Procedure |
in Database |
| by Thivya on 06 Mar 2006, 09:30 |
|
To pass a optional parameters to a stored procedure in SQL Server, declare the parameter with the default value.
Create Procedure proc_Test
@a int,
@b int =5 -- Provided with the default value.
as
begin
Select @a, @b
end
Note:
When using... |
| Total Hits: 1680 0 Comments Add Comment |
|
|
|
| SQL Email Alerts |
in Database |
| by xirkonax on 15 Nov 2005, 07:00 |
| Automatic Email Alerts for Low SQL Server Disk Space 9/20While Auto Growth is a good feature, it can eat up hard disk space. This article illustrates how to set up email notification when SQL Server is running out of Hard Disk Space. |
| Total Hits: 478 0 Comments Add Comment |
|
|
|
| SQL Integration Services |
in Database |
| by xirkonax on 14 Nov 2005, 19:43 |
| Following an extended review of various types of Foreach Loop enumerators in the SQL Server 2005 Integration Services, we are turning our attention to other types of package components, which either did not exist in the Data Transformation Services or which functionality has been significantly enhanced.... |
| Total Hits: 480 0 Comments Add Comment |
|
|
|
| SQL Server 2000 vs Oracle 9i |
in Database |
| by techguru on 13 Jan 2006, 17:47 |
| Good one SQL Server 2000 vs Oracle 9i Often people in newsgroups ask about some comparison of Oracle and
Microsoft SQL Server. In this article, I compare SQL Server 2000
with Oracle 9i Database regarding price, performance, platforms
supported, SQL dialects and products limits. Introduction... |
| Total Hits: 830 0 Comments Add Comment |
|
|
|
| Oracle by Example Series: Oracle9i Database Release 2 |
in Database |
| by techguru on 15 Nov 2005, 06:26 |
| The Oracle by Example series provides step-by-step instructions on how to perform a variety of tasks using Oracle9i Database Release 2. The Oracle by Example series reduces the time spent investigating what steps are required to perform a task. Because the step-by-step solutions are built for practical... |
| Total Hits: 456 0 Comments Add Comment |
|
|
|
| PostgreSQL Tutorial |
in Database |
| by exforsys on 28 Dec 2005, 10:51 |
| These are the PostgreSQL Notes - pretty much everything you find here is in the HTML documentation, Bruce's book or on the mailing lists. You might find this an easy access-point to the above documentation though.
NOTE - please don't link to individual pages in this document yet, things are still... |
| Total Hits: 1378 0 Comments Add Comment |
|
|
|
| SQL Injection Attacks |
in Database |
| by exforsys on 28 Dec 2005, 10:46 |
| A customer asked that we check out his intranet site, which was used by the company's employees and customers. This was part of a larger security review, and though we'd not actually used SQL injection to penetrate a network before, we were pretty familiar with the general concepts. We were completely... |
| Total Hits: 510 0 Comments Add Comment |
|
|
|
| Free Oracle 10G release 2 Database XE |
in Database |
| by techguru on 22 Nov 2005, 13:13 |
|
Oracle Database 10g Express Edition (Oracle Database XE) is an entry-level, small-footprint (150MB) database based on the Oracle Database 10g Release 2 code base that's free to develop, deploy, and distribute; fast to download; and simple to administer. Oracle Database XE is a great starter database... |
| Total Hits: 368 0 Comments Add Comment |
|
|
|
| mySQL to PosgreSQL Convertor Tool |
in Database |
| by techguru on 13 Jan 2006, 17:50 |
| It's about time that you considered moving across to postgresql. Postgresql is a superior database in many ways
not the least of which is their license terms. This web convertor is intended to help you convert
your database creation script from mysql to a format that is compatible with Postgresql.http... |
| Total Hits: 373 0 Comments Add Comment |
|
|
|
| MySQL Database Tutorials |
in Database |
| by techguru on 13 Jan 2006, 17:45 |
|
The following is the list of topics that I plan to create. The ones with a * are not yet done. I will work on these as time permits.
These examlpes should run on your system. In most
cases, you only need to copy and paste the code, and change the name of
the database.
You should use the... |
| Total Hits: 540 0 Comments Add Comment |
|
|
|
| MySQL Via PHP Cheat Sheet |
in Database |
| by techguru on 13 Jan 2006, 17:44 |
| This is the second version of my MySQL via PHP Cheat Sheet, which gives bare-to-the-bone MySQL blocks for PHP programmers. These can easily be copied and pasted into your code, then modified to meet your needs.Click here to read
|
| Total Hits: 717 0 Comments Add Comment |
|
|
|
| Database Video Tutorials |
in Database |
| by techguru on 13 Jan 2006, 17:44 |
| Presentations
Converting SQL Server and Access Databases to MySQL
Introduction to Database Normalization
Managing Hierarchical Data in MySQL
MySQL Workbench
MySQL Workbench Alpha Demo |
| Total Hits: 470 0 Comments Add Comment |
|
|
|
| Oracle Tutorials |
in Database |
| by techguru on 15 Nov 2005, 06:35 |
|
Overview of the ORACLE database management system (12 pages)
html
Using Oracle on isis
html
Practical introduction to SQLPlus (22 pages)
|
| Total Hits: 503 0 Comments Add Comment |
|
|
|
| Oracle Tutorials and Code Samples |
in Database |
| by techguru on 15 Nov 2005, 06:35 |
| you'll find new samples and tutorials on OTN to help you get started with the latest in Oracle, Java, and other cutting-edge technologies. Here are some recent highlights (register here for free):
The Card Payment Gateway Application shows you how to use Oracle9i XML DB's structured XMLType... |
| Total Hits: 516 0 Comments Add Comment |
|
Show Page: [ 1 ] 2 |
|