Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Searching MSDN for the T-SQL help
Message
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00775248
Message ID:
00775303
Views:
17
This message has been marked as a message which has helped to the initial question of the thread.
>>>>>>'/' is divide operator in T-SQL. You can find BOL in MSDN at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/startsql/getstart_4fht.asp
>>>>>>
>>>>>Thanks, it's a little bit better now. Still I have to read lots of pages to find the info, I need. Say, now I need to find out, how the table name in SQL Server should be constructed using full notation. I remember information in Mike Levy book, but I'm afraid, my memory can trick me. What is the first portion of the full name? The Server name?
>>>>
>>>>Sql Server has three parts table name: DB-Owner-Table, for example,
Northwind.dbo.Customers
>>>
>>>Why I thought, it has 4 parts? Do you have Mike's book? Can you check it for me again, please?
>>>
>>>Not that I don't believe you :)
>>
>>Sorry, I don't have that book.
>
>I think, you once mentioned, you have it. SQL for VFP developers...
>
>May be Mike will join this thread then, though I guess, I'm being paranoid... :)
>
>Actually, it turns out that I was right in some respect. Here is the response from another forum's expert:
>===========================================================
>
>You can use a four part name, Server.DB.Owner.Table, when accessing linked servers in SQL Server

You didn't mention linked server and yes it's four part name in this case. The first part been the linked server name.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform