SQLTeam.com | Weblogs | Forums

AGS server studio sql commands compare to T-SQL

I haven't used AGS server studio before.

Is there any major differences between AGS server studio SQL commands compare to T-SQL?
How to write a code in AGS server studio to insert a query result in to a new table in another database?

Because i have to run the sql script on a partcular database assigned at the time of starting a new script.

Also can i create a new table by importing data from a text file?

Apreciciate if someone can help me on this.!