Here\'s a question for all those SQL SERVER 2000 experts: I have only 1 table... I can already find if any of the values in a certain field, also appears in another record.
I am using ASP Classic and SQL Server 2000 to create dynamic websites. I am a bit confused about when to use a recordset object and when to use a command object when querying the database.
I currently have a code table containing a list of types (Type_ID, Description), but they are saved in another table as ID;;ID;;ID...etc
I have two tables that I want to join into one table and use a TypeID to differentiate them. Let\'s say the types are A and B. The Tables are A_Level and B_Level
I have very simple query that calls a UDF which spl开发者_如何学运维its a field by comma. The query is
I\'m looking at an execution plan from a troublesome query. I can see that 45% of the plan is taken up doing a table scan on a table with seven (7) rows of data.
Please consider the following scripts. Create Table: IF OBJECT_ID(\'Colortable\') IS NOT NULL DROP TABLE ColorTable
I have a query that queries a linked SQL server 2008 database and joins data from a table in that database to a table in SQL server 2000.It was working find until one of the columns in the SQL server
I need to set up this question a moment. Let\'s say you\'ve created a database called ParameterTesting and created a table and populated it like so:
I am hoping that someone has attempted this before and I can get some advice before I go any further.
加载中,请稍侯......