Can I automatically generate queries on Visual Studio similar to what SQL Server Management Studio does?
I had SQL Server Management Studio on my computer and I used it to explore my database. When building the queries, it was very easy to right click on the table and select the "1000" rows. I would take this code and change it. This will allow me to shorten the time to enter all the field names eg.
Now I have MS Visual Studio and I cannot install Server Management Express. I can explore the database and I can right click on the table and view the records. However, I cannot automatically generate a select query. How can I create these queries automatically and is there a way to visually design my SQL query?
source to share