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 TouchToneTommy 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: *

  • Users: Zid
  • Content: Threads
  • Order by date
  1. Zid

    How do I automatically generate a key?

    Please I need some help, I am using SQL Server 7 and need to make a trigger that automatically updates a table with a key when rows are inserted or updated. The key has to be in the form 'XYY00001', where 'X' is a character, 'YY' is the last to digits of the current year and '00001' is a serial...

Part and Inventory Search

Back
Top