How do I develop for MS SQL Server?

[locolini]

Hi everyone,

How do I develop for MS SQL Server?

Does SQL Server have database development tools, or is it just management?

Is there a dev kit or do I need a copy of SQL Server, or does my web host that house the SQL Server provide a dev tool?

Can I just install MSDE to dev locally then upload to an SQL table on the internet provider?

Thanks!

Andres

 

[tlbroadbent]

SQL Server is primarily a datbase engine. To develop applciations, you'll need a development tool. Many tools work with SQL Server as a back-end database - VB, MS Access, Delphi, Powerbuilder, ASP, Java, PHP, C++, etc.

Some SQL development can be done using the SQL Client tools. You can build views, procedures, functions, etc. However, a user interface will still be needed if there is to be any significant user interaction with the database.

You can purchase a developer edition of SQL Server or use MSDE to develop applications that can be used in SQL Server.

Your Internet Service may provide hosting. It is not likely that the ISP will provide application development tools.

Check the Microsoft SQL Server Development website and MSDN for more information.

http://www.microsoft.com/sql/techinfo/development/2000/default.asp

http://msdn.microsoft.com/nhp/default.asp?contentid=28000409

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[locolini]

Terry,

Thanks for your quick reply. I'm a developer and will like to get experience with SQL, but I haven't been able to convince my clients to pay for a $19,000 unlimited user license yet.

Andres