Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,171 through 43,185 (of 59,098 total)

RE: Error Creating format file for bcp

Also, the following parameter of:
-S MySQLServer\MyInstance
...should actually be"
-S"MySQLServer\MyInstance"
... because of the special character in the instance name.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 30, 2009 at 9:17 pm

#1018116
RE: Error Creating format file for bcp

allan_au (6/30/2009)
Hi,
Thanks for reading this and hope you can help me.
Tried this:
bcp AdventureWorks.dbo.HumanResources.myTeam format nul -c -t , -f \\SomeServer\SomeFolder\myTeam.Fmt -Sserver_name [MySQLServer\MyInstance] -Ulogin_id Mylogin -Ppassword MyPassword -T
it error out with...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 30, 2009 at 9:15 pm

#1018114
RE: Documenting Database Code: Structured Headers

Heh... I agree... we need automatic forced headers and automated code reviewers for things like "Warning: It's been determined that the code windows on SSC don't work correctly in...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 30, 2009 at 8:45 pm

#1018107
RE: Are the posted questions getting worse?

john.arnott (6/30/2009)
3NF-Boy got me ROFL with this response:w00t:. I can't wait to see Gus's answer. 😉
I took a look at that OP's response. I'd...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 30, 2009 at 6:34 pm

#1018083
RE: How to chage IDENTITY Column seed

Heh... nice to have confirmation. 😉
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 30, 2009 at 4:13 pm

#1018041
RE: Are the posted questions getting worse?

GilaMonster (6/30/2009)
Roy Ernest (6/30/2009)
Today I actually felt that I am invincible or totally ignored. It was as if I was a ghost... 😛
:hehe:
Looks like totally ignored to me.
Looks pretty...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 30, 2009 at 1:51 pm

#1017928
RE: Help Needed ???

Matt Miller (6/30/2009)
Jeff Moden (6/30/2009)
espilman (6/30/2009)
All I was saying is that I wasn't sure whether the integrity of the columns needed to be intact.
That's exactly the reason why I want...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 30, 2009 at 12:16 pm

#1017852
RE: printing 1 to 100 in SQL Server as a batch....

Paul White (6/30/2009)
Jeff Moden (6/30/2009)
Does anyone know if Master.dbo.spt_Values has been deprecated?
Oh. I always thought of it as 'undocumented' anyway...? :unsure:
Heh... yep I know. Just wanted to...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 30, 2009 at 12:04 pm

#1017837
RE: converting lowercase to uppercase

AmolNaik (6/30/2009)
Best is to leave the formatting and case conversions at the front end application, should try not to use SQL Server for formatting and case conversion tasks which are...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 30, 2009 at 11:59 am

#1017833
RE: printing 1 to 100 in SQL Server as a batch....

Yep... I saw that, Lynn. Thanks. I actually thought it was a type-o. Now I know better.
Guess I'll have to fall back a bit and start using...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 30, 2009 at 9:05 am

#1017643
RE: printing 1 to 100 in SQL Server as a batch....

Damn... can't keep up with all the stuff Microsoft wants to take away anymore. Didn't know that. I knew that dbo.sysColumns was going away, just not sys.sysColumns. ...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 30, 2009 at 8:48 am

#1017622
RE: printing 1 to 100 in SQL Server as a batch....

Ack.... :hehe: wasn't trying to be funny on that one. Master.sys.sysColumns will normally contain over 10,000 rows of system related column info even on brand new installations. 🙂
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 30, 2009 at 8:33 am

#1017610
RE: Retrieve comma-separated list within group by

Heh... I figured it was driven by management. As you know (especially because you said so :-)), storing such (CSV) data in any type of table other than maybe...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 30, 2009 at 8:20 am

#1017600
RE: Help Needed ???

espilman (6/30/2009)
All I was saying is that I wasn't sure whether the integrity of the columns needed to be intact.
That's exactly the reason why I want to know what the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 30, 2009 at 6:41 am

#1017523
RE: printing 1 to 100 in SQL Server as a batch....

Paul White (6/29/2009)
Ha! Er, yeah - it raises an error if there aren't enough rows in the system table 😀
Use Master.sys.sysColumns instead... it'll have enough rows. 😉
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

June 30, 2009 at 6:25 am

#1017517

Viewing 15 posts - 43,171 through 43,185 (of 59,098 total)