Stored Procedure Parameter Builder

One of the most common things we do is encapsulate the CRUD (Create Retrieve Update Delete) functions in a stored procedure. For tables with a lot of columns, typing in parameters to be used for Insert and Update stored procedures gets tedious. The solution is to build a generator for these parameters based from table columns. SQL can help us with this. Below is the code for a parameter builder:



create proc _parambuilder
@TableName varchar(100)
as

select ',@' + COLUMN_NAME + ' ' + DATA_TYPE + COALESCE('(' + LTRIM(STR(CHARACTER_MAXIMUM_LENGTH)) + ')', '')
from information_schema.columns
where table_name = @TableName



It will produce an output like

,@CustomerID varchar(15)
,@SiteID int
,@UserID int
,@CreatedBy varchar(50)
,@CreatedByDate datetime
,@LastUpdatedBy varchar(50)
,@LastUpdatedByDate datetime



All we have to do is remove the first comma and these parameters are good as copy and paste. This script can be customized to generate Insert and Update scripts.

Korean Language Notes

My notes are kind of messy because I compiled it from a bunch of scratch papers. My tools for compiling in word are Korean Language pack for Windows XP and Babelfish translator (http://world.altavista.com). For the list of official romanization of Korean language I like to refer to Official Site of Korea Tourism Org: Romanization of Korean.

Korean	Romanized	pronounced	English
선생님	Seon.saeng.nim	seonsaengnim	teacher
학생	Hak.saeng	haksaeng	student
사람	Sa.ram		Person
좋아해요	Joh.a.hae.yo	Johahaeyo	Like
사과	Sa.(g,k)wa	sakwa	Apple
자동차	ja.dong.cha	jadongcha	Automobile/car
차	cha	cha	car
당신	Tang.sin	tangshin	You
나는	Na.neun	Naneun	I
저는	Cheo.neun	cheoneun	I
눈	Nun		Eye/snow
책	Chaek	chaek	Book
읽	Ilk	Ilk	read
책갈피	Chaek-kal-pi	chaekalpi	bookmark
집	Jip	Jip/chip	House
말할수	Mar.har.su	marharsu	Can (su) speak (marhar)
고양이	(g,k)o.yang.i	Goyang.i/Koyang.i	Cat
꽃	Kkoch	Kkott	Flower
문	Mun		Door
피	Pi		Blood
화장실	Hwa.jang.sil	hwajangshil	Toilet
사무실	Sa.mu.shil	samushil	office
실업가	Sa.eop.ka	Saeopka	businessman
비서	Bi-seo	Biseo	secretary
변호사	Byeon-ho-sa	Pyeonhosa	Lawyer
회사원	Hoe-sa-won	Wei-sa-won	Employee, business unit
비싸	Bi-ssa	bissa	expensive
학교	Hak-gyo	hakgyo	school
여자	Yeo-ja	yeoja	woman
남자	Nam-ja	Namja	man
자전거	Ja-jeon-keo	jajeonko	bike
아름다운	a-reum-da-un	Areumda-un	beautiful
거지	Keo-ji	Keoji	beggar
부자	Bu-ja	buja	Rich man
간	Gan	gan	liver
역사	Yeok-sa	Yeoksa	history
북쪽	Puk-jjeuk	Pukjjeuk	north
동쪽	Dong-jjeuk	Dongjjeuk	east
남쪽	Nam-jjeuk	Namjjeuk	south
서쪽	Seo-jjeuk	Seo-jjeuk	west
북한	Puk-han	Pukhan	North Korea
남한	Nam-han	Namhan	South Korea
가지계절	Ka-ji-kyeo-jeol	kajikyeojeol	4 seasons (??)
새	sae	sae	Bird
새싹	Sae-ssak	saessak	buds
년	Nyeon	Nyeon	Year
월	Wol	Wol	Month
주	Ju	Ju	Week
일	Il	Il	Day
시간	Si-gan	Shigan	Hour
분	Pun	Pun	Minute
초	Cho	Cho	second
온도	On-do		Temperature (Celsius)
온	don		Money
해	Hae		Sun
해병	Hae-byeong		beach
봄	bom		Spring
여름	Yeo-reum		Summer
가을	ga-eul		Autumn
계울	Kyeo-ul		Winter
자기	jagi	Jagi	Honey, darling
다시	dashi	dashi	Again

1. 나는 ____ 에 되고 싶는다. Naneun ____ e doego ship neun da. (I want to be a ____.)

나는 변호사에 되고 싶오요. Naneun byeonhosa e shipneunda. (I want to be a lawyer.)

2. 나는신발이비싸요 Naneun shinpari pissa yo. (My shoes are expensive.)

3. 물주세요Mul juseyo (Give me water please?)

Mul yogi yo (Here is water)

4. Cheongmaneyo (Don’t mention it/You’re welcome)

5. Naneun Hankuk reul malhal su iss seupnida. (I can speak Korean)

(I) (Korean) (pp) (speak) (can) (it is)

6.

나는척을읽여요 Naneun chaek eul ilgayo (I read books)

나는 책을 읽었다 Naneun chaek eul ilk eoss da (I read books)

7. Cheoneun cha ga opseoyo (I do not have a car)

8. Pi ga wayo (It’s raining)

9. Cheonun teulge i nun eul kachiguseyo (I have two eyes)

10. Cheoneun tari ga teulge isseoyo (I have 2 legs)

11. 여자가아름다운입니다 Yeojaga a-reum-da-un ipnida (Girls are beautiful)

12. Naneun kan i han isseoyo (I have one liver)

13. Pisshi manayo kureso keoji eyo (I have a big debt so I am a beggar)

[Pisshi (debt) manayo (big) kureso (so) keoji (beggar)]

14.들으십시요 Deureu shipshiyo (listen)

15. Naneun Hankuk mari oryowoyo (?? I find Korean difficult to speak)

16.

2008 년	Year 2008
2 월	February
2 주	2nd week
15일	15th day
12 시간	12 hour (12 o clock?)
30분	30 minutes
15초	15 seconds

12 시간30분15초 = 12:30:15 am??

17. 다시말해주세요Tashi malhae juseyo (Please say it again) [Tashi (again) malhae (say)]

18. Naneun namjaga animnida. (I am not a boy)

19. 오분간휴식

Obungan hyushik (Five minute break) [Obun (five minutes) gan (for) hyushik (rest/break)]

20. 자신감을갖자 Jashinkameul ka-ja (Be confident)

21. 당신은 소중한사람입니다 Tangshin-eun sojunghan saram ipnida (You are a precious person)

자신감을갖자. 당신은 소중한사람입니다

Be confident. You are a precious person

Tangshin-eun (You) sojunghan (precious/adjective) saram (person/s.c.) ipnida (is/verb)

22. 시간은금입니다 Shigan-eun geum ipnida (Time is gold)

Shigan (time) geum (gold/s.c.)

23. 늦지마세요 Neutji ma seyo (Don’t be late)

24. 빨리와 Ppalli wa /빨리오세요 Ppalli oseyo (polite) => Hurry up

25. Abeoji donjuseyo. Jadongcha reul saryeokoyo. (Dad please give me money. I will buy a car.)

Saryeokoyo => I will buy

Google Chrome

I am writing this post from Google Chrome, a lightweight browser by Google released as Beta. As I have expected it looks like Google Talk. Google is The Minimalist that focuses on usability and important features. What I like about Chrome is the large area for page, less buttons - less clutter. And usually when you install a new browser it forces you to download the Flash plugin for it but this one didn't - YouTube just works. Well YouTube  is Google so it should! :-D

Chrome got rid of the title bar and opted to place the tab on the top instead. Like the phone dialer of Opera Browser - chrome does the same but uses it to display most visited pages. Clever.

Unfortunately, Java applets do not work and haven't found a way to add the Java plugin for it. But the installer for Chrome was barely 800 kb, wow. I couldn't care less for the bulk of features the other browsers have if I want to just surf, Google Chrome works for me.

The list of things I liked about Chrome:

• When opening a link to a new tab from a page, the tab opens right next to the referral tab. 
• Dragging and droping a tab to the viewing area opens the tab in a new window.
• Moving around tabs is more fluid than in Firefox.
• The ability to open an incognito window or open a page that does not get logged in the history.
• Faster load times especially on Youtube.
• Bigger viewing area- Chrome got rid of the title bar which was a wise move since its redundant with the title in the current tab.
• Like in Firefox 3, suggestions works
• Bookmark button doesn't interfere with surfing. In Firefox 3 I always accidentally click on this because it gets toggled on after the clicking "go".
• Status bar only shows when needed at least it does work on my XP.
• Less clutter on first installation.

Windows Spaces Limit

I tried posting my previous entry in Spaces but I got this error. Is Spaces post limited to varchar(4000) characters? :-)

Wim-ball-don

Interesting Wimbledon trivia, heard from Vijay of Star Sports:

1650 dozen balls used in Wimbledon
600 balls used during qualifying round
Balls are stored in 68°F
Yellow balls were introduced in 1986

Balls are made in the Philippines