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 😉

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s