Categories
Archives
- September 2010
- August 2010
- July 2010
- June 2010
- May 2010
- April 2010
- December 2009
- October 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- March 2008
- February 2008
- January 2008
- December 2007
- November 2007
- October 2007
- September 2007
- August 2007
- July 2007
- June 2007
- May 2007
- April 2007
- March 2007
- February 2007
- January 2007
- December 2006
- November 2006
- October 2006
- September 2006
Meta
Category Archives: Database
Working efficiently with multiple T-SQL stored procedure parameter values
Sending multiple values in the form of array to a SQL Server stored procedure is very common among database developers. We can send the values in either of the two methods as following: · Comma separated values (in a … Continue reading
Northwind database scripts for Oracle
"Northwind" is a demonstration database provided by Microsoft. It is generally available with Access or SQL Server 2000. I generated Oracle script for the same Northwind database (along with INSERT statements), to make it available as a demonstration database for … Continue reading
Part 3: More about CASE, @@ROWCOUNT and TABLES in T-SQL
Hello, This is third in series focusing on the following topics: A bit more concentration on CASE CASE with IF Utilizing @@ROWCOUNT Working with TABLES (Table Variables) in T-SQL The article is available at http://www.aspfree.com/c/a/MS-SQL-Server/Using-ROWCOUNT-and-TABLE-Variables-for-Database-Interactions-with-TransactSQL/ thanks Jag
Part 2: More about variables, IF and CASE in Transact-SQL
Hai, You can find part 2 of the series focusing on "database interactions with Transact-SQL" here at http://www.aspfree.com/c/a/MS-SQL-Server/How-to-Use-Variables-IF-and-CASE-in-Database-Interactions-with-TransactSQL/ Enjoy, Jag
Part 1: Transact-SQL Tutorial: Working with Variables
Hai, Started a new tutorial series to completely cover Transact-SQL Programming (right from its basics). The first is here: http://www.aspfree.com/c/a/MS-SQL-Server/Working-wth-Variables-in-Database-Interactions-with-Transact-SQL/ enjoy and let me know if you want any topic.. thanks Jag
PL/SQL stored procedures for CRUD operations
Hello, This contribution mainly helps application developers to develop standard CRUD PL/SQL stored procedures. You will find another upcoming article further extended with packages as well. Article available at http://www.devshed.com/c/a/Oracle/Developing-Simple-PL-SQL-Stored-Procedures-for-CRUD-Operations/ thanks Jag
Introduction to REF CURSOR in PL/SQL
Hello, My new contribution on REF CURSORs in PL/SQL got published at http://www.devshed.com/c/a/Oracle/Working-with-REF-CURSOR-in-PL-SQL/ enjoy and give me the feedback. thanks Jag
Level 100 – Importing CSV file using “Bulk Insert Task”
Hai everybody, Today, I started a new category dedicated for SSIS (SQL Server Integration Services) video tutorials. First tutorial is on importing CSV (Comma Separated Values) file into a database using "Bulk Insert Task" of SSIS. Download Video/source … Continue reading
Series of articles on Oracle PL/SQL
Hai, The following are my articles (links in order) concentrating on programming with Oracle PL/SQL: http://www.devshed.com/c/a/Oracle/Database-Interaction-with-PLSQL-part1/ http://www.devshed.com/c/a/Oracle/Database-Interaction-with-PLSQL-part2/ http://www.devshed.com/c/a/Oracle/Database-Interaction-with-PLSQL-part3/ http://www.devshed.com/c/a/Oracle/Database-Interaction-with-PLSQL-OBJECT-and-OBJECT/ http://www.devshed.com/c/a/Oracle/Database-Interaction-with-PLSQL-Nested-Tables/ http://www.devshed.com/c/a/Oracle/Database-Interaction-with-PLSQL-Predefined-Exceptions/ http://www.devshed.com/c/a/Oracle/Database-Interaction-with-PLSQL-User-defined-Exceptions-Nested-Blocks/ http://www.devshed.com/c/a/Oracle/Database-Interaction-with-PLSQL-Nested-Blocks-in-Depth/ http://www.devshed.com/c/a/Oracle/Database-Interaction-with-PLSQL-Introduction-to-Cursors-Implicit-Cursors/ http://www.devshed.com/c/a/Oracle/Database-Interaction-with-PLSQL-Explicit-Cursors/ http://www.devshed.com/c/a/Oracle/Database-Interaction-with-PLSQL-Explicit-Cursors-in-Depth/ http://www.devshed.com/c/a/Oracle/Database-Interaction-with-PLSQL-Introduction-to-Subprograms/ http://www.devshed.com/c/a/Oracle/Database-Interaction-with-PLSQL-Subprograms-in-Depth/ http://www.devshed.com/c/a/Oracle/Database-Interaction-with-PLSQL-RECORD-and-TABLE-in-Subprograms/ http://www.devshed.com/c/a/Oracle/Database-Interaction-with-PLSQL-Working-with-TABLE-in-Subprograms-Parameter-Modes/ http://www.devshed.com/c/a/Oracle/Database-Interaction-with-PLSQL-Named-Notations-Storing-Procedures-and-Functions/ http://www.devshed.com/c/a/Oracle/Database-Interaction-with-PLSQL-User-defined-Packages/ http://www.devshed.com/c/a/Oracle/Associative-Arrays-in-Oracle-PLSQL-Introduction/ http://www.devshed.com/c/a/Oracle/Associative-Arrays-in-Oracle-PLSQL-The-Professional-Approach/ http://www.devshed.com/c/a/Oracle/Associative-Arrays-in-Oracle-PLSQL-The-Best-Approach/ http://www.devshed.com/c/a/Oracle/Reading-Text-Files-using-Oracle-PLSQL-and-UTLFILE/ http://www.devshed.com/c/a/Oracle/Writing-to-Text-Files-in-Oracle-PLSQL/ … Continue reading
Where all can I inject Sub-Queries in a SELECT statement – Part 1
Hello guys, My second article on working with sub-queries in Oracle got published here http://www.devshed.com/c/a/Oracle/Inserting-SubQueries-in-SELECT-Statements-in-Oracle/ enjoy and give me the feedback, thanks Jag