There are no indexes on either field. I am going to create a query plan to see the results. '

I originally asked the question because I have a vague recollection...

Thanks. I will do what you suggested.

Thanks Jeff. You are 100% correct. I always put an ID column on tables without giving it much thought. In this case I clearly don't need it.

Thank you all for getting back to me. I appreciate the advice. Because of your advice, I won't make a big deal out of removing the ID. Oddly, I spoke...

That's a given. I always do as much work as I can on the server. The question is whether to have the stored procedure do a join to obtain all...

I never thought of that.

Thanks

Thank you. I prefer that option as well. The only reason that I asked the question was because of something a phone app programmer told me.

Thanks for getting back to me. I prefer letting the database do the work.

I have never built a phone app before. The only phone app builder that I know told me that because of hardware and memory limitations on a phone that you...

Thanks for getting back to me.

I have always been hesitant to use a flag in one table when I could get that same information using a database query. Since the...

Thanks for getting back to me.  I may not have explained myself properly with my fictitious example, but it appears that your StudentTest table servers the same purpose as my...

• This reply was modified 1 month ago by  eichnerm.
• This reply was modified 1 month ago by  eichnerm.

Thanks. I knew that, but it's always nice to get confirmation of what you know.

I am considering having a series of individual CRUD procedures that don't include transaction processing, and...

Thank you for the response.

I had been told by an instructor that I would have problems wrapping two stored procedures within a transaction, and that I should just copy the...

Thank you for your advice. For my needs this appears to be a great solution.

Thank you. I ran a test. It's amazing. It simplifies what I was planning to do.

I am wondering if there are any negatives beyond the negative of hardcoding a value...