Last post Mar 03, 2015 12:19 PM by skliz4rel
Mar 03, 2015 11:57 AM|skliz4rel|LINK
CREATE PROCEDURE [dbo].[Getcompanyidbyusername]
@CompanyID int output
select @CompanyID = Client_CompanyID from Client_Company where CompanyUsername = '@PromptID'
It is returning null. @CompanyID is not containing any thing. I dont know what is wrong with it.
Mar 03, 2015 12:04 PM|itpreneur|LINK
Remove the single quote e.g where CompanyUsername = @PromptID
Mar 03, 2015 12:19 PM|skliz4rel|LINK
Oh sorry. The main problem was varchar variable I did not set a memory for it.
After changing it now, the code ran successfully.