Home » Category » Database

Microsoft SQL Server

382,152 Questions...

• Locking Problem

• I have a table [Table1] say with fields Name Char(10), Age numeric (2); and say I've some data as given belowTable1=====Name Age--Sunil 20Rocky 23then I issued command as given belowBegin TransactionUpdate table1 set age=27 where name='Sunil'but I've not either commited it or...
• Sat, 31 Jul 2010 21:10:00 GMT | 919 bytes | Answers (2)

• Dictionarry order question

• I have an installed sql server 2000 language English with server collationset to SQL_Latin1_General_CP1_CI_AS on a W2k server box. There are severalapplications running in production using that machine and those settings.Now the company is getting a new program that has as the requirement for it...
• Sat, 31 Jul 2010 22:10:00 GMT | 1,320 bytes | Answers (1)

• The "Start" triangle in the VSA IDE.

• I drag a Script Task to the Control Flow Design surface, double-click it, select the Script tab, and finally Design Script.. I note that the VSA IDE has a green triangle (“Start”) but I don’t know if it has any use at that point. (I usually just save my script, close the script, and then run it ...
• Sat, 31 Jul 2010 19:10:00 GMT | 849 bytes | Answers (1)

• Import/Export Wizard SQL SERVER 2005

• Hi I am using the Import/Export Wizard from SQL Server Management Studio and have incorrectly exported the results of an SQL Select query to the same database that I was exporting from. However I cannot find the data anywhere after the export completes so I can delete it. Any idea where it might...
• Sat, 31 Jul 2010 09:10:00 GMT | 413 bytes | Answers (2)

• Time functions

• I'm having a bit of trouble with a specific report . Whats happening is I am pulling the times stored as as string in my database and converting them to a time but the difficulty is that there seems to be no functions in Cystral reports version 9 that deal with time comparisons effectively. Her...
• Sat, 31 Jul 2010 15:10:00 GMT | 691 bytes | Answers (1)

Oracle

291,715 Questions...

• how to change Trace File Diretories in 10g dbca?

• Hi,In 9i dbca/Initialization Parameters/File Locatoins, we can change Trace File Directories (bdump/cdump/udump). 10g dbca doesn't have the File Locations tab, how do I change the directories in 10g dbca?Thanks,Xiaolin...
• Sat, 31 Jul 2010 10:10:00 GMT | 243 bytes | Answers (1)

• password for starting database

• I downloaded Oracle 8i personal edition for Win98.1.But when I tried to start database from start programm menu , it asks for the password. I don't know the password, where can I get it ?I alos installed personal oracle 7 for windows 95 on the same computer.2.When I click database configura...
• Sat, 31 Jul 2010 10:10:00 GMT | 373 bytes | Answers (2)

• Integrating some part of db triggers to a db package..

• Hi,I have some db triggers whose format are like that:Trigger Afor each rowafter insert on <table_name>......begin <initialisation of variables> <common_code such as : select statements , conditional statements (if..elsif..endif)> ........... .......... <uncommon pl_sql code regardin...
• Sat, 31 Jul 2010 13:10:00 GMT | 1,361 bytes | Answers (2)

• migrate database

• hiWe are planning to migrate our 10g database from windows to sun solaris platform.can anyone guide me the step i should follow.1. will copying of my datafiles from one system to other will do.2. or i have to export entire database and import in other machine.If yes then what steps have to be co...
• Sat, 31 Jul 2010 16:10:00 GMT | 419 bytes | Answers (3)

• How to Pass Parameter to Discoverer Report from Forms

• I am calling Discoverer reports from Oracle Forms6i through host command, but cant able to pass the parameter, can anybody help me solve this problem....
• Sun, 01 Aug 2010 00:10:00 GMT | 150 bytes | Answers (2)

Microsoft Access

207,255 Questions...

• Customising headers

• Ok, I realise this might be an easy one, if so can youplease help out a novice Access user?I'm trying to create a header in a report that lets theuser know which date period they've selected.thanks very muchgreg...
• Sat, 31 Jul 2010 14:09:00 GMT | 255 bytes | Answers (1)

• Using VB to export an Access table to Excel with criteria

• Hello,Is there a way to add criteria to the VB code exporting an Access Table toExcel? I am using a variation of the sample below but would like to exporta subset of MyTable to one spreadsheet and a different subset of MyTable toanother spreadsheet from within the code so that I do not need to g...
• Sat, 31 Jul 2010 06:09:00 GMT | 1,271 bytes

• invoices for fitness club

• Hi i'm making a database for a small fitness club. I have all the membersrecorded and all the payment methods recorded and the payments. I have alittle problem though.How is the best way to make a clear payment form that shows a balance of howmuch owing and shows all previous payments.The di...
• Sat, 31 Jul 2010 19:09:00 GMT | 803 bytes

• Combo Box Problem

• I have a table (tblPhone) with text fields FULL, LAST, PHONE,I also have a combo box (cmboFull) .The row source for cmboFull is SELECT DISTINCT [FULL] FROM tblPhone;Here's the code for the combo boxPrivate Sub cmboFull_AfterUpdate()' Find the record that matches the control.Dim rs As O...
• Sat, 31 Jul 2010 13:09:00 GMT | 989 bytes | Answers (3)

• print preview on a Form

• I would like to put a report on a form the same way that you put asubform on a form. Basiclly I would like to embed the print preview ina form. Is there a control that does this. I'm using Access97 Thanks...
• Sat, 31 Jul 2010 12:09:00 GMT | 224 bytes | Answers (3)

Database & Application Miscellaneous

158,237 Questions...

• where is sp_primarykey?

• I have a DB that creates a table the defines the primary key thusEXEC sp_primarykey 'blah', blahuidthen does the foreignsEXEC sp_foreignkey 'blah2', '.field', uidI can't find the Procedures to transfer them. going from an ASE to a ASAwhere are the procedures?Th...
• Sat, 31 Jul 2010 11:09:00 GMT | 362 bytes | Answers (9)

• [Info-ingres] Re: Info-ingres digest, Vol 1 #170 - 11 msgs

• I'm quite sure that it is not. The only version supported on Opteron is 2.6on Linux. Perhaps Intel Solaris would run on Opteron, but that wouldn't betoo smart. Also R3 AND 2.6 are not GA on that platform either, so I wouldthink it likely that there are no plans for solaris/opteron supp...
• Sat, 31 Jul 2010 19:09:00 GMT | 1,123 bytes

• Get data by Web Services

• Hi.I need some advice about receiving data by Web Services.I create web-service on ASA 9.0.2. It have such topology:1) User connect to the web-service root and load initial html.2) Html load data from server via Microsoft.XMLDOM object (from url ofXML-type web-service ASA).3) Now I want push bac...
• Sat, 31 Jul 2010 14:09:00 GMT | 733 bytes | Answers (1)

• column limit

• Hi,I'm trying to create a table with 20,000 columns of type int2, but Ikeep getting the error message that the limit is 1600. According tothis messageit can be increased, but only up to about 6400. Can anyone tell mehow to get 20,000 columns?Thanks,IBIsaac Ben Jeppsen(end of broadcast)TIP 3...
• Sat, 31 Jul 2010 14:09:00 GMT | 404 bytes

• is there a way to open SQL Server unicode data ?

• I have a SQL Server 2000 table with fields of type nvarchar, and when Iattempt to open those tables, I get "Error: bad field type"Is there any way to resolve this ?Jeff...
• Sat, 31 Jul 2010 21:09:00 GMT | 188 bytes | Answers (4)

MySQL

62,276 Questions...

• bk commit into 4.1 tree (jimw:1.2315) BUG#11311

• Below is the list of changes that have just been committed into a local4.1 repository of jimw. When jimw does a push these changes willbe propagated to the main repository and, within 24 hours after thepush, to the public repository.For information on how to access the public repositoryseeChange...
• Sat, 31 Jul 2010 18:10:00 GMT | 3,765 bytes

• bk commit into 5.0 tree (reggie:1.1878)

• Below is the list of changes that have just been committed into a local5.0 repository of reggie. When reggie does a push these changes willbe propagated to the main repository and, within 24 hours after thepush, to the public repository.For information on how to access the public repositoryseeCh...
• Sat, 31 Jul 2010 22:10:00 GMT | 5,051 bytes

• Trouble compiling 5.0.4-beta with openssl

• Hi. My attempts to compile mysql-5.0.4-beta on Solaris 9 (Sparc) failwhen I run make with the following:if gcc -DMYSQL_INSTANCE_MANAGER -DMYSQL_SERVER -I. -I. -I../..-I../../include -I../../include -O3 -DDBUG_OFF -Wimplicit -Wreturn-type-Wswitch -Wtrigraphs -Wcomment -W -Wchar-subscripts -Wforma...
• Sat, 31 Jul 2010 09:10:00 GMT | 3,911 bytes

• can I be your friend?

• My name is Julie This whole semester I felt like I want to do something I've never done before.. idea came to meto have my videos I made with my old boyfriend online ;p. My girlfriends want to join me to on my website. -) Verify your age and connect to my webcam today -)Come check website...
• Sat, 31 Jul 2010 19:10:00 GMT | 816 bytes

• Error 2003: Cannot connect to mySQL server on localhost <10061>

• This may shed some light on my issue.1.When I delete ib_logfile1 since nothing is in it and restart mycomputer below is what I get in my .err log. A new ib_logfile1 iscreated with nothing in it.051130 12:04:12 InnoDB: Log file .\ib_logfile1 did not exist: new tobe created051130 12:04:12 Can'...
• Sat, 31 Jul 2010 18:10:00 GMT | 5,903 bytes