Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Dagaz
Starting Member
7 Posts |
 Posted - 2004-12-01 : 13:14:04
|
| Hi I am new to T-SQL and was wondering if anyone had any good pointers for starting? or places with good examples?I have done asp, vb, MS Access. and HND Computing. SO not great but ok at stuff lol.basically i want to do run a weekly update on a table and depending on some randomness and a value that is linked via another table change the values in the table.thanks in advanceDagaz |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2004-12-04 : 16:07:31
|
| Since you've already used Access you should have some grasp on how data is stored in tables and how tables can be joined together, etc.Start with the basics - Get and read "INTRODUCTION TO DATABASE SYSTEMS" by C.J Date...It's the bible.Read BOL religiously. Whenever you have a question or run across a term you are unfamiliar with, see if you can find the answer there first. It's light in some areas and sometimes the info is a little hard to find but it's worth looking.As to your issues, what specifically are you unclear on?HTH=========================================Let X = {All sets s such that s is not an element of s}(X element of X) ==> (X not element of X)(X not element of X) ==> (X element of X) (Bertrand Russell Paradox) |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2004-12-05 : 09:52:05
|
try the help F1 in MS SQL server, its about the best reference you get. Since you are already a techieto run, updates based on an insert, update or delete on another table, read about triggers.Also read about stored proceedurees, once you get a hang of T SQL you would find out thats its quite simpleEnjoy Afrika   |
|
|
|
|
|
|
New to T-SQL