I need to copy a table (the structure, not the content) within an SQL SERVER 2000 DB (only the names will differ). Is there a kind of "copy table" stored procedure or so ?
Thank for help
I am working on a report that pulls data from a stored procedure. The application prompts the user for parameters and then passes them into the stored procedure so the result set can be tailo...
I have a SQL 2000 server and a database that I want to drop.
A drop command returns "Cannot drop the database 'MyDB' becuase it is currently in use.
I tracked down the process stopping t...
OK,
DECLARE @ident int
DECLARE @docpart varchar(60)
set @ident = @@Identity
set @docpart = @Ident+'_'+@DocName
print @docpart
I'm trying to create a string, set to docpart for u...
I received the subject error when executing a sproc. The thing is when I test the query, it runs ok, but it throws the error when running a SqlDataReader in the program. There are no declared ...
I'm creating a pair of temp tables to eventually use in a stored procedure that outputs a single recordset. The code at the end of my post is from the first of those two temp tables. I began ...
Hi
Could anyone please tell me what this error means. It has been appearing in the Sql server app log for last month and i have no clue what it is. The Sql admin has reported that backup...
Hello.
Using the solutions found on EE, I've created a stored proc that takes each row of a fixed width text file and bulk inserts it as a single string in a row in a temp table. The proc the...
I need to count the number of rows with todays date. The column is datetime type.
I used this query
SELECT COUNT(*) FROM tblreport WHERE AccountNumber = '00001' AND FileDate = CONVERT(dat...
Is there a function to get month name using integer value 1 to 12 in MS SQL?
Eg. 1 return January, 2 return February, 3 return March so on ...
This is just one part of a very long SQL Statement, but I have isolated the error to this convert function. I have it in the SQL twice and the error mentioned above happens twice when trying ...
I am building a Windows Service with a Filewatcher which will move some files to different locations when dropped in a particular folder. Then, using the Microsoft DTS Object Library, it runs ...
I can see the concept has been asked before re: left outer joins, but I just can't get it connected in my brain. I'll try to strike a balance between the technical table structures and describ...
Hello,
Our SQL Server 2000 databases are hosted at our ISP. When we created them I downloaded the trial version of 2000 to obtain the 2000 Enterprise Manager. I recently downloaded the ev...
=IIf(Fields!New_Old_CC.Value = 1, SUM(Fields!PDC.Value),0)
How can I check to make sure New_Old_CC is not null or maybe better yet IsNumber or both before evaluating if it is 1 or 0? I kno...
I'm running clustered SQL 2000 SP3 with Jet 4.0 SP8 and ADO 2.8
Within a stored procedure that is scheduled through SQL Agent to run several times per day, the following query runs:
sele...
Hi,
We have a server with sql 2000 installed on it. The server is installed in mixed mode. The only thing we have forgotten to document is the sa - password. Is there anyway to retrieve th...
Hi,
My web form contains a textbox where users need to input date (dd/mm/yy), I am using a parameterized stored procedure to update my SQL DB table, but I am facing a problem with the date...
HI,
I have a default install of SQLEXPRESS installed on my worstation. The instance of course is named localhost\SQLEXPRESS. Is there a way to change the instance name to just "localhost"?
...
Hi
How to get the column header for the export file using BCP
I tried with the follwoing :
CREATE VIEW VW_INV_CO_APAC_EXTRACTION
AS
SELECT 'i_invenory_id' as i_invenory_id,
...
Hi All,
I have a table called [b]Table1[/b].
I have a (nvarchar) field called [b]ProductID[/b]. The records in this field is numeric. The length of each record in this field is different. ...
Good Day
Experts:
I am getting this error "SQL Server blocked access to procedure 'sys.sp_OACreate of component 'Ole Automation Procedures". Using a db that I created here, I have no pr...
I've imported a CSV file into my SQL server where it sits a table. All the datatypes are VARCHAR. There is 1 field that I would like to convert from VARCHAR ->>NUMERIC with 2 decimal places; ...
hi,
how do i go about in including an if condition in my select statement?
i would like something like the one below:
select iif(install_date = 'Jan 1 1990',"",install_date) from devi...
I have a SQL table, and I am using T-SQL. I have one table with some null values in one of the columns. I want to replace the null values with zeros. I am using this query:
Use Energy_Db
U...
