One good reason to download and install November CTP of Katmai (especially lazy coders like me :))


and………this reason is the intelli sense capability over writing TSQL code, and yes it does work against your SQL Server 2005 database as well. So start using the SQL Server Management Studio from the November 2007 CTP of Katmai.


As soon as you start typing TSQL code, for example select @@…a drop down with all the options will appear.


 Intellisense in SQL Server


 Further to this when you type in FROM and then start typing the next bit, it will present you with a list of schemas, databases from which you may want to query.


Schema Select


Once a Schema is chosen, it will list out all the tables wihtin the schema (I am not sure if it checks your security context – this is something I did not test…so if anyone has done this or knows about this please post a comment :))


Table Select


It understands the aliases for the table and lists out the columns. All of this makes writing queries lot easier, making developers more productive and give them time to do what they do best – CODE more 🙂


Column Select


 


Happy SQL’ing

Comments (2)

  1. aw says:

    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Depnaker
    http://www.lokerjobindo.com
    http://lokerjobindo.com
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bank
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20Agustus
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20April
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20Desember
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20Februari
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20Januari
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20Juli
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20Juni
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20Maret
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20Mei
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20November
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20Oktober
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bulan%20September
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20BursaKerja
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20CPNS
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bank%20BRI
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Bank%20Mandiri
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Banyak%20Posisi
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20BUMN
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Terbaru
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20Terkini
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20CPNS
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20D1
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20D2
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20D3
    http://www.lokerjobindo.com/search/label/Lowongan%20Kerja%20D4