Solved

MS SQL Server Presentation Layer

Posted on 2014-12-03
7
304 Views
Last Modified: 2014-12-06
What is the most common technology used to build the presentation layer for  MS SQL Server?
Is it visual studio?
0
Comment
Question by:Benki Canoso
7 Comments
 
LVL 65

Assisted Solution

by:Jim Horn
Jim Horn earned 50 total points
ID: 40479791
There is no presentation layer for SQL Server, as it's a database only, and I'm not aware of any limitations for front-end applications to use SQL Server versus any other database.

Tell us what you're trying to pull off here in more detail, and we'll see what we can cough up.
0
 

Author Comment

by:Benki Canoso
ID: 40479861
I am just trying to know if Visual Studio is the most typical interfacing tool used as the front-end? I just want to become more familiar with the front-end options used for MS SQL Server.
Thanks.
0
 

Author Comment

by:Benki Canoso
ID: 40479870
One of the reason I wan to know about the front-end options for SQL Server is because if I want to build a query that requires a user input, I do not believe I am able to test it right on SQL Server environment. If I may, how do you normally test queries that require user input on SQL Server?
0
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 
LVL 79

Assisted Solution

by:David Johnson, CD, MVP
David Johnson, CD, MVP earned 150 total points
ID: 40480004
SQL Management Studio is good for limited testing and for of course,management of Sql Server.
For a User interface you can use anything that can talk to sql server.Excel,Access,Visual Studio (pick your language and project type (windows form, wpf, web, console app) .. at a database level SSRS, SSIS (reporting services/integration services), this is far from an exhaustive list.. Don't forget that SQL Server clients are not limited to the Windows Operating System. Just anything that can access tcpip port 1433..  For a windows client I'd use Visual Studio but that is only MY preference.
0
 
LVL 40

Accepted Solution

by:
Jacques Bourgeois (James Burger) earned 250 total points
ID: 40480010
Yes. The front end that is used the most is Visual Studio.

The more obvious reason is that both are Microsoft technologies, so they can more easily work together than technologies from 2 different companies.

But the main reason is the very intimate integration between both of them. Microsoft has designed them to work together.

SQL Server installs with a simplified version of Visual Studio to enable programmers to build code into the database itself when they need to do stuff that is not possible or too difficult to do in Transact-SQL.

On the other side, Visual Studio comes with tools that lets you work without your server. You can create databases, tables, stored procedures, you name it, directly in Visual Studio. The SQL Server debugger integrates into Visual Studio so that you can debug your stored procedures directly in Visual Studio, with tools that work almost the same way as those you use to debug your VB or C# code.

No other front end provides that level of interrelation with SQL Server.
0
 
LVL 83

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 50 total points
ID: 40480146
As another alternative, PHP on Windows and on Redhat Linux with the Microsoft driver is quite capable of interfacing and displaying queries from SQL Server.  This is the current driver info: http://php.net/manual/en/book.sqlsrv.php  You can also use the old driver on Linux but it does not support all the features of the newer versions of SQL Server.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now