April 9, 2008 at 5:13 am
Hi,
As i am new to programming I want to learn how to write VB.net script for script component and script task.
Is there any easy way to learn ?
April 9, 2008 at 1:58 pm
Let's give a lift to the topic, as i want to learn this too.
April 9, 2008 at 2:35 pm
Have you ever programmed before in any other language but SQL?
April 9, 2008 at 2:38 pm
I did some in JAVA and little in .net, but that was long back in the college only.
April 9, 2008 at 2:46 pm
The reason I ask the question is all about basic programming concepts.
If you've done programming before (non-SQL), then you probably know all about the basic concepts of structure and covering your IFs with your ELSEs, etc. Basically, how not to create the infamous "spaghetti code". This is important in all types of programming, but rarely (until the advent of Assemblies, etc in SQL 2k5) is seen in T-SQL programming because T-SQL just wasn't robust enough to do what was necessary.
And if you know the basics, then picking up scripting isn't as difficult as it might seem. The first thing you might want to do is get one of those SAMS programming in 24 hours (or 24 days) books if there's one available or a Dummy's Guide book. These are the best way to pick up a new language, though they won't show you everything.
And you'll probably want to get a black book or reference sheet and definitely want to link up to the Microsoft TechNet pages where all the commands are listed.
However, if you have never programmed outside of T-SQL before, I highly recommend taking one of those community college classes on Introduction to Computer Programming.
Learning a new language is one thing, and the more computer languages you know, the easier they are to pick up. However, if you don't know the basics behind programming, then it doesn't matter how fast you "learn" scripting, you're still going to miss something vital which might kill your package.
April 9, 2008 at 10:20 pm
Hi,
Even I have done some JAVA programming before so this suggesion might help. But if you know any links that provides good tutorials that will be great! Thanks for replying
April 10, 2008 at 9:02 am
The code project has a whole lot of scripting help
I refer to W3 Schools continually. It has a LOT of scripting help.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply