Stored Procedure returning a string? [duplicate]

Stored Procedure returning a string? [duplicate]

References

Reference NO 1

http://stackoverflow.com/questions/13649284/stored-procedure-returning-a-string

Reference NO 2

http://stackoverflow.com/questions/14574990/finding-strings-with-duplicate-letters-inside

Reference NO 3

http://weblogs.sqlteam.com/dinakar/archive/2007/03/28/60150.aspx

Reference NO 4

http://www.qtcentre.org/threads/29522-QSqlQuery-SQL2005-stored-procedure-does-not-return-string

Reference NO 5

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/2342fb6a-47cc-4c5e-af7c-43ac3de2b7af/action?threadDisplayName=new-line-and-carriage-return-lost-when-string-variable-is-passed-to-stored-procedure

Reference NO 6

http://www.codinghorror.com/blog/2004/10/who-needs-stored-procedures-anyways.html

Reference NO 7

http://sqlblog.com/blogs/aaron_bertrand/archive/2009/11/09/finding-stored-procedures-containing-string.aspx

Reference NO 8

http://www.codeproject.com/Tips/265745/How-to-find-all-the-Stored-Procedures-having-a-giv