Hello,
We are new to MS SQL Server Management Studio and need to export a table to a csv formatted file. We figure there must be a wizard or some function to do this but have not found it....
Hello Experts, I have a varchar column that contains both strings and integers stored as strings (see sample below). I would like to select the ones that can be easily converted to INT withou...
We are developing an Intranet for our organization and are using SQL 7.0 as the database for it. We have a content table with a field to hold the text for the various html pages. Can somebod...
I get the following error:
Msg 1087, Level 15, State 2, Line 16
Must declare the table variable "@table_name".
In the following code:
=============================================
DECLA...
hell there,
i am having problem viewing reporting service reports i created.i get this error.how do i create a user with a trusted SQL Server connection.
the error i get is.but in my stu...
Hi all experts,
I am a new guy which is now working with SQL Server. I try the following SQL Statement
INSERT INTO TRACKLOC
(DATETIME)
VALUES ('18-11-254...
I'm apparently confused about the way SQL works with a LEFT OUTER JOIN. Below is a sample statement I am using for summing InvAmt, PmtAmt, CreditMemoAmt. Payments and credits are based on a ...
Alter table tbl_name alter column [col_name] int IDENTITY (1,1) NOT NULL
gives me Server: Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'IDENTITY'.
col_nam...
We have a few servers running ms sql 2000 and one server that runs ms sql 2005
I have created multiple linked servers from one ms sql2000 server to another and they have worked fine
I am...
Hi all, i keep getting this error message when I try to add a new item into my database
Cannot insert explicit value for identity column in table 'MenuItem' when IDENTITY_INSERT is set to O...
Hi,
I'm quite urgently needing an SQL statement which removes the primary key constraint from a column while leaving the data intact.
Can't quite make heads or tails of the MSSQL syntax ...
I have been working on a local copy of a db (localDB) and have made a lot of changes to some tables and added some as well. The live db (liveDB) is on a shared host and is still active. So the...
I have SQL Server Std. running on a Win 2003 server. Everything has been fine except for the past few days the Default Instance/Service does not launch anymore. I have uninstalled and reinstal...
Hi,
I have two tables within a SQL Server database; the first database has a column which is an identifier and another column which lists one of more email identifers for a second table, e....
I keep getting this "warning" when I run certain scripts:
Warning: Null value is eliminated by an aggregate or other SET operation.
It's not a "fatal" error, so the script still runs,...
Windows Server 2003 Enterprise Edition
RAM = 16 GB
SQL 2000 Enterprise Edition
AWE is enabled with Min and Max set and /PAE Switch only is used in boot.ini file .The OS can see all 16 GB ...
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/...
SQL Server installed for testing on WinXP Home SP2 and IE7.
Workstation running WinXP Pro SP2 with IE7 and Office 2003 SP2 produced this error when trying to run the Upsizing Utility in Acc...
I have created a database which shows the administrator as the dbo owner. I have created a user which I want to be the dbo owner. How can I delete the default dbo owner and create my own
I have a Windows SBS 2003 Server, Service Pack 2, 2gb ram and 200gb disk.
I have installed MS SQL Server 2000 with its latest Service Pack 4 and left in tact its standard "MSSQL Desktop Eng...
Hi EE,
I have the following query in sql although Im not confident with multiple inner joins.
Can you please help with why this fails.
As you can see I have five tables in the query, outl...
How can I create a while loop in SQL and grab a certain field from my table and work with each record.
Example,
While @Var > 1
BEGIN
Select @FieldValue = somefield from mytable for c...
I accidentally deleted the LDF file. Now I can't access the database. What can I do? Can I generate the LDF from the MDF? Also, the MDF and LDF continous to grow bigger and bigger. How can I c...
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...
Hello,
I have an issue and I cant figure it out. I have a date column that shows as 8/30/2002 in MSSQL. When I export it to a txt file it shows as 2002-08-30 00:00:00. I need the date ...
