what is an SQL sever?
445127
SQL Server .. is the host machine running a DB that uses SQL language as its DB language (concerning DB query and other related DB activities)\n\nSQL is an open source programming language that is used to create, manipulate, store, or quesry a database and it stands for the term (Structured Query Language) meaning it's an open source language -- that any company can use it without paying any charge in accordance with such use! .. yes just like the network protocol (TCP/IP) \n\nMany Large Database companies used this language to create a very powerful and flexiable database systems of course Oracle, IBM, Microsoft, and many others have a very well known systems for example : Oracle applications, Microsoft SQL, DB2, sybase, mysql ... etc.\n\nWhat makes it special is that you feel you set the criteria of the data you want to retrive out of the database like you are talking our easy english language while typing the query! .. that really helped it to spread out so quickly and effeciently.\n\nAnd example that i am sure you used it at lest once .. when you are looking for something to get it downloaded to your computer using one of the free available search engins on the internet (like Yahoo, Webcrawler, Directhit, Google, etc..) the key word you type in the search blank is excatly the criteria that will be used to query Yahoo's or google's Very large DB that contains Millions of websites! so those Yahoo, and Google and any other search engins have large computer servers holding a very neat DB that contains the data (in this case the websites) these computer servers act as data warehouses .. and once you place what you are looking for .. their systems translate it into a simple query and the results page just shows what you have been looking for BASED ON WHAT YOU USED AS A KEY WORD .. so if you didn't get what you were looking for .. don't blaim those guys . just change your keywword and everything will be fine.
96266
som web programmers implements authentication very poorly and its possible to bypass the authentication by providing some sql trick in username login fields, and this is called as SQL injection
360932
A stored procedure. Or, if there's no support for stored procedures per se, a function.\n\nGood luck with the rest of your homework!
361351
You can do this with ASP>net and SQl connection object.\nYou can also use Jav and JDBC
888756
You can use a freeware version of SQLyog tool from http://www.webyog.com/.\n\n1. You have to first register both you production server and the development server.\n\n2. Make a connection to both servers\n\n3. Create a blank database on prodction server (in case there is no database on production server).\n\n3. Right click on the production server database and select the 'Copy databases to different Host/DB...'
774615
I found this for you : http://www.databasejournal.com/features/mssql/article.php/1756161\n\nHope that helps! Sounds like fun!
580927
Well, usually depends on what type of hosting solution you have. If the host is ran on a unix/linux box, you will often find MySQL installed. If it is a windows solution, you usually find MS SQL Server.\n\nHere are some advantages of both...\n\n1) MySQL is usually very fast database because it is strongly based on an index lookup type of structure. \n\n2) Works great with languages like PHP which I highly recommend you use for a website.\n\n3) Very memory efficient and takes less space to run on a server (usually).\n\n\nMS SQL Server\n\n1) Integrates well with other Microsoft products. If you have an all microsoft hosting solution going, you will probably want SQL Server.\n\n2) It allows the use of Stored Procedures which allows you to execute groups of commands on the server independent of user activity.\n\n3) Some of the later versions also offer great reporting utilities and statistics.\n\n\nBut this is all usually dependent on what you are running for an Operating system on the host. PHP and MySQL are great for unix/linux systems and ASP/MS SQL Server is good for windows environments.\n\nEven though you will find people on here leaning one way or the other, it all really depends on what you are looking for out of your website. Generally unix/linux is more stable but a bit harder for newbies to use and windows uses a lot of resources and less stable, but easier for newbies to use and understand.\n\nI hope I have made things a bit more clear for you.
1011783
Select {columns}\nfrom {tables}\nwhere {conditions}\n\nIt is the structure of a language meant to grapple with tables and columns instead of files and fields.
14293
SQL Server 2005 is a comprehensive database platform providing enterprise-class data management with integrated business intelligence (BI) tools. The SQL Server 2005 database engine provides more secure, reliable storage for both relational and structured data, enabling you to build and manage highly available, performant data applications for use in your business.\n\nThe SQL Server 2005 data engine lies at the core of this enterprise data management solution. Additionally, SQL Server 2005 combines the best in analysis, reporting, integration, and notification. This enables your business to build and deploy cost-effective BI solutions that help your team drive data into every corner of the business through scorecards, dashboards, Web services, and mobile devices.\n\nClose integration with Microsoft Visual Studio, the Microsoft Office System, and a suite of new development tools, including the Business Intelligence Development Studio, sets SQL Server 2005 apart. Whether you are a developer, database administrator, information worker, or decision maker, SQL Server 2005 provides innovative solutions that help you gain more value from your data.
300205
As the Definition says it is a SUBROUTINE (or a procedure) that is executed when the VB Form is Loaded........\n\n\nIn practice all the database connections and the Global Variables are defined in this Sub becuase this is where the processor do bulk of the processing of your application i.e. at the start.\n\nIt is used like\nPrivate Sub Form_Load ()\ndim DBConnection\ndim name AS String\n.\n.\n.\n.\n'Other executions\nEnd Sub
339559
MySQL is a web based SQL database\n\nSQL (Pronounced Sequel) is a Microsoft Product Also a database\n\nAccess is a Microsoft Product that is a database program\n\nSQL refers to the SQL Query Language and is also used to refer to Microsoft SQL\nOracle (Another Product) is also a SQL based database \n\nMySQL is for web databases\n\nMSAccess is generally meant for creating database applications and reporting but is meant for smaller amounts of data.\n\nMSSQL is designed for storing, querying, and manipulating large amounts of data. \n\nOracle is also designed for storing, querying, and manipulating large amounts of data. It's just a different brand.\n\nMany programs utilize different databases (back-ends) for different functionality.
161373
You can get a free version of SQL Server 2005 (the "Express" edition) at the link below.\n\nIt will run fine on Windows XP.
913063
1. You sure can have a PHP, SQL Server, and IIS working together. I currently have that configured on two separate XP machines. The idea is get IIS up and running if it not already. Then install SQL Server and start it. Then follow the instructions I show you in the link provided below. You will need to setup PHP with an account on SQL server or have it use an existing one you created.\n\n2. I know you can have both installed at the same time (again I have this configuration) but I have never tried running both at the same time. I am not sure you would really want to do that. Choose one or the other and go with that just to save yourself troubles later.\n\n3. Java is a full blown programming language. It is compiled into machine code and executes as a program on the computer. JavaScript however is a script or partial language, it is run within the browser on the client-side. So you could potentially have a Java servelet (runs on the server) and JavaScript on a web page that accesses it. JavaScript is a bit limited (it doesn't handle memory like a language, it has access right limitations to the clients computer files, doesn't have much of what a full language has). Don't confuse it with Java which is a fully implemented language and can create executable programs.\n\nJavascript is the one used more widely on web pages. It is used for quick validation, using functions that require no trip to the server for information, and is one of the main technologies behind AJAX. I have provided a couple JavaScript tutorial links below.\n\nHope these answer your questions.
168991
I am assuming you are the one asking the questions.  I have found that the biggest failing database developers have is not using the resources available for code samples. \n\nQ:  Where would you turn for help with creating a stored procedure or a select statement that was erroring out?
175128
I've not done shelling from SQL (we do scheduled jobs via task scheduler), but simply prefixing 'http://' will shell the browser.\n\nHowever, if what you are trying to do is get SQL to do a parameterized call to a web server, I really can't recommend this approach. A web browser needs a user context, and has a fair bit of overhead.\n\nUsing the new SQL 2005, you could write a .NET DLL that sends a WebRequest, and then register the DLL as a .NET stored procedure. Then just call the SP. You won't need a user context, and it won't do end-user style threading, it will run in-process.\n\nOtherwise, keep SQL Server out of the Http request business. It really shouldn't be doing that anyway. That's a middle tier task if I've ever seen it.
1033121
That being a microsoft program u can use a ligter version which i beleive is free too... it's called SQL 2005 Express Edition... if you want something fully robust and not deal with the high cost, I would personally recommend MySQL. I have used it in all my softwares and we currently use it in our main datacenter to handle all our data from our 35 remote offices world wide... it is extremely fast... we handle over a million transactions a day... give it a try.
1088795
Use SQLDMO and SQLDTS both are references for the SQL Server. But they should also work with Oracle. But it's a crazy thing. I just do it on an SQL Server and you get mad by solving all the errors you can get.\n\nHelmut\n\nP.S.: A good source to get a idea about it, download the SQL Samples and look for the Bulk Insert Task