Search results for query: *

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.

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.

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.