Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 207
  • Last Modified:

what is .. in sql

Hello Experts,

What is ".." in SQL?

Thanks,
Wayne
0
thewayne73
Asked:
thewayne73
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you refer to 4-part-notation

see some variations on how to specify the table you want to query, specifying the table owner, database, linked server name, all optional.

SELECT * FROM table
SELECT * FROM table_owner.table
SELECT * FROM database.table_owner.table
SELECT * FROM database..table
SELECT * FROM linked_server.database.table_owner.table
SELECT * FROM linked_server.database..table
SELECT * FROM linked_server...table

Open in new window

0
 
chapmandewCommented:
it is use to omit the schema name of an object...so, this:

select * from databasename.schemaname.tablename

can be written (if the schemaname is dbo) as

select * from databasename..tablename

you're just leaving out the schema name
0
 
brad2575Commented:
you need to be more specific.

Where at are you referring to this?  In a query?  In a table name path definition?

0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
chapmandewCommented:
angelIII, can you do this? (ive never tried it, but it doesn't make sense that you can)

SELECT * FROM linked_server...table
0
 
thewayne73Author Commented:
Perfect explaination.  Thanks.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>angelIII, can you do this? (ive never tried it, but it doesn't make sense that you can)
>SELECT * FROM linked_server...table

yes. the default database of the login used will be "used" implicitly
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
also, some "linked server" (like oracle) do not have the "concept" of "instance/database", but just database, so that part of "database" must be left empty.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now