J Brune

Baltimore, MD

Sep
26
accepted MySQL - Adding CHECK to a Column
Sep
26
awarded Commentator
Sep
26
comment MySQL - Adding CHECK to a Column
Thank you so much. I'm finding MySQL to be... interesting this way.
Sep
26
asked MySQL - Adding CHECK to a Column
Sep
25
comment Not able to create foreign key "There are no primary or candidate keys in the referenced table"
Right, in PurchaseDate you reference a PK (Purchase_Order_No), but you don't have a PK (Purchase_Order_No), you have a PK (Purchase_Order_No, Purchase_Product_ID)
Sep
25
accepted Datetime in MySQL
Sep
25
comment Datetime in MySQL
Thanks all. I also find I can say SELECT * FROM temp WHERE Col1 < 'potato' and it doesn't throw any error. Learning curve for me to say the least.
Sep
25
comment Datetime in MySQL
No friggin way. It HAS to be yyyy-mm-dd in MySQL?
Sep
25
asked Datetime in MySQL
Apr
25
comment How can I restrict a column to certain values from another table without using a foreign key?
I love how it's #1 on the article. I tried to have separate lookup tables and was overruled. I might try again, or I'll have to drop the 2nd column, and just make the 1st column the primary key and use that, which I was kind of trying to avoid. Thank you all for your prompt and well thought out responses.
Apr
25
asked How can I restrict a column to certain values from another table without using a foreign key?
Jan
21
awarded Teacher
Dec
12
answered How to update TFS workspace after computer name changes?
Jul
8
awarded Notable Question
Dec
25
awarded Popular Question
Apr
20
comment SSIS 2005 - Have UPDATE *and* SELECT in OLE DB Source in Data Flow
Sorry I was not clear. I want the Select/File operation and the Update operation to be part of one atomic transaction. So, if the update fails, the file is not created, and vice versa. I'm assuming one can not do that
Apr
13
asked SSIS 2005 - Have UPDATE *and* SELECT in OLE DB Source in Data Flow
Apr
5
comment TFS 2010 - The path E:\SSIS is already mapped in workspace PC-mypc01
ah, and for SSIS2, map to E:\SSIS\SSIS2. Ok, thanks!
Apr
5
comment TFS 2010 - The path E:\SSIS is already mapped in workspace PC-mypc01
Thank you for the swift response. I'm not sure I understand. If in TFS it *\Folder1\F2\F3\MySSIS1* I want the working directory to be *E:\SSIS\MySSIS1*. If something's in TFS as *\Folder1\F4\MySSIS_2*, I want it to be in *E:\SSIS\MySSIS_2*.
Apr
5
revised TFS 2010 - The path E:\SSIS is already mapped in workspace PC-mypc01
added 123 characters in body
1 2