Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

GO Part 2 Expand / Collapse
Author
Message
Posted Wednesday, September 12, 2012 9:22 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 1:57 PM
Points: 3,466, Visits: 1,811
Comments posted to this topic are about the item GO Part 2

Kenneth Fisher
I strive to live in a world where a chicken can cross the road without being questioned about its motives.
--------------------------------------------------------------------------------
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Link to my Blog Post --> www.SQLStudies.com
Post #1358312
Posted Wednesday, September 12, 2012 9:23 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:17 PM
Points: 5,332, Visits: 25,261
Nice simple straight forward question - glad I remembered the correct answer from a long, long time ago.

I know it is still early and not too many have attempted to answer the question, but I am still suprised at the number of wrong answers.


Correct answers: 40% (2)
Incorrect answers: 60% (3)
Total attempts: 5



If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #1358313
Posted Wednesday, September 12, 2012 9:49 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 4:14 AM
Points: 1,538, Visits: 2,585
I din't know this at all or perhaps I never noticed it as we always go with the default ones.
However I got it right by guessing, this question would not have been asked otherwise.
It made me to have a look at all the settings thoroughly.. Thanks a lot.
Post #1358320
Posted Wednesday, September 12, 2012 10:33 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 31, 2014 7:15 PM
Points: 1,129, Visits: 1,163
I think I missed something .


~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one
Post #1358334
Posted Wednesday, September 12, 2012 11:07 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, September 25, 2014 12:16 AM
Points: 1,371, Visits: 1,561
Nice question Kenneth...though I got it worng
Worth learning something..Thanks!


~ Lokesh Vij

Guidelines for quicker answers on T-SQL question
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com

Follow me @Twitter

Post #1358338
Posted Thursday, September 13, 2012 12:27 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, September 22, 2014 12:21 PM
Points: 835, Visits: 1,372
Another reference: The -c parameter of sqlcmd.



Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

Concatenating Row Values in Transact-SQL
Post #1358353
Posted Thursday, September 13, 2012 12:35 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 2:55 AM
Points: 970, Visits: 2,203
Thank you Kenneth, Interesting one

I have selected the wrong answer, thinking either you change the script or query option, the change is compulsory. And later i read the question again, so came to know the query option change wouldn't matter, but just the script should not be modified.

(In general, if a person parse the code then it will show error/s, so he has to take some careful steps to read the script and then change the query option to meet the script. If A has written the script and B is going to execute and B is not aware of the modified batch terminator and if B is trying to execute it via his machine with default settings, then A and B are going to have some pleasant conversation )


ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
Post #1358355
Posted Thursday, September 13, 2012 1:20 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 3:57 AM
Points: 3,980, Visits: 5,226
Och, tripped myself up on this one, forgot that one can change the batch seperator.

Good question, thanks


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1358361
Posted Thursday, September 13, 2012 2:39 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, September 18, 2014 2:51 AM
Points: 1,743, Visits: 485
This question is illogical in structure.

One cannot say "Can the following script be made to run ..." and then offer the choices True and False.

For future reference, this type of question should be posed in one or other of the following ways, but not as it was originally posed.

Either:
"Can the following script be made to run ..."
Yes No

Or:
"The following script can be made to run ..."
True False


Kenneth Spencer
Post #1358399
Posted Thursday, September 13, 2012 2:47 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, September 25, 2014 12:16 AM
Points: 1,371, Visits: 1,561
kaspencer (9/13/2012)
This question is illogical in structure.

One cannot say "Can the following script be made to run ..." and then offer the choices True and False.

For future reference, this type of question should be posed in one or other of the following ways, but not as it was originally posed.

Either:
"Can the following script be made to run ..."
Yes No

Or:
"The following script can be made to run ..."
True False


Kenneth Spencer


+1
The structure of the question needs conditioning.

But honestly this can be ignored keeping in mind the knowledge it is checking


~ Lokesh Vij

Guidelines for quicker answers on T-SQL question
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com

Follow me @Twitter

Post #1358404
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse