Need To Go Back And Add An ID Column.

Jan 3, 2007

Yes I have a database loaded with information but no _ID column....

Adding the column is easy but how to assign each row incrementing values now - after the fact is my question...


I tried a :


Code:


"SELECT COLUMN " & _
"FROM " & _
"TABLE "



followed by:


Code:


While (NOT RS.EOF)
str_fixCol = "update TABLE " & _
"SET " & _
"CD_ID = " & CDID





but this times out at the server....
Any better ideas?

Measure twice cut once!!!
arggggg...

View 1 Replies


ADVERTISEMENT

Not Getting Back Data From 1 Column

Aug 16, 2013

Here after the Union, the col. WWDTA should have data but its' coming back blanks, but all cols are aligned. why is this?

SELECT
ALL T01.OHORD#, T01.OHSLR#,T01.OHORDT, T01.OHORDD,
T01.OHTTN$, '' as WWDTA
FROM ASTDTA.OEORHDOH T01,
ASTDTA.OETRANOT T02
WHERE T01.OHORD# = T02.OTORD#

[Code] ....

View 2 Replies View Related

How To Bring Back A List Of Duplicates From A Column

Jul 20, 2005

I have a column that has 75 values, 50 are unique/25 are duplicates. Ineed to be able to bring back a list of the duplicates, listing allrows even if more than two have the same value. I need to be able todo this using t-sql.Thanks,Tim

View 5 Replies View Related

Convert Column From NVARCHAR(MAX) To Money And Then Back Again.

Oct 8, 2007



I need to always have a formatting of 999,999,999.00 in a column called PropertyMap9.

PropertyMap9 is always a nvarchar(max)

How do I SET a value using a CONVERT or CAST to accomplish this ?

Why does this give me a syntax error ? The PropertyMap7 set actually works and performs the calculation and sets the new value for that row, however the next line gives an error. I need all 3 columns PropertyMap9, 8, and 7 to always have the above formatting, while still maintaining the nvarchar(max) datatype in the column. HELP!


update PropertyMapValues



set PropertyMap7 = CONVERT(NVARCHAR(MAX),CAST(PropertyMap8 AS money) - (CAST(PropertyMap9 AS money)),1)

set PropertyMap9 = CONVERT(NVARCHAR(MAX),CAST(PropertyMap9 AS money))

END



Msg 102, Level 15, State 1, Procedure UpdatePropertyMap7, Line 59

Incorrect syntax near '='.

View 1 Replies View Related

Passing A Timestamp Datatype Column To A Variable And Back

Aug 10, 2006

After several hours of trying, I trow the towel in the ring and come here to ask a question.

Source system uses a timestamp column in the transaction tables. which is equal to a non-nullable binary(8) datatype (sql 2000 bol).

What I want to do is get the timestamp at the start of the transfer and at the end of the transfer of data. and store these in a controltable

I try to do this in 2 sql execute tasks:

sqltask 1: "select @@DBTS AS SourceTimestamp" and map the resultset to a variable. Here come's the first problem what variable type to take ?

DBNULL works (meaning it doesn't give errors) (BTW: is there a way to put a variable as a watch when debugging sql tasks ?)

INT64 and UINT64 don't work error message that types for column and parameter are different

STRING works

Then I want to store this variable back in a table of a different data source

sqltask2: "insert into controltable values(getdate(), ?)" and make an input parameter that takes the previous timestamp ...

if I took DBNULL as a type for the variable there doesn't seem to be a single parameter type that works ???

if i take STRING as a type for the variable I have to modify the sql to do the explicit conversion from string to binary so I change CAST(? as binary). It doesn't return any error but the value stored in the table is 0x00000000000 and not the actual timestamp.



Any help on this one ? Why are the INT64/Bigint not working here, you can perfectly do a convert(bigint, timestampfield) in sql ?

How came the SQL datatypes, and the variable datatypes, parameter datatypes are so badly alligned to each other (and all seem to use different names) ?

tx for any help

Dirk

View 6 Replies View Related

How To Bring Back The Distinct Values In Single Column From Two Tables

Jul 20, 2005

12.) Now you have two different tables - each with two columns.Table #1Single Column2 rows with a value equal to 1 and 2Table #2Single column2 rows with a value equal to 2 and 4Construct a statement returning in a single column all the valuescontained, but not the common values.This is another question that I got in an interview, I missedit.......Thanks,Tim

View 1 Replies View Related

Having Difficulty Setting Back Up To Back Up File Wihout Datetime Stamp SQL 2K

Apr 24, 2007

Hello,I'm trying to create a simple back up in the SQL Maintenance Plan that willmake a single back up copy of all database every night at 10 pm. I'd likethe previous nights file to be overwritten, so there will be only a singleback up file for each database (tape back up runs every night, so each daysback up will be saved on tape).Every night the maintenance plan makes a back up of all the databases to anew file with a datetime stamp, meaning the previous nights file stillexists. Even when I check "Remove files older than 22 hours" the previousnights file still exists. Is there any way to create a back up file withoutthe date time stamp so it overwrites the previous nights file?Thanks!Rick

View 5 Replies View Related

Mirroring :: Principal Database Get Role Back After Being Back On Line

May 14, 2015

New to Database Mirroring and I have a question about the Principal database server. I have a Database Mirroring setup configured for High-safety with automatic fail over mode using a witness.

When a fail over occurs because of a lost of communication between the principal and mirror, the mirror server takes on the roll of Principal. When communication is returned to the Principal server, at some point does the database that was the previous Principal database automatically go back to being the Principal server?

View 2 Replies View Related

Reporting Services :: Run Two Reports Back To Back Without Page Eject?

Jun 9, 2015

I need to run two reports each of A5 Size to run back to page and print on single A4 paper means in 1st half Sale bill will be printed and in second half Gate Pass Will Be Printed both report will be on same page and size and shape should be maintained. How to do it.

View 4 Replies View Related

How Do I Back-up &> Truncate &> Shrink &> Back-up SQL 2000

Jul 20, 2005

Hello,I am hoping you can help me with the following problem; I need to process the following steps every couple of hours in order to keep our Sql 2000 database a small as possible (the transaction log is 5x bigger than the db).1.back-up the entire database2.truncate the log3.shrink the log4.back-up once again.As you may have determined, I am relatively new to managing a sql server database and while I have found multiple articles online about the topics I need to accomplish, I cannot find any actual examples that explain where I input the coded used to accomplish the above-mentioned steps. I do understand the theory behind the steps I just do not know how to accomplish them!If you know of a well-documented tutorial, please point me in the right direction.Regards.

View 2 Replies View Related

Rolling Back SQL Server 2005 Databases Back To SQL Server 2000

Sep 22, 2006

Does anybody know of a way to rollback SQL Server 2005
databases back to SQL Server 2000? Is there a way of doing it without
resorting to Copy Database Wizard? I love to find a way of attaching a SS 2005 database
to a SS 2000 instance without any issues.



I recently upgraded to SS 2005 and I am very unhappy with the SS 2005 and I
want to rollback to SS 2000, which was a lot more stable. I am having
several major issues that are affecting my whole company's day-to-day
operations and the managers are not happy. Some of the issues include
night time batch running very sluggish for no apparent reason. This is a
biggest problem because it only occurs once or so a week and causes a disturbance
with the daily activities when the night time processing isn€™t completed on
time. The rest of the time, the batch processing runs great, even a little better then on SS 2000. I
don't believe it is a matter of my application needing to be retuned because if
that was the case, then why isn't it running sluggish every night? Also,
it's never the same day that the sluggish behavior occurs. If it was occurring
on the same night, then I would have something to investigate within our
application, but it doesn't. Another issue that I am having involves a
night time job that restores a copy of the production database to the Data
Warehouse server to be used for updating the data warehouse. Again, most
of the time it runs great (~2 1/2 hours), but once or twice a week, it goes
stupid and takes 6 1/2 hours for no apparent reason. Again, it is not happening
the same day either, which could give me something to invesigate. On SS 2000, this same job ran flawlessly. Never I did I run into situation that the
database restoration took that long to run. Even another issue involves a SQL Server Agent Job that was put into suspended
state. What's a suspended state and how can I get it out of suspended
state? I can find no information about suspended state in BOL. I
did a Google and nothing came up. If this suspended state was put
in for security reasons, great, but then tell me how I can remove the suspended
state. I am also not happy with the
fact that I can't get accurate information about the queries that are actively
running at that particular moment. In SS 2000, when I noticed high CPU
usage on the server, I would run the sp_who2 active stored proc and it would
show me all the active thread and how much CPU it was consuming. I would
then find the running threads with the highest CPU numbers and investigate the
query and see if we could improve it. Now in SS 2005, I get in the same
situation and run the sp_who2 stored proc, and there is no smoking gun.
All of the active threads are showing very little CPU usage, which I am very
suspect of. What the heck happen to sp_who2? I looked at some of
the other ways of looking at running processes (i.e... sys.sysprocesses) and
they don't appear to be giving the information that I need.



I am very unhappy and I just want to roll back to SS 2000 and wait a couple of
years before I upgrade to SS 2005.


Dave Brown

View 1 Replies View Related

Integration Services :: Add New Column Based On Existing Column Using Derived Column Task?

Jul 28, 2015

I have a excel file which has a column called "Code" and their values are A,B,C,D,E,F,G,H.  I want to create a new column called "status" based on the values of "Code".

Code:

A
B
C
D
E
F
G
H

If A,C,E,G then "status" = "Active" else if  B,D,F,H then "Status" = "Inactive". I like to do it using "Derived Column".

View 4 Replies View Related

Back-up

Oct 8, 2001

What is the simplist way to back up SQL database?

View 1 Replies View Related

Back To 6.5

Sep 14, 2000

anyone try to convert a 7.0 database back to 6.5? Is there a way to move the data back or does the 6.5 to 7.0 upgrade change field identifiers or anything else prohibiting the move?

Thanks

View 1 Replies View Related

Back Up

Sep 12, 2000

How to back up DTS package?

View 1 Replies View Related

Back Up

Sep 19, 2000

Hi all,

We need to restore a back up of database from one machine to another machine. The sql server's are running separately on two of the machines.

We rebuilt the MASTER database on the machine which needs to be restored as there was a conflict in the LOCALE and SORT ORDER.

We rebuilt the Master using the RebuiltM.exe

After that we successfully restored the database. AS BOL suggessted that MSDB and Model had to be restored, thosee two were also done.

But we are not able to see all LOGINS / USERS that were there in the original database.

Are we missing anything that will show up all the users once we restore database from the dump.

Help.


-Rajamani

View 1 Replies View Related

Back Up

Feb 7, 2007

Hi all,

what do i do in the event that my disk is full during back up? Is there anyway to plan for this ahead of time?

thanks!

View 6 Replies View Related

Back Up

Jun 3, 1999

Please help.
We need back up database on remote SQL Server backup device,
because first one doesn't have space for backup file.
Give mi hint what to do.

Thank you very much,
Alona

View 3 Replies View Related

Back Up

May 18, 2001

hi,

how do we take back up of data from a table to a text file.
write data from table to a text file or excel sheet.

thank u
lak

View 1 Replies View Related

Back Up

Apr 30, 2007

how do i back up my database

View 2 Replies View Related

How To Back Up??????

Feb 19, 2004

Hi all,
I know how to backup database form full back, diffrential backupp. I ' d like to know how to restore database from transaction log file not from backup file.
Thanks fro reading.

View 3 Replies View Related

Back Up

Nov 28, 2006

hi,

whats the best way for me to back up an instance within my sql server 2005?
(all databases within instance)

thanx

View 4 Replies View Related

How To Back Up SQL

Oct 19, 2007

What is the best practice for a SQL back up? We are installing Symantec Backup Exec. Is it really necessary to pay for the SQL backup agent? What does the agent do for you that the regular backups within SQL doesn't give you?

View 9 Replies View Related

Transactional Log Back Up

Feb 7, 2007

Hi,
How do we take Transactional Log Backup using sqlserver 2000? Can we take only transactional log back up?

View 1 Replies View Related

Roll Back

May 14, 2007

I wrote a stored procedure. It work properly.
But I want to catch if any error occurs while executing it. And I want to make roll Back on error .And send the error OUTPUT
How can I roolBack the command below and How can I send the error over OUTPUT parameter?
execute(@cmdS)
Thanks.

View 1 Replies View Related

What Does It Need To Back Up By Differential ?

Jul 26, 2007

As I tested, I found with Transaction logs and Full Backup can support any changing of database.
 
So I doubt that Do I need to back up by diffrential style ?
 
 
Please suggest me.

View 1 Replies View Related

Not Getting Back Rows From SQL

Feb 13, 2008

Hi,
I am trying to connect to a SQL DB and pull data from it. But i never get back any rows. I have run the query, it works fine and i get back rows. But htis does not seem to work. HELP ?
Attaching my code 
TryDim ConnStr As String = System.Configuration.ConfigurationManager.ConnectionStrings("Engineering_Health_SiteConnectionString").ToStringURLConn = New Data.SqlClient.SqlConnection(ConnStr)
URLConn.Open()
 Dim param1 As New Data.SqlClient.SqlParameter("@FG", Data.SqlDbType.NVarChar)
Dim param2 As New Data.SqlClient.SqlParameter("@SS", Data.SqlDbType.NVarChar)
Dim query As String = "Engineering_Health_Site.dbo.usp_GetSiteURL"Dim comm As New Data.SqlClient.SqlCommand(query)
comm.Connection = URLConn
comm.CommandType = Data.CommandType.StoredProcedureparam1.Value = Me.DropDownList1.SelectedValue.Trim
comm.Parameters.Add(param1)param2.Value = Me.DropDownList2.SelectedValue.Trim
comm.Parameters.Add(param2)Dim adap As New Data.SqlClient.SqlDataAdapter(comm)Dim dt As New Data.DataTable
adap.Fill(dt)For Each row As Data.DataRow In dt.Rows
Response.Write(row(1).ToString)
NextCatch ex As Exception
Response.Write(ex.Message)
Finally
URLConn.Close()
End Try

View 4 Replies View Related

I'm About To Go Back To 'Access'... Help Me

Feb 15, 2008

Hello all ASP'ers,  I'm very familiar with .net code and data access as it is what I do for a living. However, what I don't do a lot is make my own web project from scratch. All our DB connections are handled through a DB class that we instansiate and use, quite easy. BTW, we hit an Oracle DB and code in C# in VS 2008 Team Developer.Here's my (simple I hope) dilemma.I'm using VS2008, C#, SQL server database. I put a text box and a button on the front page (of my web page) for users to enter their email address for a newsletter. I created the DB by right-mouse-clicking on my project icon in the Solution Explorer, add new item, then selected SQLServer Database, it and saved it. It now appears in the Solution Explorer. I've added the table and columns I need but for the life of me I cannot connect to it. I've seen TONS of connection string examples but I need help getting the proper syntax for my situationI have not created a user ID or a password for the database. What do I put in for the DataSource and the database?I dragged the database icon into my code and got the local path wher it resides:C:FilesWebProjects2008WbProjApp_DataNews.mdfHere is the most common connection string I see for SQL Server:SqlConnection Conn = new SqlConnection(" + "Data Source=Your server name;" +                      <------ What goes here?"database=Your Database Name;" +                     <------ What goes here?"UID=UserID of the server;" +                               <------ Can I get rid of this?"PWD=password of the server;");                         <------ Can I get rid of this?I've done a different project using an Access DB and have that guy up on the web working great, I just can't get htis one connected and the data a' flowin'.Please help, this is my personal website and I want to use SQL Server but I'm getting frustrated and just might go back to Access, aaaaggghhhhhhh...Once I get past the Conn.Open(); in a try/catch I'll be good. I've got the rest of the data commands in place and ready to go. Here is a link to a visual to help you see what I'm doing, it's just a shot of my solution explorer.  

View 3 Replies View Related

Database Back Up

Mar 27, 2008

Can any body help with sample code to backup (sql server 2005 express)database using VB.net on click of a button?
Thanks

View 2 Replies View Related

Regarding Sql Database Back

Apr 24, 2008

hi can any one guide me how to take database back up from sql server 2005 using visual studio frame work 2008

View 2 Replies View Related

Back Up For SQL Server

Nov 2, 2005

Hi,  For Asp.net project i have used backend as sql server database.My database name is Traveldb.i want to take the backup for this database in SQL Server as a "Filename.sql".  Please tell me the steps to follow to take the backup file as SQL Script File extension.Thanks & Regards,Laxmi

View 1 Replies View Related

Back Up Database

Nov 8, 2005

Hi everyone,
I am working in a company where data is changed daily (IT department of a shopping center) where item prices change everyday, the quantity available in stock vary daily,...What is the scenarios available for the back up on SQL Server 2000 (I am a developer not a database administrator, but I have a task to do which is to make a back up for the critical data) .
could u help me with some links or idea.I was thinking of doing a full back up one time everyweek and daily I will do a differential backup?is that the best solution?Thanks.

View 1 Replies View Related

How To Back Up SQLExpress?

Nov 28, 2005

Ok it seems to me that if you use the ms recommended code to connect your apps using the app_data folder etc, that the dbs never show up in the SQLExpress manager.So I can't back them up like I can databases I connect to SQLExpress the 'old fashioned way'. Only 2 out of 6 dbs are visible in SQLExpress manager.What is the proper way to do this?Thanks,Jamey

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved