System defined function call in legacy system

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 😉


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s