Sql Server 2005 and Visual Studio 2005

[lothos123452000]

I read some where that with the advent of Sql Server 2005 we would be able to program Visual Basic code directly into a stored procedure on Sql Server 2005. Can anyone recommend any books or resources that I can study from on how to accomplish this? Any help offered is greatly appreciated.