Morphine sulfate isn't an oral or intranasal drug, it's strictly an IV drug. Now there are other kinds of morphine that are better intranasally, like morphine diacetate (which is heroin - yes, heroin is a form of morphine) and morphine hydrochloride is also good taken intranasally. All morphine salts suck orally, some are good intranasally and ALL are amazing in IV form.
Morphine diacetate (heroin) is a quicker acting form than morphine sulfate, when snorted or IV'd so there is a quicker onset and a nicer rush, but they are the same when taken orally.
There are many different salts: morphine (base), morphine sulfate, morphine hydrochloride, morphine tartrate, morphine valerate, morphine isobutyrate, morphine citrate, morphine phosphate, morphine nitrate, morphine bitartrate, etc. All those I listed are schedule II, and there are more that I left out.
These are Schedule I (there are more): morphine diacetate (heroin), morphine methylbromide, morphine methylsulfonate, morphine dinicotinate (nicomorphine), morphine-N-oxide, morphine-N-oxide quinate, and pseudomorphine.
So as you can see, morphine is a complicated drug. What everyone gets for prescription or IV at the hospital is morphine sulfate - 99.9% of the time. Morphine hydrochloride is the second most used after the sulfate salt, but usage of the hydrochloride salt is extremely rare itself. On the streets, we get morphine diacetate (or di-acetyl-morphine or heroin).