I'm studying to retake the SQL Admin exam (70-228) and wanted to familiarise myself with the command line options for installing SQL Server 2000. The exam mentioned the use of a -m flag with setupsql.exe, but I can't seem to find out what this does.
The BOL only refer to the -s -f1 and start/wait options. I even tried running the setupsql command with invalid parameters to get prompt of valid options but it also just refered to those flags.
With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
SQL Server Integration Services can read XML files, that’s known by every BI developer. (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.)
But how far can you go? When does the XML Source component become …
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables.
Make a table:
Update a specific column given a specific row using the UPDATE statement:
Remove a set of values using the DELETE s…