Madiya122

I am trying to insert records in a SQL table from Excel sheet with VBA code. Data contains of a range with all the rows to be inserted. I am using below code for the same. Insert INTO [odbc;Driver={SQL Server};Server=myserver;Database=mydb;Uid=abc;PWD=abc].DPR Select * FROM [TempRange] I am getting error as above. …

I have following quary example. SELECT t1.TeamID, MemberList = substring((SELECT ( ', ' + FirstName ) FROM TeamInfo t2 WHERE t1.TeamID = t2.TeamID ORDER BY TeamID, FirstName FOR XML PATH( '' ) ), 3, 1000 )FROM TeamInfo t1 GROUP BY TeamID Its giving error "Incorrect syntax near the keyword 'FOR'." …

Hi all, I have just started to learn java. The trial code I have is showing errors at compiling. Here is the code. import java.io.FileInputStream; import java.io.FileNotFoundException; import java.util.Scanner; public class ppp { public static void main(String args[]) throws FileNotFoundException { //Scanner Example - read file line by line in …