SQL programming

20 pts.
Tags:
SQL Server
If I have info about clients on my server is it possible to program SQL to send only certain parts to certain people who all require different information to save me typing it in manually every time. Much like a price comparison website. Also is it possible to access my database from outside the office simply using SQL and an internet connection?
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Sounds like all you need to do is setup a webpage which accepts a basic input parameter and runs a query to display some data based on what the user needs to search for. This is pretty much what SQL Server was designed to do.

Yes you can access a SQL Server directly from the internet, but it is not recommended as this will require that you make your SQL Server publicly available which leads to brute force attacks on your database. It is recommended that you instead setup a VPN solution so that you can VPN into the office and then you can log into the SQL Server as if you were sitting at the officel

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: