var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: What is start with and connect by prior
what can I use in Ms sql instead of Lpad, start with and connect by prior.
Where can I find information about matches of Oracle functions in Ms sql Server?
Can you describe the functionality of each ?
if I understand your question...
I am not aware of any statments in T-SQL that would give you similar results.
(Knowledge is power! Get some!)
LPAD is a function to pad a string on the left with another character string (doesn't have to be a single character, either) repeated often enough to create the desired length
in microsoft sql/server, look at the REPLICATE function, maybe combined with LENGTH and SUBSTRING (i'd have to see your exact requirement)
as for START WITH and CONNECT BY, microsoft sql/server just flat out cannot do that
rnealejr, you may want to bookmark Oracle9i Database Online Documentation, Release 2 (9.2) (free registration required) if you want to look up oracle syntax
okay, replying to my own post, maybe
data shaping can do it, but i'm not sure...
do a search on http://4guysfromrolla.com/, they had an article or two on it
oops, just to be sure, i did that, and guess what, the search on their site brings back 0 results for "data shaping"
so i tried google, and guess what the number 1 hit is? Data Shaping
To duplicate the lpad functionality (where what you are padding is a constant character) you can use the stuff function with replicate.
select stuff('abcdef',1,0,replicate(' ', 4))
will insert 4 spaces before the string.
The only problem with using data shaping is that it is not supported within sql server - only through ado. So you would have to write an application (or com component) to obtain this functionality. I found an article with a good explanation of the start with / connect by:
I solved the problem, I'm appreciate everybody, thanx for help.