SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Have I been smoking something?? Insert construction question.


Have I been smoking something?? Insert construction question.

Author
Message
Phil Parkin
Phil Parkin
SSC Guru
SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)

Group: General Forum Members
Points: 52193 Visits: 21175
Bhaskar.Shetty (5/24/2013)
Sergiy (5/24/2013)
Phil Parkin (5/24/2013)
[quote] Where is that post?

The first post of this topic.

But saying that you "cannot call insert like that" is clearly wrong.

Not if "like that" means like in the initial post.

But yes, it's wrong, if you take it in the context of following replies.
Than indeed, it becomes a "blanket statement" which does not have enough grounds.

But I was talking not about correctness of that statement (I noted in the end I cannot say it's correct) but about your example.
You managed to build it in such a way that you kinda proved his point!
And you comment about someone being silly made it even more funny.
w00t


Even me explaining to phil , that the original post and the solution what he has given has no link between it, didn't understood the original post and calling other silly. what made me furious.


Please reread my post. Use a dictionary, if necessary, to help you understand its meaning. I did not call anyone silly. I said that the post made you look silly - totally different. Even super-intelligent people can look silly sometimes, it does not make them silly.


Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.
Bhaskar.Shetty
Bhaskar.Shetty
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1136 Visits: 509

Please reread my post. Use a dictionary, if necessary, to help you understand its meaning. I did not call anyone silly. I said that the post made you look silly - totally different. Even super-intelligent people can look silly sometimes, it does not make them silly.


Better you re-read your post and compare it with what you are written above, and its better that we indulge more in solving technical issues than wasting time discussing who's expert and novince. (or silly in your word). ;-). anyways I will like to hear and learn and hear more and mpre from you whole my life.
Phil Parkin
Phil Parkin
SSC Guru
SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)

Group: General Forum Members
Points: 52193 Visits: 21175
Sergiy (5/24/2013)
Phil Parkin (5/24/2013)
[quote] Where is that post?

The first post of this topic.

But saying that you "cannot call insert like that" is clearly wrong.

Not if "like that" means like in the initial post.

But yes, it's wrong, if you take it in the context of following replies.
Than indeed, it becomes a "blanket statement" which does not have enough grounds.

But I was talking not about correctness of that statement (I noted in the end I cannot say it's correct) but about your example.
You managed to build it in such a way that you kinda proved his point!
And you comment about someone being silly made it even more funny.
w00t


I will accept that, had Bhaskar's response been tied to the original post, it would have been valid. But it wasn't - it came after 19 responses. As it did not quote the initial post, I understood it to be taken in the context of the ongoing discussion, not as an independent and isolated comment. I do not think I am alone.


Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.
Phil Parkin
Phil Parkin
SSC Guru
SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)

Group: General Forum Members
Points: 52193 Visits: 21175
Bhaskar.Shetty (5/24/2013)

Please reread my post. Use a dictionary, if necessary, to help you understand its meaning. I did not call anyone silly. I said that the post made you look silly - totally different. Even super-intelligent people can look silly sometimes, it does not make them silly.


Better you re-read your post and compare it with what you are written above, and its better that we indulge more in solving technical issues than wasting time discussing who's expert and novince. (or silly in your word). ;-). anyways I will like to hear and learn and hear more and mpre from you whole my life.


I can't follow your logic. I have not made any claims about myself or anyone else being expert, novice or anything in between.


Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.
Eugene Elutin
Eugene Elutin
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12590 Visits: 5478
I don't know why, but whole this thread looks a bit "silly" to me. The OP original post was about INSERT syntax is not the same as he would expect.
I'm not sure that this sort of thing worth of discussion. As it's really up to the personal preferences and expectations.

I can list few of mine one:

Why UPDATE and not simply CHANGE
Why there is no CLEAR [tablename]?
And at the end, why SELECT?
What does it do? Doesn't it takes and displays the data?
Therefor TAKE * FROM or GET * FROM or SHOW * FROM or DISPLAY * FROM or etc, would be more logical than SELECT which is kind of similar to CHOOSE, at least based on my knowledge of English...
It's endless Hehe


Are you all been smoking something?????????
Hehe

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help
Tobar
Tobar
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1057 Visits: 758
OK. Now I am starting to wonder about the wiseness of opening this argument. :-)

<><
Livin' down on the cube farm. Left, left, then a right.
Phil Parkin
Phil Parkin
SSC Guru
SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)SSC Guru (52K reputation)

Group: General Forum Members
Points: 52193 Visits: 21175
Tobar (5/24/2013)
OK. Now I am starting to wonder about the wiseness of opening this argument. :-)


Nah, I'm looking forward to your next thread: "would Jesus have made a good database developer?" or something similar, I hope :-D

Time for a beer.


Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.
Eugene Elutin
Eugene Elutin
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12590 Visits: 5478
...
Nah, I'm looking forward to your next thread: "would Jesus have made a good database developer?" ....


And if so, who would be the best one in SQL: Jesus, Buddha, Allah, Vishnu or some one form older school, Zeus or Ra...

As old Russian proverb says: "If my grandma had balls she would be my grandpa"
I guess there is ought to be something similar in English, as it's so obvious, isn't it?

I will need something stronger than beer today, and weather is appropriate Hehe

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search