# Stored PROCEDURE

**URL:** <https://forum.kirupa.com/t/stored-procedure/251850>\
**Category:** Uncategorized\
**Created:** [February 13, 2008, 7:42am UTC](https://forum.kirupa.com/t/stored-procedure/251850 "2008-02-13T07:42:29Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![senol](https://avatars.discourse-cdn.com/v4/letter/s/bcef8e/32.png) [@senol](https://forum.kirupa.com/u/senol)\
**Post date:** [February 13, 2008, 7:42am UTC](https://forum.kirupa.com/t/stored-procedure/251850/1 "2008-02-13T07:42:29Z")

</div>

[SIZE=2][COLOR=#0000ff]CREATE[/COLOR][/SIZE][SIZE=2][COLOR=#0000ff]PROCEDURE[/COLOR][/SIZE][SIZE=2] GetThreadMessages [/SIZE]  
[SIZE=2]@iThreadID [/SIZE][SIZE=2][COLOR=#0000ff]int[/COLOR][/SIZE]  
[SIZE=2][COLOR=#0000ff]AS[/COLOR][/SIZE]  
[SIZE=2][COLOR=#0000ff]SELECT[/COLOR][/SIZE][SIZE=2] message\_id[/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE]  
[SIZE=2]thread\_id[/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE]  
[SIZE=2][COLOR=#ff00ff]user\_id[/COLOR][/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE]  
[SIZE=2]first\_names[/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE]  
[SIZE=2]last\_name[/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE]  
[SIZE=2]email[/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE]  
[SIZE=2]subject[/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE]  
[SIZE=2]body[/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE]  
[SIZE=2]date\_submitted[/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE]  
[SIZE=2]category\_name[/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE]  
[SIZE=2]category\_id[/SIZE][SIZE=2][COLOR=#808080],[/COLOR][/SIZE]  
[SIZE=2]last\_edited[/SIZE]  
[SIZE=2][COLOR=#0000ff]FROM[/COLOR][/SIZE][SIZE=2] message\_view [/SIZE]  
[SIZE=2][COLOR=#0000ff]WHERE[/COLOR][/SIZE][SIZE=2] thread\_id [/SIZE][SIZE=2][COLOR=#808080]=[/COLOR][/SIZE][SIZE=2] @iThreadID[/SIZE]  
[SIZE=2][COLOR=#0000ff]ORDER[/COLOR][/SIZE][SIZE=2][COLOR=#0000ff]BY[/COLOR][/SIZE][SIZE=2] date\_submitted [/SIZE][SIZE=2][COLOR=#0000ff]asc[/COLOR][/SIZE]  
[SIZE=2]PLS HELP [/SIZE]  
[SIZE=2][COLOR=#0000ff]DELETE[/COLOR][/SIZE][SIZE=2] ?[/SIZE]  
[SIZE=2][COLOR=#0000ff]UPDATE[/COLOR][/SIZE][SIZE=2] ?[/SIZE]

my home [www.evdenevenakliyatbul.com](http://www.evdenevenakliyatbul.com)