Learning more about programming and scripting

[bdaedalus359]

Hey all

I work at a company that develops software that is solely based on MSSQL 08 and currently all I do is test the software that is developed and that includes occasionally writing complex sql queries but that's about it. I'm looking to expand my personal knowledge and usefulness to my company and my manager mentioned that he needs someone to write scripts to automate the importation of data into our servers. Since we use SQL Server 2008, I assume the scripting language is VBA.

Can anyone tell me some other simple scripting and or programing languages that are relatively easy to pick up and learn? I'm thinking the opposite of C++

[Rubberman]

SQL Server uses a language called Transact-SQL, which is a procedural language invented by Sybase from whom MS first purchased the code base that became SQL Server. So, to do complex applications or to do what you mention (automation of complex data import tasks), VBA is NOT the way to go, but T-SQL is, especially since you can do complex transaction activities (nested, conditional, etc) much more easily to deal with data import dependencies and validation.