I have a issue with some SQL that I can\'t wrap my head around a solution. Right now the query I am running basically i开发者_运维知识库s:
I\'m very new at connecting to databases so I apologise if I\'m not familiar with some of the terminology.
I want to migrate a Btrieve Database to Microsoft SQL Server 2008 R2. I already have done the step of migration to Pervasive PSQL 10 Workstation (x86), which offers an ODBC / OLE DB driver. (It seems
I am retrieving data from my database using a TableAdapter. I was wondering if there is some way I can tell (or be informed) that the data has changed and I therefore need to do another Fill? That way
I havestumper that\'s been causing intermittent error at a client which has been increasing in frequency.
I wish to replace some text within a field, so i have the following statement: UPDATE INVENTORY SET INV_DESCRIPTION = REPLACE(INV_DESCRIPTION, \'5 ml\', \'5ml (1/6oz)\')
I have tried running the following UPDATE on a table with about 25k rows and its been running for over 24hours and it has not compl开发者_运维技巧eted.I only need to run this UPDATE once so time is no
I\'ve been Googling for half an hour now, and can\'t seem to find the right place... How do I add a user and grant that user access to all tables in the database? Found some GRANT snippets, but there
I am having the hardest time connecting to this pervasive server for this asp.net application I\'m working on.Right now, I am able to access and view the entire database using my connection string in
I\'m creating an asp.net application that gather开发者_运维知识库s information from a pervasive database. I\'m having a hard time getting the connection to work properly though.From my computer I am a
加载中,请稍侯......