Is there a system table in Microsoft SQL Server 6.5 which lists all the Reserved Words? I am writing an app which will allow the user to define the column names of a view. I want to check to make sure that they are not trying to name a column with a reserved word like 'SELECT' or 'TABLE'. As far as I can tell, there is no table which lists the reserved words. I may have to create my own reference table.
Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
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 …
In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.