I want开发者_JS百科 to know the growth type (% or MB) for database files on SQL server 2000. I Used sys.database_files files on Microsoft SQL Server 2005 to get this information. I tried using sysfile
Please help me to find a solution. I have data in table like IDCode 1123,456,789,12 2456,073 369,76,56 I need to list of code in row
I have a web based program which chooses some records from a database using a checkboxlist. (my check box list sends parameters to a stored procedure and I use the result of stored procedure).
i have some experience with MySQL but none with SQL Server, i have a computer who host a database (SQL Server 2000) and i have local access to it. The think is that one column of the table NomAntigued
I have a table where the data are like Data开发者_开发知识库 a b c I need to write a SQL query to bring the following output
What I want to do is something like this DECLARE @operator nvarchar; SET @operator = \'AND\' SELECT * FROM MyTable
I know I can get a list of tables from a given database with the following query: select * from information_schema.tables
I\'ve got a query I\'m working on and I want to increment one of the fields and restart the counter when a key valu开发者_如何学JAVAe is different.
My sql statement SELECT * FROM mytable WHERE (CONTAINS(keyword,\' \"green\" \')) How do I list the top matched result like this
Not being a SQL expert, and also only being semi-competent in CTE, how can I code this statement use the resultset from the following subquery within the main query, as our SQL Server is 2000.
加载中,请稍侯......