Kinky_Geeks's profile . Kinky_Geeks group posts
 |
| MissAnnThropist |
Are any of the IT geeks out here familiar with SQL and SQL Server 2005? I need to pick somebody's brain and just thought i'd see if there are any fountains of knowledge within this group. I'm about to lose my SQL virginity here and am already making mistakes. 
Major edit since initial post I've successfully managed to instal and set up MySQL but was wandering if there are any peeps here I can pester for some tips and stuff?
Edited Sun 2 May 10, 1:02 AM by MissAnnThropist
| 2 May 10, 12:35 AM Doghouse_Reilly UK(MK), 6 yrs  |
Wasn't that the point of getting the book?  Science isn't about why, it's about why not. You ask: Why is so much of our science dangerous? I say: Why not marry safe science if you love it so much. | |
| 2 May 10, 12:37 AM MissAnnThropist UK(SE), 3 yrs    |
Yeah but the book assumes I am using windows Goddamit I hate getting punished for owning a mac. And I'm consulting the book and trying several things but am not doing too well. I GET the concept - I just can't implement it at the moment. Grrrrr Well you bit my lip and drew first blood /And warmed my cold, cold heart Edited 2 May 10, 12:39 AM by MissAnnThropist | |
| 2 May 10, 12:44 AM Doghouse_Reilly UK(MK), 6 yrs |
You deserve to be punished for owning a Mac. Possibly with sticks. Can you not hook up a USB Key install of Ubuntu and work off that? Hardware wise a Mac's just a PC in a poncey shell so it ought to work. Science isn't about why, it's about why not. You ask: Why is so much of our science dangerous? I say: Why not marry safe science if you love it so much. | |
| 2 May 10, 12:52 AM MissAnnThropist UK(SE), 3 yrs |
S'ok - I sorted it out all on my own. 
Now I just want to know who else uses SQL in case I might be able to pick their brains, what with us all sharing that geeky love Well you bit my lip and drew first blood /And warmed my cold, cold heart | |
| 2 May 10, 1:50 AM Litany UK(E), 11 yrs |
yep ,what do you need to ask/know 9 yrs as pro sql developer
I dont charge at the weekend or bank holidays ! "Litany, a poncy show-off with wit, a camera, and his own teeth *swoon*"
Fen "You have some strange taste in music"
Me "If I didn't, I wouldn't be half as interesting" | |
| 2 May 10, 4:38 PM MissAnnThropist UK(SE), 3 yrs |
Thanks @Litany, and @Wicked_Master for your responses.
I think it's working now. I'm just gonna keep tinkering with this till it breaks, or I break, or I've cracked it
Who knows, at this rate I might even be able to become employed again...in a semi-decent job that is (as opposed to working for peanuts, hidden in the basement impersonating Richmond from the IT Crowd Well you bit my lip and drew first blood /And warmed my cold, cold heart | |
| 2 May 10, 9:34 PM Rarius UK(PE), 11 yrs |
I've been a SQL developer since about 2000. Almost exclusively on MS SQLServer, but a little on Access, Oracle and MySQL too. Feel free to ask any questions... I'll help if I can and I may be able to point you in the right direction if not. | |
| 3 May 10, 12:38 AM MissAnnThropist UK(SE), 3 yrs |
Great, thanks for replying. OK, Question number one): I'm trying to create tables using XAMPP to access SQL, and I can't use the numeric datatype: MONEY as it simply isn't listed. I'm using DECIMAL instead for now, but is MONEY an MS SQL specific term or can it be used in MySQL too? In a similar way, NCHAR, NTEXT and NVARCHAR are not available on the list of string datatypes when I use XAMPP. Is there a generic term that all versions of SQL can agree on for these terms or will I have to guess the closest approximate datatype to meet the needs of the fields I am applying these datatypes too.
I'll leave it there for now before I bore folk to tears. Well you bit my lip and drew first blood /And warmed my cold, cold heart | |
| 3 May 10, 1:11 AM Litany UK(E), 11 yrs |
I think Money isn't a MySQL DT ,and I would look at VARCHAR instead of the specfic types. "Litany, a poncy show-off with wit, a camera, and his own teeth *swoon*"
Fen "You have some strange taste in music"
Me "If I didn't, I wouldn't be half as interesting" | |
| 3 May 10, 1:21 AM MissAnnThropist UK(SE), 3 yrs |
Thanks Litany, I'd chosen those options by process of elimination but was wandering if it would have a major impact if some terms were not universal. Well you bit my lip and drew first blood /And warmed my cold, cold heart |
