Today i was working with some traces since i am a noob DBA there was this function fn_trace_gettable which had a default parameter, i noticed this weird “::” (double colons) syntax.
Why were there two colons after From and before the function, i never encountered this and i have been working with SQL for the last one year.
Did some research and came to this that in earlier version 2000 this was mandatory to be specified .
so if you ever come across this, probably the code you are using is from a legacy system or by a legacy DBA.
Young people try to make their work less complicated 😉