Search the Community

Hi all, In this code i display all computername of my SCCM SQL Server. I need to do more complex query for some reports but i don't know how to do some basic query. Can you help me to : 1st/ Display in an array each table of the data base 2nd/ Display * from a specific table (ex: display all value rows/cols from v_R_system in an array) #include<sql.au3> #include<array.au3> $sqlCon = ObjCreate("ADODB.Connection") $driver = 'DRIVER={SQL Server}' $server = 'SERVER=servename' $DB1 = 'DATABASE=DBNAME' $user = 'UID=USERNAME' $TC = 'Trusted_Connection=Yes' $sqlCon.Open($driver & ';' & $server & ';' & $DB1 & ';' & $user & ';' & $TC & ';') $NameList="" if @error Then MsgBox(0, "ERROR", "Failed to connect to the database") Exit Else MsgBox(0, "Success!", "Connection to database successful!") EndIf $result = _SQLQuery($sqlCon,"select name0 from v_R_System") With $result While Not .EOF $NameList &= .Fields ("name0").value & @CRLF .MoveNext WEnd EndWith Thx for reading. Regards. ReekoD