Forum Replies Created
Viewing 15 posts - 16 through 30 (of 31 total)
-
RE: Nesting transactions/SPs and error questions (Part 1)
Carl,
Thanks for your responses... I've read the Sommarskog's stuff so many times I can't recall the count right now... there is a point as well where you need to see...
"Work like you don't need the money;
dance like no one is watching;
sing like no one is listening;
love like you've never been hurt;
and live every day as if it were your last."
~ an old Irish proverb -
RE: Execute an Oracle procedure from sql server
Andy,
I've never tried what you are attempting, so I can't help you there... but having worked with both Oracle & SQL SPs, the only thing that comes to mind that...
"Work like you don't need the money;
dance like no one is watching;
sing like no one is listening;
love like you've never been hurt;
and live every day as if it were your last."
~ an old Irish proverb -
RE: Column Naming Conventions (rears it''''s ugly head again :)
Michael,
Thanks for your post/info with the "health care providers" stuff. It was very informative for me (and I'm sure the others following this thread). Your excerpts are right on the...
"Work like you don't need the money;
dance like no one is watching;
sing like no one is listening;
love like you've never been hurt;
and live every day as if it were your last."
~ an old Irish proverb -
RE: Column Naming Conventions (rears it''''s ugly head again :)
"The only exception to Ray's suggestion of leaving the table names off the columns, is for an ID column... if you are using a column that most would call an "ID"...
"Work like you don't need the money;
dance like no one is watching;
sing like no one is listening;
love like you've never been hurt;
and live every day as if it were your last."
~ an old Irish proverb -
RE: Column Naming Conventions (rears it''''s ugly head again :)
Ray (& everyone) thanks for all the responses so far!
I would of course rather leave the table names out, but there are other "issues" at play here. If I could...
"Work like you don't need the money;
dance like no one is watching;
sing like no one is listening;
love like you've never been hurt;
and live every day as if it were your last."
~ an old Irish proverb -
RE: Tax Day
Vic,
OF COURSE I pay taxes, they come off my paycheque automatically every month. I pay at the minimum, CIT ~1000/paycheque right now (and EI ~ 90.00/paycheque and CPP ~ 200.00/paycheque)... oh and I...
"Work like you don't need the money;
dance like no one is watching;
sing like no one is listening;
love like you've never been hurt;
and live every day as if it were your last."
~ an old Irish proverb -
RE: Tax Day
Tales from up north! Not a DBA, and I live in Canada, so our tax deadline is April 30th.
And while there are some things about the US that are better...
"Work like you don't need the money;
dance like no one is watching;
sing like no one is listening;
love like you've never been hurt;
and live every day as if it were your last."
~ an old Irish proverb -
RE: Review Rant
BTW... just came across this article that sort of touches on a similar vein:
http://www.itbusiness.ca/index.asp?theaction=61&sid=58575
Cheers,
Michelle.
"Work like you don't need the money;
dance like no one is watching;
sing like no one is listening;
love like you've never been hurt;
and live every day as if it were your last."
~ an old Irish proverb -
RE: Review Rant
Steve,
Interesting topic... it's one that has come up in lots of ways... I.e. what is "journalism" really?!
I think maybe you touched on this topic a while back in a way…...
"Work like you don't need the money;
dance like no one is watching;
sing like no one is listening;
love like you've never been hurt;
and live every day as if it were your last."
~ an old Irish proverb -
RE: Can you use DATEDIFF in create table statements?
About the data type, SQL Server determines it based upon what you provide as the calculation. That statement and more can be found at this link: http://www.winnetmag.com/Articles/Index.cfm?ArticleID=22831&DisplayTab=Article
It sounds...
"Work like you don't need the money;
dance like no one is watching;
sing like no one is listening;
love like you've never been hurt;
and live every day as if it were your last."
~ an old Irish proverb -
RE: Can you use DATEDIFF in create table statements?
Isn't that reason enough?
Maybe some of these will help:
http://www.insidesql.de/component/option,com_bookmarks/Itemid,42/catid,1/
The sites of the SQL Server MVP's should be a really good start.
Frank,
I...
"Work like you don't need the money;
dance like no one is watching;
sing like no one is listening;
love like you've never been hurt;
and live every day as if it were your last."
~ an old Irish proverb -
RE: Can you use DATEDIFF in create table statements?
Aaron,
Thanks for your help.. that indeed does work, but you don't have to provide a datatype, etc for that calculated column then? Or does it just "figure" that out?
Frank,
I agree...
"Work like you don't need the money;
dance like no one is watching;
sing like no one is listening;
love like you've never been hurt;
and live every day as if it were your last."
~ an old Irish proverb -
RE: Geo-Bee
Steve,
Good luck to your son!
Only thing I noticed with the National Geographic Bee is that the contest is for US only. Kinda weird considering that its focus should be world wide. ...
"Work like you don't need the money;
dance like no one is watching;
sing like no one is listening;
love like you've never been hurt;
and live every day as if it were your last."
~ an old Irish proverb -
RE: Data Dictionary from within SQL Server 2000
Hi there,
Really liked your article on Data Dictionary stuff.. I used your code first thing on a current project that I just took over design for and since there was...
"Work like you don't need the money;
dance like no one is watching;
sing like no one is listening;
love like you've never been hurt;
and live every day as if it were your last."
~ an old Irish proverb -
RE: float problems (with front-end Java app.)
Hi there Frank...
Thanks for your quick response!
quote:
that is the way float and real data types are designed to work. They..."Work like you don't need the money;
dance like no one is watching;
sing like no one is listening;
love like you've never been hurt;
and live every day as if it were your last."
~ an old Irish proverb
Viewing 15 posts - 16 through 30 (of 31 total)