Friday, February 27, 2009

Sql Server Stored Procedures

CREATE PROCEDURE spHello as
PRINT 'Hello welcome to T-Sql'
GO
Executing a stored Procedure
EXEC spHello
Stored Procedure with varchar parameter and string concatenation
create procedure spHelloName (@Name varchar(20))
as print 'Hello ' + @Name
go

Procedure with integer Parameter and addition
--Memory variables must preceded with @ symbol
create procedure spAdd(@p1 int, @p2 int)as
print @p1 + @p2
go

exec spAdd @p1 = 56, @p2 = 65
spAdd @p1 = 86, @p2 = 65
spAdd 45, 23

If

create procedure spIf (@pCity varchar(40))
as
if @pCity = 'Kochi'
 print 'Industrial capital  of Kerala'
go


Stored Procedure for Selecting values from a Table
CREATE PROCEDURE spAllCategories
AS
select * from Categories
GO
spAllCategories
Stored Procedure that encapsulated complex queries
create procedure spAllProductsCategory
as
SELECT C.CategoryName, P.ProductName, P.UnitPrice FROM Categories C , Products P WHERE C.CategoryId = P.CategoryId
go
Stored Procedure with Where Clause
create procedure spProductsCategorySearch(@pCategoryId int)
as
SELECT C.CategoryName, P.ProductName, P.UnitPrice FROM Categories C , Products P WHERE C.CategoryId = P.CategoryId and C.CategoryId = @pCategoryId
go
spProductsCategorySearch 1
spProductsCategorySearch 2
Stored Procedure for Inserting values into a Table
create procedure spInsertCategories (@pCategoryName varchar(40), @pDescription varchar(60))
as
insert into Categories (CategoryName, Description) values (@pCategoryName, @pDescription)
GO

EXEC spInsertCategories @pCategoryName = 'Condiments', @pDescription = 'Sweets and savory sauces, relishes, spreads, and seasonings'spInsertCategories 'Confections', 'Desserts, candies, and sweet breads'


User Managament Scripts
create database UserManagement

use UserManagement

create table Roles(RoleId int identity(1,1) primary key, Role varchar(40))

create table Users (UserId int identity(1,1) primary key,
RoleId int References Roles(RoleId), UserName varchar(40),
Password varchar(40))

create procedure InsertRole(@pRoleName varchar(40))
as
insert into Roles values (@pRoleName)
go

insertRole 'Admin'

create procedure spAllRoles as
select * from Roles
go

create procedure spInsertUser(@pGroupId int,
@pUserName varchar(40), @pPassword varchar(40))
as
insert into Users values (@pGroupId, @pUserName, @pPassword )
go

spInsertUser 1, 'Greorge', 'george'
spAllRoles

create procedure spAllUsers
as
select * from Users
go

spAllUsers

create procedure spUserCount (@pUserName varchar(40), @pPassword varchar(40), @userCount int output)
as
select @userCount = COUNT(*) from Users where UserName = @pUserName and Password =@pPassword
return
go

spUserCount 'George', 'george', ''

create procedure GetUserRole (@pUserName varchar(40))
as
select R.Role from Roles R, Users U where R.RoleId = U.RoleId and U.UserName = @pUserName
go

GetUserRole 'Shalvin'

GetUserRole 'Manu'

Wednesday, February 25, 2009

Seek ye first Chords

SD F#m G D
Seek ye first the kingdom of God
G D Em A
And His righteous-ness
D F#m G D
And all these things shall be added unto you
G D A D
Allelu, alleluia
D F#m G D
Man shall not live by bread alone
G D Em A
But by every word
D F#m G D
That pro-ceeds from the mouth of God
G D A D
Allelu, alleluia
D F#m G A
Ask and it shall be given unto you
G D Em A
Seek and ye shall find
D F#m G D
Knock and the door shall be opened unto you
G D A D
Allelu, alleluia

Power or your love Chords

G D/F# Em Em/D Bm Em
Lord, I come to You, let my heart be changed, renewed,
D C D Em D
Flowing from the grace, That I found in You
G D/F# Em Em/D Bm Em
Lord, I've come to know, The weaknesses I see in me,
D C D G
Will be stripped away, By the power of Your love

C Em D C G
Hold me close, Let Your love surround me
C Em D G G7
Bring me near, Draw me to Your side
C D C G
And as I wait, I'll rise up like the eagle
D Em D C
And I will soar with You, Your Spirit leads me on
D G
In the power of Your Love
G D/F# Em Em/D Bm Em
Lord unveil my eyes, Let me see You face to face
D C D Em D
The knowledge of Your love, As You live in me
G D/F# Em Em/D Bm Em
Lord renew my mind, As Your will unfolds in my life
D C D
In living every day, In the power of Your Love

My life is in You Lord Chords

G
My life is in You Lord
Em
My strength is in You Lord
C
My hope is in You Lord
G D
In You, it's in You (2x)
C D G
I will praise You with all of my life
C D G
I will praise You with all of my strength
D G E Am
With all of my life, with all of my strength
F Am Dsus D
All of my hope is in You
(Repeat)
(End with chorus)
G D
In You, it's in You (2x)
G
My life.

Open Our Eyes Chords

D G A
Open our eyes, Lord
G D Bm
We want to see Jesus
G A
To reach out and touch Him
G D
And say that we love Him
D G A
Open our ears, Lord
G D Bm
And teach us to listen
G A
Open our eyes, Lord
G D
We want to see JesuS

Majesty Chords

G C
Majesty, worship His majesty
G Em Am7 D7
Unto Jesus be all glory, power and praise
G C Am G
Majesty, kingdom authority flow from His throne
D7 G
Unto His own His anthem raise
Am7 D7 G Gsus G
So exalt lift up on high the Name of Jesus
Am7 D7 B7 Am7 D7
Magnify, come glorify Christ Jesus the King
G C Am
Majesty, worship His majesty
G D7
Jesus who died now glorified
G
King of all kings.

More Love more powe

Em C Bm
More Love, More Power
Em
More of You in my life (2x)
Am
And I will worship You
D Em
With all of my heart
Am
And I will Worship You
D Em
With all of my mind
Am
And I will worship You
D Em
With all of my strength
C D
You are my Lord
Em
You are my Lord

Em C Bm
More Love, More Power
Em
More of You in my life (2x)
Am
And I will seek Your face
D Em
With all of my heart
Am
And I will seek Your face
D Em
With all of my mind
Am
And I will seek Your face
D Em
With all of my strength
C D
You are my Lord
Em D
You are my Lord
Em
You are my Lord

More Love more power Chords

Em C Bm
More Love, More Power
Em
More of You in my life (2x)
Am
And I will worship You
D Em
With all of my heart
Am
And I will Worship You
D Em
With all of my mind
Am
And I will worship You
D Em
With all of my strength
C D
You are my Lord
Em
You are my Lord

Em C Bm
More Love, More Power
Em
More of You in my life (2x)
Am
And I will seek Your face
D Em
With all of my heart
Am
And I will seek Your face
D Em
With all of my mind
Am
And I will seek Your face
D Em
With all of my strength
C D
You are my Lord
Em D
You are my Lord
Em
You are my Lord

Lord I lift your name on high Chords




Guitar strumming pattern - Down Down Up Up Down Up

G C D CDG
Lord I lift your name on high
C D CDG
Lord I love to sing your praises
C D CDG
I'm so glad your in my life
C D CDG
I'm so glad you came to save us
C D
You came from heaven to earth
C G
To show the way
C D
From the earth to the cross
C G
My debt to pay
C D
From the cross to the grave
Bm C
From the grave to the sky
D G
Lord I lift your name on high

Lord I give you my heart Chords

G Em C G D/F#
This is my desire, to ho--nour You
Em G Fmaj9 C D
Lord with all my heart I worship You
G Em C G D/F#
All I have within me I give You praise
Em G Fmaj9 C D G
All that I adore is in You.
Chorus:
G D/F#
Lord I give You my heart
Am7
I give You my soul
C D G
I live for You alone
D/F#
Every breath that I take
Am7
Every moment I'm awake
C D G
Lord have Your way in me.
G D/F#
Lord I give You my heart
Am7
I give You my soul
C D G
I live for You alone
D/F#
Every breath that I take
Am7
Every moment I'm awake
C D Cmaj7
Lord have Your way in me.

Jesus, what a wonder You are Chords

F Gm C F Am Dm
Je--sus, what a wonder You are
Gm C F
You are so gentle, so pure and so kind.
F Gm C F Am Dm
You shine like the morning star
Gm C F
Je--sus, what a wonder You are.

Jesus name above all names Chords

C Cmaj7 C Cmaj7
Jesus, name above all names,
Dm
Beautiful Savior,
G Dm Em G
Glorious Lo-----------rd.
C Cmaj7 C Cmaj7
Emmanuel, God is with us,
Dm G C
Blessed Redeemer, Living Word.

Jesus we enthrone you Chords

G Em C
Jesus, we enthrone You.
G
We proclaim You are King.
Em Bm C
Standing here, in the midst of us,
D7 G
We raise You up with our praise.
G Bm Em
And as we worship build Your throne
C D G Em
And as we worship build Your throne
C D G Em
And as we worship build Your throne
Am C D G
Come Lord Jesus and take Your place.

Jehovah Jireh Chords

Em Am
Jehovah Jireh, my provider
C D Em
His grace is sufficient for me
For me, for me!
Am
Jehovah Jireh, my provider
C D Em
His grace is sufficient for me
Am
My God shall supply all my needs
Em B
According to His riches in glory
Em
He shall give His angels
Am
Charge over me
C D Em
Jehovah Jireh cares for me
For me, for me!
C D Em
Jehovah Jireh cares for me

I will enter his gates Chords

D G D Bm
I will enter His gates with thanksgiving in my heart
D G A7
I will enter His courts with praise
D G F#m Bm
I will say this is the day that the Lord has made
Em A D
I will rejoice for He has made me glad
Ch:
D G
He has made me glad
D Bm
He has made me glad
Em A D G D
I will rejoice for He has made me glad
D7 G
He has made me glad
F#m Bm
He has made me glad
Em A D
I will rejoice for He has made me glad .

In his time Chords

D A D Bm
In His time, in His time,
G Em A A7
He makes all things beauti-ful in His time.
G A
Lord, please show me every day,
F#m Bm
As you're teaching me Your way,
Em C A
That You do just what You say,
D
In Your time.
D A A Bm
In Your time, in Your time,
G Em A
You make all things beauti-ful in Your time.
G A
Lord, my life to You I bring,
F#m Bm
May each song I have to sing
Em C A
Be to You a lovely thing,
A
In Your time.

I worship You Almighty God Chords

G
D G Em C
I worship You Almighty God,
Am D
There is none like You.
G Em C
I worship You, O Prince of Peace,
D
That is what I want to do.
C G Em
I give You praise
C Am7 D Dsus D
For You are my righteousne--ss.
G Em C
I worship You, Almighty God,
Am D G
There is none like You.

I Surrender All Chords

D G A
All to Jesus I surrender
Bm G D A D
All to Him I freely give
D G A
I will ever love and trust Him
Bm G D A D
In His presence daily live
CHORUS-
D G
I surrender all
A D
I surrender all
D G D Bm A G
All to Thee my blessed Savior
D A D
I surrender all

D G A
All to Jesus I surrender
Bm G D A D
Humbly at His feet I bow
D G A
Worldly pleasures all forsaken
Bm G D A D
Take me, Jesus, take me now
D G A
All to Jesus, I surrender
Bm G D A D
Make me Savior wholly Thine
D G A
Let me feel the Holy Spirit
Bm G D A D
Truly know that Thou art mine
D G A
All to Jesus, I surrender
Bm G D A D
Lord, I give myself to Thee
D G A
Fill me with Thy love and power
Bm G D A D
Let Thy blessing fall on me

Hosanna Chords

G D
Hosanna, Hosanna
Em7 C D
Hosanna in the highest!
G D
Hosanna, Hosanna,
Em7 C D
Hosanna in the highest!
C D G
Lord we lift up Your name
C D G
with hearts full of praise
C D G D/F# Em7
Be exalted oh Lord my God!
C D G
Hosanna in the highest!
G D
Glory, Glory
Em7 C D
Glory to the King of Kings!
G D
Glory, Glory,
Em7 C D
Glory to the King of Kings!
C D G
Lord we lift up Your name
C D G
with hearts full of praise
C D G D/F# Em7
Be exalted oh Lord my God!
C D G
Glory to the King of Kings!

Here I am Lord Chords

G Am7 D7 G D
1. I the Lord of sea and sky, I have heard my people cry.
G C Am D7
All who dwell in dark and sin, my hand will save.
G Am7 D7 G D7
I who made the stars of night, I will make their darkness bright.
G C Am D7
Who will bear my light to them? Whom shall I send?
G Em
CHORUS: Here I am Lord, is it I Lord?
Am D
I have heard You calling in the night.
G Em
I will go Lord, if You lead me.
Am D7 G
I will hold Your people in my heart.
G Am7 D7 G D
2. I the Lord of snow and rain, I have borne my people's pain.
G C Am D7
I have wept for love of them, they turn away.
G Am7 D7 G D7
I will break their hearts of stone, give them hearts for love alone.
G C Am D7
I will speak my Word to them, whom shall I send?
G Am7 D7 G D
3. I the Lord of wind and flame, I will tend the poor and lame.
G C Am D7
I will set a feast for them, my hand will save.
G Am7 D7 G D7
Finest bread I will provide, 'til their hearts are satisfied,
G C Am D7
I will give my life for them, whom shall I send?

Holy Holy Holy Chords

D Bm A D G D
Holy, holy, ho--ly! Lord God Almighty!
A Bm A D A E7 A A7
Early in the mor--ning our song shall rise to Thee;
D Bm A D G D
Holy, holy, ho--ly, merciful and mighty!
Bm D D7 G Bm G A7 D
God in three Per-sons, blessed Tri--nity!
Holy, holy, holy! All the saints adore Thee,
Casting down their golden crowns around the glassy sea;
Cherubim and seraphim falling down before Thee,
Who wert, and art, and evermore shall be.
Holy, holy, holy! though the darkness hide Thee,
Though the eye of sinful man Thy glory may not see;
Only Thou art holy; there is none beside Thee,
Perfect in power, in love, and purity.
D Bm A D G D
Holy, holy, ho--ly! Lord God Almighty!
A Bm A
All Thy works shall praise Thy Name,
D A E7 A A7
in earth, and sky, and sea;
D Bm A D G D
Holy, holy, ho--ly; merciful and mighty!
Bm D D7 G Bm G A7 D
God in three Per-sons, blessed Tri--nity!

Heart of Worship Chords

D A
1.When the music fades,
Em7 A
All is stripped away, and I simply come;
D A Em7
Longing just to bring something that's of worth
Asus4 A
That will bless Your heart.
Bridge:
Em7 D/F# Asus4
I'll bring You more than a song,
Em7 D/F# Asus4 A
For a song in itself is not what You have required.
Em7 D/F# Asus4 Em7
You search much deeper within, through the way things appear,
Em7 D/F# Asus4-A
You're looking into my heart.

Chorus:
D Asus A
I'm coming back to the heart of worship,
Em7 G A7sus4 D
And it's all about You, all about You, Jesus.
D Asus A
I'm sorry, Lord, for the thing I've made it,
Em7 G A7sus4 D
When it's all about You, all about You, Jesus.

D A
2.King of endless worth,
Em7 A
No one could express how much You deserve.
D A Em7
Though I'm weak and poor, all I have is Yours,
Asus4 A
Every single breath.
(Bridge)
(Chorus)

He is Lord Chords

G Am D
He is Lord,
G
He is Lord.
Em A7
He has risen from the dead
D D7
And He is Lord.
G G7
Every knee shall bow,
C Am
Every tongue confess
G D G
That Jesus Christ is Lord.
G Am D
He's my Lord,
G
He's my Lord.
Em A7
He has risen from the dead
D D7
And He's my Lord.
G G7
Every knee shall bow,
C Am
Every tongue confess
G D G
That Jesus Christ is Lord.

He is able Chords

C G Am
He is able, more than able
F Dm G
To accomplish what concerns me today.
C Em7 Am7 Em7
He is able, more than able
Bbmaj7 Dm7 Gsus G7
To handle anything that comes my way.
C E7 F Dm7
He is able, more than able
C E7 Am Fm
To do much more than I could ever dream.
C Em7 Am
He is able, more than able
Dm7 C
To make me what He wants me to be.

Glorify Thy Name Chords

C F
Father, we love You
G C
We worship and adore You
Em F G
Glorify Thy Name in all the earth
C F
Glorify Thy Name
E Am (C)
Glorify Thy Name
F G C
Glorify Thy Name in all the earth
Jesus, we love You
We worship and adore You
Glorify Thy Name in all the earth
Spirit, we love You
We worship and adore You
Glorify Thy Name in all the earth

God will make a way Chords

G D
God will make a way
C G
When there seems to be no way.
C G Em
He works in ways, we cannot see,
C D
He will make a way for me.
G D
He will be my guide,
C G
Hold me closely to His side.
C G Em
With love and strength, for each new day,
C D
He will make a way,
C G
He will make a way.
(Repeat)
Eb F Eb Bb
By a roadway in the wilderness he leads me.
Eb F G
Rivers in the desert will I see.
C D
Heaven and earth will fade,
Bm Em
But His word will still remain.
C D E
He will do something new today!
G D
God will make a way
C G
When there seems to be no way.
C G Em
He works in ways, we cannot see,
C D
He will make a way for me.
G D
He will be my guide,
C G
Hold me closely to His side.
C G Em
With love and strength, for each new day,
C D
He will make a way,
C G
He will make a way.
C G Em
With love and strength, for each new day,
C D
He will make a way,
C G
He will make a way.

Give thanks Chords

G Bm7
Give thanks with a grateful heart
Em7 Bm
Give thanks to the Holy One
C G/B F Dsus D
Give thanks because He's given Jesus Christ, His Son
(repeat)
Bm Em7 Am
And now let the weak say, "I am strong"
D7 Gmaj7 B
Let the poor say I am rich"
Em F D7
Because of what the Lord has done for us
(repeat)
G
Give thanks...
Em
Give thanks...
C
Give thanks...
D
Give thanks...
G
Give thanks...

Forever Grateful Chords

A D
You did not wait for me - to draw near to You
E A Bm E
But You clothed Yourself with frail humanity
A D
You did not wait for me - to cry out to You
E A
But You let me hear Your voice calling me
Bm A/C# D D/F# E D/E A
And I'm for - ev - er grateful to You
Bm A/C# D D/F# E D/E A
I'm for - ev - er grateful for the cross
Bm A/C# D D/F# E C#m F#m
I'm for - ev - er grateful to You
Bsus4 B7
That You came
D/E E A
To seek and save the lost

Father I adore You Chords

C Dm7 G C
Father, I adore You
Dm7 G C
Lay my life before You
Dm7 G C
How I love You
Jesus, I adore You
Lay my life before You
How I love You
Spirit I adore You
Lay my life before You
How I love You

El Shaddai Chords

(Chorus)
Dm G/B
El Shaddai, El Shaddai,
C F
El Elyonna Adonai,
Bb E7
Age to age you're still the same,
Am G/B A/C#
By the power of the name.
Dm G7/B
El Shaddai, El Shaddai,
C F
Erkamkana Adonai,
Bb Dm7/A G
we will praise and lift you high,
Gsus C
El Shaddai.

(Verse 1)
Dm G
Through your love and through the ram,
C F
you saved the son of Abraham,
Bb E7
through the power of your hand
Am G/B A/C#
you turned the sea into dry land.
Dm G
To the outcast on her knees
G7/B C Cma7 F
you were the God who really sees,
Bb G C Csus C
and by your might you set your children free.

(Verse 2)
Dm G
Through the years you made it clear
C F
that the time of Christ was near,
Bb E7
though the people couldn't see
Am G/B A/C#
what Messiah ought to be.
Dm G
Though your Word contained the plan,
C F
they just could not understand,
Bb G Bb G
your most awesome work was done in the frailty of your Son.

Praise God from whom all blessings flow Chords

C Em Am G C G7 C
Praise God from whom all blessings flow
C G Am Dm C G7
Praise Him all creatures here below
C G7 C G7 Am F G7 C
Praise Him above ye Heavenly hosts
Em Am Dm C G7 C
Praise Father, Son and Holy Ghost

Create in me a clean heart Chords

G D C G
Create in me a clean heart, O God,
D G
And renew a right spirit within me.

C D G Em
Cast me not away from Thy presence, O Lord
C D G G7
And take not Thy Holy Spirit from me.
C D G Bm Em
Restore unto me the joy of Thy salvation,
C D G
And renew a right spirit within me.

Come Now Is The Time To Worship Chords

Chorus:
D Dsus D
Come, now is the time to wor--ship
A Em G
Come, now is the time to give your heart
D Dsus D
Come, just as you are to wor ship
A Em G
Come, just as you are before your God
D
Come

Verse:
G D
One day every tongue will confess You are God
G D
One day every knee will bow
G Bm
Still the greatest treasure remains for those
G Asus A
Who gladly choose you now





16 Come let us worship (Dave Doherty)




D G D
Come let us worship and bow down
G Em As-A
Let us kneel before the Lord our God our maker (2x)
G-D A
For He is our God
G Em As-A
And we are the people of His pasture
G A D - Bm
And the sheep of His hand
G A D
Just the sheep of His hand

Change my heart oh God Chords

Cmaj7 Em7 Dm7
Change my heart oh God,
G C
Make it ever true.
Cmaj7 Em7 Dm7 F/G
Change my heart oh God,
G C
May I be like You.
Esus E Am
You are the potter,
Dm7 G C
I am the clay,
Esus E Am Am/G
Mold me and make me,
D G
This is what I pray.

Blessed be the Lord God Almighty Chords

C Em Dm
Father in heaven, how we love You
G G7 C A7
We lift Your name in all the earth
C Em Dm
May Your kingdom be established in our praises
F G G7 C
As Your people declare Your mighty works

G7 C Em Dm
Blessed be the Lord God Almighty
G G7 C
Who was, and is and is to come
G7 C Em Dm
Blessed be the Lord God Almighty
F G G7 C
Who reigns fore-ver-more.
(To End)
Dm G G7 C
Who reigns fore-ver-more.

Blessed Assurance Chords

D G D
Blessed assurance, Jesus is mine!
Bm A E A
Oh what a foretaste of glory divine!
D G D
Heir of salvation, purchase of God,
G A D
Born of His Spirit, washed in His blood.
A D G D Bm E A
This is my story, this is my song, praising my Saviour, all the day long;
A D G D G Em A D
This is my story, this is my song, praising my Saviour, all the day long.
D G D
Perfect submission, perfect delight,
Bm A E A
Visions of rapture now burst on my sight.
D G D
Angels descending, bring from above
G A D
Echoes of mercy, whispers of love.
D G D
Perfect submission, all is at rest,
Bm A E A
I in my Saviour am happy and blest;
D G D
Watching and waiting, looking above,
G A D
Filled with His goodness, lost in His love.

Because he lives Chords

G C
God sent His son, they called Him, Jesus;
G D D7
He came to love, heal and forgive;
G G7 C Cm
He lived and died to buy my pardon,
G Em Am D7 G
An empty grave is there to prove my Savior lives!

(Chorus)
G C
Because He lives, I can face tomorrow,
G A D7
Because He lives, all fear is gone;
G G7 C Cm
Because I know He holds the future,
G Em
And life is worth the living,
Am D7 G
Just because He lives!
G C
How sweet to hold a newborn baby,
G D D7
And feel the pride and joy he gives;
G G7 C Cm
But greater still the calm assurance:
G Em Am D7 G
This child can face uncertain days because He Lives!

Chorus
G C
And then one day, I'll cross the river,
G D D7
I'll fight life's fi-nal war with pain;
G G7 C Cm
And then, as death gives way to vict'ry,
G Em Am D7 G
I'll see the lights of glory and I'll know He lives!

Chorus

Be Exalted O God Chords

A D A
I will give thanks to Thee
A D A
O Lord, among the people
(E) F#m E D A Bm E
I will sing praises to Thee among the nations
A D A
For Thy steadfast love is great
A D A
Is great to the heavens
(E) F#m
And Thy faithfulness,
B7 E D C#m7
Thy faithfulness to the sky

D E A A D A E B7 E
Be ex--alted, O -- God -- above the heavens
D E A F#7/A# Bm
Let Thy glory be over all the earth
D/E E A A D A E B7 E
Be ex--alted, O -- God -- above the heavens
Bm E A D A
Let Thy glory be over all the earth!

Ending:
D E A C# F#m
Let Thy glo--ry, let thy glo--ry
Bm7 E7 A D A
Let thy glory be over all the earth!

Awesome God Chords

F#m
Oh when He rolls up his sleeves
F#m
He ain't just puttin' on the ritz,
Bm7 C#m7 F#m
Our God is an awesome God.
F#m
There is thunder in his footsteps
F#m
And lightning in his fists,
Bm7 C#m7 F#m
Our God is an awesome God.

Bm7
And the Lord wasn't joking when He kicked 'em out of Eden.
C#m7
It wasn't for no reason that He shed his blood.
D
His return is very soon
D/B D/F#
And so you'd better be believin' that
Bm7 C#m7 F#m
Our God is an awesome God.

D A
Our God is an awesome God.
E F#m
He reigns from heaven above
D A
with wisdom, pow'r and love
Bm7 C#m7 F#m
Our God is an awesome God

And when the sky was starless in the void of the night,
Our God is an awesome God.
He spoke into the darkness and created the light,
Our God is an awesome God.
And judgment and wrath He poured out on Sodom.
Mercy and grace He gave us at the cross.
I hope that we have not too quickly forgotten that
Our God is an awesome God

As the deet pantheth Chords

D F#m Bm
As the deer panteth for the water
G A D
So my soul longeth after Thee
D F#m Bm
You alone are my heart's desire
G A D
And I long to worship Thee
Bm G D
You alone are my strength, my shield
G Em7 F#
To You alone may my spirit yield
D F#m Bm
You alone are my heart's desire
G A D
And I long to worship Thee
D F#m Bm
You're my friend and You are my brother
G A D
Even though You are a King
D F#m Bm
I love You more than any other
G A D
So much more than anything
D F#m Bm
I want You more than gold or silver
G A D
Only You can satisfy
D F#m Bm
You alone are the real joy giver
G A D
And the apple of my eye

I' Forgiven Chords

D/F# G2 Asus A
I'm forgiven, because You were forsaken
D/F# G2 Asus A
I'm accepted, You were condemned
D/F# G2 Asus A
I'm alive and well, Your Spirit is within me
G2 A D
Because you died and rose again
D G
Amazing love, how can it be
D Asus A
That You my king would die for me?
D G
Amazing love, I know it's true
D Asus A
And It's my joy to honor You
G A D
In all I do I honor You
D D
You are my king, You are my king
D D
Jesus, You are my king, Jesus, You are my king

Above All Chords

A/C# D E A
Above all powers, above all kings,
A/C# D E A E/G#
Above all nature and all created things.
F#m F#m/E D A/C#
Above all wisdom and all the ways of man,
Bm Bm/A E/G#
You were here before the world began.
A/C# D E A
Above all kingdoms, above all thrones.
A/C# D E A E/G#
Above all wonders this world has ever known.
F#m F#m/E D A/C#
Above all wealth and treasures of the earth,
Bm Bm/A C#7
There¹s no way to measure what you¹re worth.
A Bm E A
Crucified, laid behind the stone,
A Bm E A
You lived and died, rejected and alone.
F#m F#m/E D A/C#
Like a rose, trampled on the ground
Bm-A/C# D E A
You took the fall, and thought of me, above all.

Abba Father Chords

A D E A
Abba Father let me be
D E A
Yours and Yours alone
A D E A
May my will forever be
D E A
Evermore Your own.
C#7 F#m C#7 F#m
Never let my heart grow cold
D Bm E
Never let me go
A D E A
Abba Father let me be
D E A
Yours and Yours alone.