August 7, 2015 at 12:03 am
Comments posted to this topic are about the item Transact-SQL Syntax Conventions
August 7, 2015 at 12:58 am
This was removed by the editor as SPAM
August 7, 2015 at 3:15 am
Easy one, thanks!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 7, 2015 at 3:15 am
Sorry but I think the question was misleading/unclear. All were valid Object Reference Format of object names.
server.database.schema.object
Four-part name.
server.database..object
Schema name is omitted.
server..schema.object
Database name is omitted.
server...object
Database and schema name are omitted.
database.schema.object
Server name is omitted.
database..object
Server and schema name are omitted.
schema.object
Server and database name are omitted.
object
Server, database, and schema name are omitted.
August 7, 2015 at 3:27 am
g.maxfield (8/7/2015)
Sorry but I think the question was misleading/unclear. All were valid Object Reference Format of object names.
I don't agree with you. The examples you provided are valid, but not the ones in the question, as you can see in the explanation.
August 7, 2015 at 3:47 am
OK Thanks. Since I'm new to the forum's I appreciate the feedback.
August 7, 2015 at 5:51 am
An easy one to end the week. Thanks.
August 7, 2015 at 8:20 am
Thanks for the question. Good one to end the week with.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 7, 2015 at 8:25 am
Mighty (8/7/2015)
g.maxfield (8/7/2015)
Sorry but I think the question was misleading/unclear. All were valid Object Reference Format of object names.I don't agree with you. The examples you provided are valid, but not the ones in the question, as you can see in the explanation.
+1
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 10, 2015 at 1:35 pm
Really easy. Thanks, Naveen!
August 18, 2015 at 7:24 am
Nice question, thanks.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply