Mic's knowledge base

My personal notes

Reset the autonumber on MSSQL

clock January 3, 2009 18:15 by author mic
Sometimes we need to reset the autonumber - identity column in a table. Using the DELETE statement is not enough. The statement only deletes the data but not reset the identity column. So how can we do it? First, wen need to delete the data from the table and after execute the DB... [More]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , ,
Categories: Programming
Actions: E-mail | Kick it! | Permalink | commentComments (0) | RSS comment feedComment RSS

Debug Mode on SHELL

clock November 15, 2008 22:50 by author mic
ksh -x script

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: ,
Categories: Linux | Programming
Actions: E-mail | Kick it! | Permalink | commentComments (0) | RSS comment feedComment RSS

Transitioning to XHTML Strict

clock November 3, 2008 04:41 by author mic
Transitioning to XHTML is the easiest step to understand, because it's a matter of simply following rules. When you run a site through the W3C HTML Validator, it doesn't care if the site uses tables-based layout or CSS-based layout, or if your site is accessible or not. As long as the ... [More]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: ,
Categories: Programming
Actions: E-mail | Kick it! | Permalink | commentComments (0) | RSS comment feedComment RSS

Oracle Sql Plus

clock October 31, 2008 06:39 by author mic
1. Introduction The Oracle Relational Database Management System (RDBMS) is an industry leading database system designed for mission critical data storage and retrieval. The RDBMS is responsible for accurately storing data and efficiently retrieving that data in response to user queries. ... [More]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , ,
Categories: Programming
Actions: E-mail | Kick it! | Permalink | commentComments (0) | RSS comment feedComment RSS

SQLplus

clock October 31, 2008 05:11 by author mic
What is SQL*Plus and where does it come from? SQL*Plus is a command line SQL and PL/SQL language interface and reporting tool that ships with the Oracle Database Client and Server software. It can be used interactively or driven from scripts. SQL*Plus is frequently used by DBAs and Developers ... [More]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags:
Categories: Programming
Actions: E-mail | Kick it! | Permalink | commentComments (0) | RSS comment feedComment RSS

Matching Patterns in Text: The Basics

clock October 25, 2008 16:30 by author mic
Character literals /a/ Mary had a little lamb. And everywhere that Mary went, the lamb was sure to go. /Mary/ Mary had a little lamb. And everywhere that Mary went, the lamb was sure to go. The very simplest pattern m... [More]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , ,
Categories: Programming
Actions: E-mail | Kick it! | Permalink | commentComments (0) | RSS comment feedComment RSS

Using regular epxression in perl

clock October 24, 2008 21:49 by author mic
Using Regular Expressions To check if there is a match in a string Perl uses special operator =~. Usual syntax is: variable =~ m/regular_expression/ The result of this operator is either true (if there is a match) or false (no match). The following example checks if a string contains a phon... [More]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , ,
Categories: Programming
Actions: E-mail | Kick it! | Permalink | commentComments (0) | RSS comment feedComment RSS

Regular expression special characters

clock October 24, 2008 21:24 by author mic
Entering Special Characters   <Comma>   ,   <Nul>   ^@   <Period>   .   <Space>    ... [More]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , ,
Categories: Programming
Actions: E-mail | Kick it! | Permalink | commentComments (0) | RSS comment feedComment RSS

Search and Replace string on Perl

clock October 24, 2008 06:56 by author mic
SEARCH & REPLACE. Just as the title implies, this is to look for certain patterns and replace them with a different specified string. Substitution is specified with s. It is placed before the first forward slash surrounding the search expression. The string that will be used to rep... [More]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , , ,
Categories: Programming
Actions: E-mail | Kick it! | Permalink | commentComments (0) | RSS comment feedComment RSS

Perl string regular expression

clock October 24, 2008 04:38 by author mic
Introduction Without regular expressions, Perl would be a fast development environment. Probably a little faster than VB for console apps. With the addition of regular expressions, Perl exceeds other RAD environments five to twenty-fold in the hands of an experienced practitioner, on console app... [More]

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Tags: , ,
Categories: Programming
Actions: E-mail | Kick it! | Permalink | commentComments (0) | RSS comment feedComment RSS

Calendar

<<  January 2009  >>
MoTuWeThFrSaSu
2930311234
567891011
12131415161718
19202122232425
2627282930311
2345678

View posts in large calendar

Page List

RecentPosts

Sign in

Copyright Mic Nguyen | All Right Reserved | My Documents