Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-03 : 10:04:35
|
| priya writes "As I pass a string, Ex:'Hello' to a stored procedure which is retuning the same to the calling procedure.the result contains only the first letter 'H'.Could anyone help me with this.Here is the code.DECLARE @doc varchar(200)declare @n varchar(200)set @doc='hello'EXEC spInsert @doc ,@n OUTPUTSelect returnvalue = @nStored Procedure:CREATE PROCEDURE spInsert(@doc varchar(200),@n varchar(200) OUTPUT) ASbegin select @n = @docend GO" |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2002-01-03 : 10:14:21
|
| HiAre you sure that this is the code you are talking about ?This just worked perfectly for me (SQL 2000)Damian |
 |
|
|
lfmn
Posting Yak Master
141 Posts |
Posted - 2002-01-03 : 13:58:52
|
| I tried it in SQL Server 7 and it worked finecursors are like hammers - sometimes you have to use them, but watch your thumb! |
|
|
|
Rafiq
Starting Member
25 Posts |
Posted - 2002-01-04 : 01:34:55
|
| HiThis code worked perfectly for me (SQL 7.0/2000)Regards,Rafi |
|
|
|
|
|
|
Stored Procedure