I Have a sql Functin which Remove Special char from string now
Declare @newVal1 varchar(250)
Declare @Name varchar(250)
set @Name = 'dasd#4334543 ewr534543%#$^%$^%$'
set @newVal1 = 'SELECT dbo.RemoveSpecialChars(' + QUOTENAME(@Name, '''') + ')' ;
exec(@newVal1)
i want to store returned value of exec(@newVal1) in a variable
like this Declare @var1 varchar(250) = exec(@newVal1)
how can do this
Need help
...
Go to the complete details ...