Hi Experts,
I have the following table:
rowID country destination bkgDateStart bkgDateEnd pickUpStart pickUpEnd carCode band supplier
1 ESP IBZ 01/12/2004 31/12/2005 01/01/2005 04/...
Hi Guru:
I work with Oracle but is completedly new to SQL Server. I was required to create database and restore from a dump file (I would think that it likes oracle's import). The dump file...
Hello Experts,
I have table which has been updated with the newly added product information, all I wanted to do now is to copy all the data from this table and export into the table on the ...
Hello,
I am tring to create a new instance of SQL SERVER through Command Prompt,
the utility called "osql" create new database but not the new instance.
I need a command through ...
Hi Experts,
I have a table in SQL 2005 with 5 existing primary keys, to add in some extra fuinctionality i need to add a sixth primary key to the table.
The only problem is that every t...
hi i get this error when trying to load SQL Server Management Studio Express. i used CTP version previously. i uninstalled the CTP before installing the new one.
both also gave me this erro...
My sql script executes an mdx query as dynamic sql within a cursor. It works beautifully when I execute it in a query analyzer window. It also works when I run it within a sproc on the dev s...
How do I put a ' in a string in sql?
is it something like /' or '' lile in vba.
maybe someone knows the character code?
Hi ,
I would like to pass one table name (ex: sales ) through procedure. In side the procedure it has to generate create table script for that particular table. Any one knows any stored ...
Hello,
I just got done building some reports on my report server (local workstation, windows xp) that runs a report from a database hosted on a server 2003 box with SQL 2000 running on it.
...
I recently installed SQL Server 2005. I see by going into SS 05 that I have an sa login. I don't remember supplying or being asked for a password for sa at installation. I can open up the sa...
I am trying to create a SQL Server database. In one database I have a table named "book" with columns ISBN, Title, Author, Condition and Book_ID. Book ID should basically be a composite of ISB...
Dear Experts,
I'm trying to create a stored procedure to update a datetime field from 2 input parameters. (The reason it's like this is that I want to enter the start date/time simular to s...
Hello,
I have a query and I want to retrieve the last 10 rows instead of the first 10 rows.
I know that the typical way is to just switch the order that you sort on.
But, I need the b...
I am trying to convert a date (in milliseconds) to Date Time format from 1/1/1970
I am already able to convert the current date/time into milliseconds using this code (snippet):
But I ...
I have a stored procedure on SQL 2000 that builds a temp table, and it also executes another stored procedure which returns a result set. I need to populate 3 of the fields in that temp table ...
I made a Conversion Program in vb6 (access to sql) with SQL having no Identitys in the table So i can preserve the RowID and then hoping after the converision to alter the column to put the ...
When running a query after attaching a database, I get the following error:
The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space....
When I try to do this, I get an invalid syntax near ',' error. Is this not possible? I am just trying to get a count of how many insurance claims each individual member(memid) has for each pr...
I have table A with two columns
Location_ ID, ITEM_ID
1 location many items (min 1 , max 5 items per location)
In my report I want to concat all item_id delimited by ',' by each loca...
I have a table named Table1 contains records like the following,
field name data type length
------------ ----------- --------
field1 nv...
All,
I am trying to access an MSQL server through Enterprise Manager. I am trying to update a stored procedure. When I try and save the storeds procedure I get the error "Error 7416: Access...
Hi there,
We are running MOM and having problems with the database. The log file reached 86GB and filled up the whole of the D Drive it was living on.
I wanted to take a backup of the databa...
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...
Yes, I've seen other asking this to, but none I looked up seemed the resolution to my problem :(
this is the command:
C:\Documents and Settings\sternbeh>bcp NorthwindReportData..NewData ...
