Norwegian and SAS have flights from Copenhagen to Aalborg, while Norwegian and other airlines also offers international direct flights from European cities. The airport is located north of the city. Take Bus no. 2, 22 (late night), 70, 71 and 200 or a taxi (approximately 170 Kr) to town. If you have little luggage and small budget, you can walk ~2km until the Lindholm train station. A extension of the railway is planned from Lindholm to Aalborg Airport and will be ready in a few years. It is also possible to walk by foot all the way from the Airport to the city, 6km, approximately 1 hour)
Bus or train to the center should be still available after midnight.
Aalborg Busterminal on John F Kennedy Plads (The John F Kennedy square, phone: 98 12 87 13) right by the station is a large regional hub for long distance, regional and local buses. Express buses (XBus) leaves several times per day towards Aarhus (via Hadsund), Rønbjerg, Nykøbing Mors, Løkken, Frederikshavn, Asaa, Holstebro, Viborg (via Silkeborg) and Esbjerg. In addition regional buses connects to nearly every city of some size in North-Eastern Jutland.
There are ferries from Norway/Sweden/UK coming to North Jutland (Hirtshals or Frederikshavn). From there you can take bus or train to Aalborg. Cruises visit Aalborg Waterfront often in the summer period.
In the center it's easy to walk by foot. To go further, there is a good public bus system and you can purchase a ticked from the bus driver; the standard tickets costs 20 Kr and allows you to travel within two zones (for example from city center (zone 1) to any other surrounding zone) within one hour. Taxis are very expensive.
The best way is still to get around by bicycle and you can rent one close to tourist information office. There is also a city bike scheme (doesn't work during the winter time, though) where you may borrow a bicycle from any of the 20 city bike stands shown on this map; you'll need to make a 20 Kr deposit to unlock the bicycle and you get the coin back when you return it to any of the bike stands. For longer stays, a better option is buying one. Police has auctions once per month, you can ask about them in the police station (the auction is held in Danish, so it's better to come with someone who speaks this language).
Aalborg Townhall, Gammel Torv 2, ☎ +45 9931 3131. Built in 1759.edit
Aalborg Zoo, Mølleparkvej 63, . Cosy zoo with many "classic" zoo animals such as giraffes, elephants and big cats. The biggest enclosure is the savanna, where several African animals are free-ranging. There is also a big playground and a nice restaurant.edit
Lille Vildmose, (southeast of Aalborg and hard to reach by public transport). The largest raised bog in western europe, good wildlife exebition center with small cafe and restaurant and excellent bird watching.edit
Royal Taxhouse, Strandvejen 1. Built in 1902 representing national romantic architecture. In 2005, it was brought back to its original style. Next to the house is a musical fountain, during summer at noon, 3PM, 6PM and 9PM Händel's Water Music accompanise the splashing water.edit
Utzon Center, Slotspladsen 4, ☎ +45 7690 5000 (firstname.lastname@example.org), . Tu-Su 10AM-5PM. A cultural centre exhibiting art, architecture and design. Focuses on Jørgen Utzon's own work and other work somehow related to him. Also has a restaurant.60 Kr, seniors 40 Kr, students 20 Kr, children under 18 years free, group 40 Kr. edit
Aalborg Karnival, . The biggest carnival in Northern Europe. If you want to have fun with Danish people this is a great opportunity.edit
Bicycle. Rent a bicycle and go along the fjord.edit
Casino Aalborg, Ved Stranden 16, ☎ +45 9810 1550 (email@example.com, fax: +45 9933 7099), . Su–Th 8PM–3AM, F-Sa 8PM–AM. Offer American Roulette, Black Jack, Poker and slot machines. Nice experience, but the atmosphere here is not as chic and international as you might expect.50 Kr. edit
Egholm. Take a ferry to this small island in the fjord.edit
Ice-skating, C.W. Obels Square (behind the Student House). edit
Jumboland, Gøteborgvej 33, ☎ +45 9818 8843 (firstname.lastname@example.org), . M-Tu during holiday 10AM-6PM, W-Th, Su 10AM-6PM, F 10AM-7PM, Sa 9AM-7PM. Indoor playground of 2,400 sqm. Does also have a café.60 Kr, children 18 months-15 years 80 Kr. edit
Open Swimming Pool (Friluftsbad), Skydebanevej 14. Free. edit
Friends: nice location toward the street junction and have the option to stay outside. A snack with salmon salad and mixed fruit cocktail juice costs ~90 Kr. Make sure to have the Kr currency on you, since they are not accept Euro.
Emiki Pizza: small pizza place & freindly staff I took vigge pizza with Coke for 45dk.
Utzon Restaurant : restaurant in Utzon Center. It serves "smørrebrød" in a new nordic way. Beautiful view at the waterfront.
Jomfru Ane Gade is said to be the street with the longest continuous stretch of restaurants and bars in Scandinavia.
The Wharf. Borgergade 16, tel: 98117010 has the best beer in town (same owner as Charlies in Copenhagen).
The Irish House. Østerågade 25, tel: 98141817, 
London Pub. Boulevarden 7, tel: 98117770.
Jomfru Ane Gade is a short street with 30 restaurants/bars. Drinks are expensive and the bars are open late. You will see signs advertising 10 Kr drinks and 10pm-12am happy hour.
1000fryd: Kattesundet 10, tel: 98132221, is Aalborg's only bar run by activists. 1000fryd has been around since 1984 when Aalborg's alternative scene bought the place. Now the place is known for their ecological beer, underground music scene and D.I.Y. attitude towards life. 1000fryd has two reccurring festivals, namely their Punk/HC festival and their Queer festival. 
Student house [www.studenterhuset.dk] right across the Budolfi church hosts international evenings on Wednesdays, as well as various concerts on Fridays. Very informal.
Behag din smag, Maren Turis Gade 5, ☎ +45 8734 0486, . M-F 9AM-6PM, Sa 9:30AM-4:30PM. Coffee, tea and chocolate. If you enjoy good coffee, then this is the spot. One of the owners was the Danish Barista champion of 2007.edit
Aalborg is also the home of De Danske Spritfabrikker which produces a great number of distilled beverages. Their most famous product is the Aalborg Taffel Akvavit, colloquially known as a "Rød Aalborg" (Red Aalborg).
Eyvind Andreasen B&B Kronprinsens alle 34, tel: +45 98172562, email:email@example.com. Friendly place just north of the bridge. Has three rooms sharing bathroom, kitchen, separate entrance. TV, beer and wine available in the kitchen at very reasonable prices. 270 Kr, 325 Kr (double).
Scheelsminde Hotel & Gastronomi Scheelsmindevej 35 - DK-9100 Aalborg, tel: +45 98 18 32 33 - Fax +45 98 18 33 34 -email:firstname.lastname@example.org. A nice 4 star hotel-restaurant mostly for business people.
Radisson SAS Limfjord Hotel Ved Stranden 14-16 - DK-9000 Aalborg, til: +45 98 16 43 33 - Fax +45 98 16 17 47 - email: email@example.com. Big 4-star hotel with a view towards the Limfjord. Prices from 1200 - 2000 Kr per night.
Danhostel Aalborg, Skydebanevej 50 - DK-9000 Aalborg. A hostel outside the centre of Aalborg which contains some huts on an island. It is cheap to sleep at this hostel and the ferry to Egholm is not far from it.
For beach, you can take a bus to Blokhus or Løkken (North Sea, around 40km) or Hals (Baltic sea, around 30km) and walk some 3km north, or take a less frequent bus that passes Hou, to, e.g., Bisnap strand (Baltic sea). The North sea is more windy most of the time, and there are nice sand dunes there. There are German bunkers from World War II near to Løkken, and they can be also interesting to see.
Fårup Sommerland. This amusement park can be reached by bus from Aalborg Rutebilstation. The amusement park has many rides and a water park.
This is a usable article. It has information for getting in as well as some complete entries for restaurants and hotels. An adventurous person could use this article, but please plunge forward and help it grow!