Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. critzos

    T-SQL Resource

    WOW!!! Thank you VERY VERY much!!!
  2. critzos

    T-SQL Resource

    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.
  3. critzos

    Incrementing Field

    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...
  4. critzos

    Incrementing Field

    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.
  5. critzos

    Incrementing Field

    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.
  6. critzos

    [color red]TRIGGERS WITH TSQL VERSUS STORED PROCEDURES

    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.
  7. critzos

    DERIVED FIELDS

    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.
  8. critzos

    Yes/No Fields

    Thank you VERY much! I will try it.
  9. critzos

    Yes/No Fields

    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!!!
  10. critzos

    Yes/No Fields

    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!
  11. critzos

    Yes/No Fields

    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...
  12. critzos

    Basic Level Programmer

    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.

Part and Inventory Search

Back
Top