LearnItFirst User Forum

Welcome Guest

Search | New Posts | Members | Log In | Register

SQL Server Forum - LearnItFirst.com » SQL Server Database Administration » General SQL Database Question & Answer » Doubt in select query

Doubt in select query

Options

Previous Topic · Next Topic

moonia.das

Posted: Tuesday, February 16, 2010 10:39:15 AM

Rank: Newbie

Joined: 2/16/2010
Posts: 1
Points: 3
Where do you live?: Kolkata

Hi All

I came across the following line in a procedure:

Select ........... from ........ where some_field_name = '##tblname'

Plz neglect the ..... part.What I want to ask is what is ## before tblname ?

Thanks

Scott Whigham

Posted: Friday, February 26, 2010 8:41:44 AM

Rank: Super Mod

Joined: 3/20/2006
Posts: 460
Points: 1,002
Where do you live?: Dallas, TX

Well, in the code sample you posted, it would simply be the name of a column. In that example, the ## is meaningless; it's just whatever someone named the column.

However, your code does not look correct. That is usually a global temporary table indicator

Users browsing this topic

Guest

Forum Jump

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.