STUFF & REPLACE in SQL SERVER

STUFF

What STUFF does is, it inserts a string for the given expression of string. At a give start_position, it will start to delete the character mentioned on the length_to_delete and insert the replacement word.

STUFF(expression,start_position,length_to_delete,replace_with)

eg.

SELECT STUFF('Younten',5,3,'10')
SELECT STUFF('Younten',5,0,'10')

Output:
Youn10
Youn10ten

REPLACE

What REPLACE does is, it will replace every character in the given string.

REPLACE(expression,patter,replace_with)

eg.

SELECT REPLACE('Younten','Y','y')
SELECT REPLACE('Younten','n','N')

Output:
younten
YouNteN

Comments

Remove Log files from Checkpoint

Here is how you can delete checkpoint old log files 1. Go to Gaia Terminal 2. Enter expert mode 3. echo $FWDIR to get the log file location 4. Go to the Log directory cd $FWDIR/log 5. rm 2013-10-01* to remove 1st Oct 2013 logs

Clear Zimbra Mail Queue

If you want to clear mail queue from specific email address run the following command in your terminal. Below will remove mail queues, by checking FROM sender. eg. remove all mail queues sent by info@example.com /opt/zimbra/postfix/sbin/mailq | tail -n +2 | grep -v '^ *(' | awk 'BEGIN { RS = "" } { if ($7 == "info@example.comt") print $1 } ' | tr -d '*!' | xargs -rn1 /opt/zimbra/postfix/sbin/postsuper -d Below will remove mail queues, by checking TO sender. eg. remove all mail queues sent to info@example.com /opt/zimbra/postfix/sbin/mailq | tail -n +2 | grep -v '^ *(' | awk 'BEGIN { RS = "" } { if ($8 == "info@example.comt") print $1 } ' | tr -d '*!' | xargs -rn1 /opt/zimbra/postfix/sbin/postsuper -d

Know your Lha Zha, Sog Zha, Shi Zha

There is believe in Buddhism, that an individual person have got their own lucky day and bad luck day in a week. They are derived from the twelve animals similar to chiness horscope. Your birth year tells you which Buddhism zodiac sign you below to. Lha Zha and Sog Zha are belived to be good day while Shi zha is consider bad day.

Bhutan ICT

Search This Blog