Madhivanan's TSQL Blog

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Blogs

Upload Image

Close it

Select File


	Like

Invite Friends

Browse by Tags · View All

sql_server	217
t-sql	211
tsql	116
sqlserver	96
BRH	78
#SQLServer	66
#TSQL	56
SQL Server	34
function	11
SSMS	9

Archive · View All

August 2007	17
August 2010	8
June 2012	7
June 2011	7
November 2007	7
August 2012	6
May 2012	6
November 2011	6
August 2011	6
October 2011	6

Home · Posts · Most Liked · Most Discussed · Ask a Question · Fans (385) · Preferences

Question of the month September 2012 - Identify incorrect CREATE TABLE statements

Sep 12 2012 12:00AM by Madhivanan

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?

Tags:

Previous: Always use Unambiguous date formats in the queries
Next: Generate Column lists for a table

Madhivanan

3 · 39% · 12429

Liked

Lifesaver

Refreshed

Learned

Incorrect


Like this
Post this to my facebook wall
Tweet this
This was a true life saver
Thanks, this helped me to refresh my memory
Very informative, I just learned something new
I disagree, this information is incorrect


	Submit

11 Comments

One statement was incorrect (Statement 4)

commented on Sep 12 2012 12:27AM

Guru Samy

9 · 16% · 4992

Last one is incorrect

commented on Sep 12 2012 2:21AM

Vipul Patel

570 · 0% · 63

last one is incorrect.....................

commented on Sep 12 2012 4:12AM

Nirav Gandhi

38 · 5% · 1503

Hi,

Statement 4 is incorrect because the maximum prefixes required is 2 in Create Table statement.

commented on Sep 12 2012 8:48AM

V Shah

252 · 1% · 176

4 is incorrect.

commented on Sep 13 2012 1:35AM

Thina

478 · 0% · 78

Hi Madhivanan,

Last statement is incorrect, Maximum two prefix 1 for Database, and 2nd for schema..

Pravin Patel.

commented on Sep 13 2012 1:47AM

Pravin Patel

401 · 0% · 100

Last one is incorrect.

commented on Sep 13 2012 2:59AM

abhIShek BandI

104 · 2% · 503

Last statement - create table ...#t4(i int) -- Statement 4 is incorrect because CREATE TABLE syntax accept 3 part naming convention - DATABASE.SCEHMA.TABLENAME

commented on Sep 13 2012 4:01AM

abhijit.more

2893 · 0% · 2

sorry u have posted some comments on my question which are wating for moderators approval

vallabh.sampat@gmail.com

commented on Sep 13 2012 12:08PM

jaySampat

779 · 0% · 37

jaySampat, the comment was approved on your question

commented on Sep 18 2012 12:57AM

Madhivanan

3 · 39% · 12429

Statement#4 is incorrect. All the others are correct.

commented on Oct 26 2012 5:20AM

Gopakumar N Kurup

238 · 1% · 188

Your Comment

Sign Up or Login to post a comment.

"Question of the month September 2012 - Identify incorrect CREATE TABLE statements" rated 5 out of 5 by 13 readers +Madhivanan