Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- How do I... Reseed a SQL Server identity column?
- Microsoft SQL Server's identity column generates sequential values for new records using a seed value. Seeding and reseeding an identity column is easy and relatively safe, if you do it correctly. Susan Sales Harkins shows you how it works. by Susan Harkins
- Tags: Microsoft SQL Server, Server, Column, Value, Identity, Table, Identity Column, Seed Value, Term Seed, TRUNCATE TABLE, Susan Sales Harkins, Databases, Enterprise Software, Software, Data Management, Susan Harkins
- Blog posts 2008-07-15
Additional Resources
- SQL Indexes/table resetting
- I have a SQL Server 2000 DB that has numerous tables that I would like to reset back to how they would have been just after creation( i.e. blank fields throughout) I'd like a number 1 to appear in the first index column when a new record is added. ...
- Tags: colin-mackenzie@..., programming, SQL
- Q&A 2005-07-25
- Update data from one table to another table
- Greetings:I have two sql 2000 databases, one on one server and one on another server. After bringing in the data from one table, I would like to update the other database table with the changed data.Quick and dirtyTruncate Table OutOfDateInsert OutOfDate Select * From UpToDate
- Tags: Storage, Databases, greg_gordon@...
- Discussion threads 2007-07-23
- How can I truncate data in a MS Access Field?
- Using Google, I found the following update query posted by Tony Hopkinson in Mar 2005:update mytable set ssn = right$(ssn,4)I tried this and it works for all MS Access databases that I have except for one. In that database, I get the following error when I run the query:Compile...
- Tags: Databases, Storage, joe.a.grabman@..., database, Microsoft Access, Microsoft Corp.
- Discussion threads 2007-04-16
- Ease Access database maintenance with the Alter Table command
- do it in table designWhile not just alter the table in table design. Seems quicker then typing SQL code in a query.You have to be careful with some gui table designersInstead of executing a number of alter table commands they create a temporary table with the new structure, construct an...
- Tags: ALTER TABLE, database, hardware, Microsoft Access, solson@..., SQL, table design
- Discussion threads 2006-03-16
- Round and truncate dates in Oracle
- watch outAlthough truncing a date is very common, I didn't know about the format parameter.Thanks.trunc(sysdate,'y') sure beats to_date('01-01-'||to_char(sysdate,'yyyy'),'dd-mm-yyyy')However while playing around I noticed something I didn't expect, using the 'd' format.I expected the output of trunc(sysdate,'d') to basically be the same as truncsysdate.Because truncing to a day would in my...
- Tags: bellyware, SysDate, Oracle Corp.
- Discussion threads 2007-07-25
- How to continuously append live table to table?
- I have a situation here:every month there will be a table (with 3200+- entries) that should be appended to a Year-to-Date table.I appended the second month's live table to the accumulative table, but don't know how to do it for the third month, other than deleting the live table temporarily...
- Tags: shichen1979@...
- Discussion threads 2007-05-31
- Copying a table using VB
- What is the easiest way to copy data and structure from 1 table to another table within the same database? it doesn't matter if table b is overwritten, I need a way to copy table A to table B
- Tags: Microsoft development tools, Programming languages, andrew.s.fitchett@..., Microsoft Visual Basic
- Discussion threads 2007-08-27
- Transfer data from one table to another in Access
- I need help on a topic in Access. I have an existing table with people's information. Then I have another table of people's information which is not up to date. For every person in the old table, I would like to check it in the new table and if present...
- Tags: o.kulahcioglu@..., Microsoft Access
- Discussion threads 2007-07-17
- MIL - Read Table (zip)
- MIL - Read Table is a powerful automation tool that can read table from SAP. Using this application, you can instantly view and search table and data from SAP. MIL - Read Table is designed for high flexibility, numerous options enable you to read SAP table that best suits your...
- Tags: SAP AG, Microsoft Windows, .Net, Productivity, Operating Systems, Software, Software Development, Software/Web Development
- Software downloads 2008-02-05
- salvage an Outlook 2000 pst file?
- My Outlook 2000 pst file is about 2.1 GB. A little over the 2 GB limit. Outlook crashes before I can delete anything to make it smaller.I've tried the PST truncate and PST repair tools from Microsoft but they seem not to help.Are any of the PST repair programs ($50-225)...
- Tags: Microsoft Office, E-mail clients, Groupware, algisk, PST, Microsoft Outlook, Microsoft Outlook 2000
- Discussion threads 2007-05-27
- Never ending UPDATE
- I ran this query in the Query Analyzer for 6 hours and then gave up. 29 million recs at 24GB.Update ASet Acctid = B.AcctidFrom BWhere Substring(VendId,5,4) = B.VendId4I did a link from Access and Access took 4 Hrs but it worked for 5,3.Any suggestions will help me understand the SQL...
- Tags: Databases, JBNY, Substring
- Discussion threads 2007-10-24
- Compare Sheets (zip)
- Compare two tables created with MS Excel and create result table according to given criteria. Depending on compare function result table may include: lines from first table that have match in second table, lines from first table that haven't match in second table, lines from both tables that haven't match...
- Tags: Table, Ventsislav Alexandriyski, Microsoft Excel, Microsoft Office, Office Suites, Software
- Software downloads 2005-11-28
- Populate Info from table to access form
- I have a form that has SSN / Name / DOB / Servicing office employees table. Then I have the input table with SSN and other fields input table. On the form I have the SSN fields linked and then I call the SSN field on the form...
- Tags: SSN
- Q&A 2005-09-12
- CRYSTAL REPORT EXPORT TO TEXT FILE SPACE PROBLEM
- Hi,I'm using Crystal Report version 9. When I use crystal report exports the data into text file, Crystal report will truncate the last few columns if the fields doesn’t contain data. That means crystal report can't generate a fixed length record if last columns fields is blank.Anyone know how...
- Tags: dhui168@..., Crystal Reports
- Discussion threads 2007-08-15
- Can we clone a table structure to temp table in SQL server
- Can we clone a table structure to temp-table in SQL server stored procedure?If yes, how should we declare the temp table and the command the clone the table structure?or can provide us a sample codes on the above solution.ThanksAnnoyingly simpleselect * into #temptable from Tableif you only want the structureSelect...
- Tags: ysgoh3@..., Microsoft SQL Server, server
- Discussion threads 2007-05-09
- ACCESS 2000 - TEXT/NUMERICS
- I am making a list ncorporating letters and figures such as:N1201PN20EGN249AUN41135N42NAN6391CN642XLI need it to look likeN20EGN42NAN249AUN642XLN1201PN6391CN41135Ant ideas how this can be doneThank youWell I can't see any logic to the orderAdd another column of type integer. Number the items in the order you want them to come out and sort...
- Tags: mickparsons4428@..., Microsoft Access, off-topic, security
- Discussion threads 2007-02-26
- Compare records in 2 tables and move data from one table to the other
- I have two tables with 3 columns in common: FirstName, LastName, Department. Table A Access table has additional columns (RecordID, Address, Phone, etc. This table is missing data in the some of the records in the Department field.Table B an Excel spreadsheet is missing no data in any...
- Tags: Microsoft Office, Table
- Discussion threads 2005-08-11
- Access Hacks: Create Access Tables From Outside Access
- One has an Excel solution that needs to populate an Access table. The table will be a new table in the database. One might think the table needs to exist before one can populate it via ADO or some other means, so one manually creates the table and then goes...
- Tags: Microsoft Access, Table, Microsoft Office, Microsoft Excel, Databases, Office Suites, Software, Enterprise Software, Data Management
- Book chapters 2005-04-14
- copy table from dataset
- I need to copy table from a dataset then return saved copy into the original table.dim cpytbl as new datatablecpytbl = ds.table("name").copyentr processds.table.("name") = cpytbl this statement give an error "Property 'Item' is 'ReadOnly' "can you helpSeems to be a fundamental error hereWhy are you trying to do this?I can...
- Tags: sahaah@...
- Discussion threads 2007-02-25
- << Previous
- page 1 of 1
- Next >>
