Home Forums Article Discussions Article Discussions by Author Discuss content posted by Harsha Majety Get String between two delimiters RE: Get String between two delimiters
TechnoPeasant
SSC-Addicted
Points: 427
More actions
July 25, 2012 at 10:27 am
#1517491
Care to comment as to why it returns this error in SQL 80 AND 90?
DECLARE @sampleString VARCHAR(1000) = '#This is a sample string# between two delimiters'
"Msg 139, Level 15, State 1, Line 0 Cannot assign a default value to a local variable."