Search results for query: *

WOW!!! Thank you VERY VERY much!!!

Can anyone point me to a book that details T-SQL for BEGINNERS. I need something ELEMENTARY to get me up and running. Thanks for your thoughts.

Do you prefer to use stored procedures as opposed to triggers? I.E. The trigger calls a stored procedure as opposed to having all the code in the trigger. Also, could I simply use a cursor to fetch the lst record and increment the column by one unless the limit is reached? Thanks for your time...

Actually the column has no values right now as I am in the design phase. The column will have a value of 1,2,3,1,2,3,1,2,3 etc. Once data is added. also, as new rows are entered the increment would automatically occur. I.E. if the last row was 2 then the next would be 3, then back to 1, then 2, etc.

I have a field that needs to be incremented by one to a certain number, then reset to one again. I.E. 1, 2, 3, 1, 2, 3, etc. How do I do this. It is not a key or constraint field, but rather merely identifies to which team a certain case will be assigned. Thanks in advance for your input.

Does anyone have an opinion as to whether iT is better to have a trigger that merely executes a stored procedure as opposed to actually having all the code in the trigger itself? Are there performance implications, ease of use, etc? Thanks for your input.

How does one create a derived field (column) in a table? I.E. The table has 4 columns (for example) and the 4th column should be the sum of the other 3. Also, can one make a field's (columns) property such that nothing can be entered into the field? Thanks in advance.

Thank you VERY much! I will try it.

As is evident from my questions, I am a novice (at best!). I plan on using Access for the front end. Can that be programmed to return a Yes/No value based on what's in the Binary field? If so, is it difficult to do? Again, thanks for your input and PATIENCE!!!

But then how do I have yes/no appear as opposed to the 1/0 that the boolean puts in the field??? Thanks for your response!

I have a table (TBL_OTHER)that has numerous Yes/No fields. About 20 or so. Can I create a table (TBL_YESNO) that has a primary key and one other field, enter two records in that TBL_YESNO (yes and no), and then relate it with a foreign key to each field in the other table (TBL_OTHER)? Or is...

I am just learning SQL Server and wanted input to determine if this would be an appropriate forum for me. Many times the posts I may have will most probably be of a simple nature and I don't wish to burden all of you if this forum is too advanced for me. Your thoughts please. And thanks in advance.