55ea8a81   
   From: reb01501@NOSPAMyahoo.com   
      
   vaib wrote:   
   > Hi all,   
   >   
   > I am a .net developer for the past 2.5 years. I am very good with   
   > coding as far as C#, Asp.Net, JScript, etc. is concerned but I am not   
   > very well versed with databases(sql server). Although I can write   
   > simple joins and stuff but it give me jitters when it comes to more   
   > advanced stuff like writing complex dynamic sql and stuff. Also, I   
   > feel the need to consult google for syntax of a lot of things. I know   
   > sql is just like any other language and it's only a matter of time and   
   > practice before I become really good at it. But the thing is that I   
   > would be joining a startup soon where there is a lot of DB intensive   
   > work and I don't want to go there without good DB knowledge. It would   
   > also be a very good opportunity for me to learn DB.   
   >   
   > So, basically what I am asking here is for help. Please tell me some   
   > resources\site\tutorial\book that you know of that can give me a lot   
   > of hands-on exercises. All I want is a lot exercises to do. Writing   
   > lots of dynamic sql. Scenario based questions. Stuff that can prepare   
   > me for the war!   
   >   
   > Thanking in anticipation. I only turn to usenet when I am need some   
   > serious help.   
      
   Avoiding dynamic sql is a better goal, especially if writing web-based   
   applications (sql injection is enabled by the use of dynamic sql).   
   Parameterized stored procedures are a must for the serious sql server   
   developer.   
      
   Anyways, you're putting the cart before the horse here. You really need to   
   learn to write queries (sql) before moving on to dynamic sql. Dynamic sql is   
   simply the process of concatenating some strings together to form a sql   
   statement that gets passed to a database to be executed. If you can't write   
   sql statements, dynamic sql is out of the question.   
      
   But if you must, Erland's written some good articles on the subject. You can   
   find them along with several other good articles at www.sommarskog.se   
      
   www.sqlservercentral.com is an excellent resource.   
   I've heard some good recommendations for a book called Database Design For   
   Mere Mortals, although I've never read it myself.   
      
   Other than that - dive into SQL Books Online (BOL - it's installed on your   
   machine when you install sql server client tools - you can also read them   
   online at microsoft.com - use those google skills to find it ), and start   
   reading.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)