In a stored procedure, a parameter @input is passed that contains '.htm' on the end. In the sp I would like to replace the 'htm' with 'doc' and use it as the value of another input.
Is it possible to replace these characters? They would always be on the end although the beginning of the parameter may contain 'htm' as well. But I would want to replace the ending characters.
Why is this different from all of the other step by step guides? Because I make a living as a DBA and not as a writer and I lived through this experience.
Defining the name:
When I talk to people they say different names on this subject stuff l…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied?
You can use SQL Server Initialize from Backup…