save data from database (sql server) into a global variable using nodejs

You have created a synchronous function and your query to the database is asynchronous. So when console.log is raised your req.query still is pending. You can do something like this

   function getCord() {
       return new Promise((resolve, reject) => {
           // Create instence of connection
           var conn = new sql.ConnectionPool(config);
           var req = new sql.Request(conn);
           // Connecting to database
           conn.connect(function(err){
               if(err){
               console.log(err);
                  return;
            }
            // Getting result
            var queryString = "SELECT * FROM  XXXX";
            req.query(queryString, function(err, recordset){
                if(err){
                    console.log(err)enter code here;
                    return;
                }
                else{
                    //console.log(JSON.stringify(recordset));
                    table = recordset;
                }
                conn.close();
                resolve(true);
            });
         });
    });
}
getCord().then(() => console.log(table));