Viewing 15 posts - 1 through 15 (of 47 total)
I apologize for being unclear. I am adding it as a Windows-Authenticated Login to SQL Server. They all appear together in the "Logins" folder under "Security". I used the wrong...
February 27, 2012 at 5:53 am
Lowell, I believe you are correct. However, I have already explicitly added "BUILTIN\Administrators" to my SQL Logins on SQL Server, and granted that login the sysadmin role. Yet, I still...
February 16, 2012 at 9:33 am
That's a great real world example. Thanks for that. On the web applications that I've built, I've never done anything with default values, mainly because I work with applications that...
October 13, 2011 at 5:36 am
Okay. Well, I am still a young programmer and I can't say I'm set in my ways yet, because everytime I do a new project, it seems I'm finding better...
October 11, 2011 at 10:05 am
Yes, that does make sense. So the saveCustomer stored procedure, then, would accept, as parameters, the data fields of the Customer object, and then craft its own UPDATE or INSERT...
October 11, 2011 at 9:47 am
Sean,
No that's fine, that's the whole point of forums. If we all went about our merry way doing things our way all the time, no one would ever innovate.
I have...
October 11, 2011 at 9:33 am
Hmm, you know, I never thought about it from that point of view!
I think I will still stand by my thought that the manipulation of data belongs in the application...
October 11, 2011 at 9:22 am
John, yes, I am issuing an INSERT statement. I apologize for the confusion. I think I called it the wrong thing.
October 11, 2011 at 9:08 am
toddasd, I believe you are correct. I must have been using the wrong term. I apologize. What you said is exactly what I am doing.
October 11, 2011 at 9:08 am
I suppose I could, but I am of the philosophy that program logic goes in the program, and data goes in the database. Stored procedures and triggers or any other...
October 11, 2011 at 8:58 am
Never mind. I'll do it myself, as usual. If you read the whole post you'll see I provided everything that is relevant. This is the second time I've posted here...
April 12, 2011 at 9:45 am
That can never happen. The interface that inserts records into this table receives data from a mainframe through an interface system. Even if we had to do a major resend...
April 12, 2011 at 9:29 am
Wayne, sets are not passed into this table. Only single INSERT statements populate it, and that is not up to me. You must realize that I inherited this portion of...
April 12, 2011 at 8:56 am
An earlier portion of the trigger. They actually come straight in from the INSERT statement that initially fires off this trigger.
Does any of that really matter? The only question I'm...
April 8, 2011 at 2:37 pm
Yes it is.
April 8, 2011 at 2:13 pm
Viewing 15 posts - 1 through 15 (of 47 total)