Consider the following CREATE TABLE statements
create table #t1 (i int) -- Statement 1
create table .#t2 (i int) -- Statement 2
create table ..#t3 (i int) -- Statement 3
create table ...#t4(i int) -- Statement 4
How many are incorrect statements?
One statement was incorrect (Statement 4)
Last one is incorrect
last one is incorrect.....................
Statement 4 is incorrect because the maximum prefixes required is 2 in Create Table statement.
4 is incorrect.
Last statement is incorrect, Maximum two prefix 1 for Database, and 2nd for schema..
Last one is incorrect.
Last statement - create table ...#t4(i int) -- Statement 4 is incorrect because CREATE TABLE syntax accept 3 part naming convention - DATABASE.SCEHMA.TABLENAME
sorry u have posted some comments on my question which are wating for moderators approval
jaySampat, the comment was approved on your question
Statement#4 is incorrect. All the others are correct.