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 |
|
Jarid.Lawson
Starting Member
7 Posts |
 Posted - 2009-12-02 : 13:58:19
|
| I just found this website today, and already it has paid off with a section of code that just wasn't doing what I wanted it to do. As such, I see a need to improve my understanding of some of the more complex/less common features SQL Server 2008 offers.I have a good understanding of basic SQL scripting (i.e. - select, update, inner join, insert into, etc.). After that I understand the basic concepts of a few things, but being totally honest with myself I would need to research most of the options in this large section of SQL Server knowledge (i.e. - identity_insert, substring [the advanced options like everything to the left of a comma no matter where the comma is...I saw that in an Oracle environment, but I don't have the code anymore], etc.).Does anyone have any suggestions on books/research resources that could help me go from an average user into the higher ranks? I know I have a long way to go before I could call myself truly adept or a SQL Server guru, but I would like to take a few more steps in that direction.Jarid Lawson"A little knowledge is dangerous. So is a lot." - Einstein |
|
|
Jarid.Lawson
Starting Member
7 Posts |
Posted - 2009-12-02 : 14:07:13
|
| Just another great example of stuff I have only a vauge understanding of:* declare @TableA - not sure what this does or how it works/when to use it* Begin Tran - Update Statement - Commit Tran vs. Update Statement by itself - what is the difference, and when should I use each different type?* Rollback - I know that it removes the update that was just made, but when/how do I use it?Jarid Lawson"A little knowledge is dangerous. So is a lot." - Einstein |
 |
|
|
|
|
|
|
|
Research advice