I\'m very new at connecting to databases so I apologise if I\'m not familiar with some of the terminology.
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 using ODBC to read data from a pervasive PSQL database a开发者_运维问答nd in some scenarios, the date column can contain 00/00/0000 date. I don\'t really care about invalid dates so is there some
I have an asp.net, c# application using MSSQL 2008 server. At some point, i also want to insert some d开发者_运维技巧ata into a pervasive v10 database. Was looking for the pervasive data provider from
I have a database with a lot a currencies and each row has a currency, d开发者_运维问答atestamp and the exchange rate. What I would like to have is a query that gets me the latest exchange rate for al
Using Pervasive SQL, I have a result set: Tp_NoNameStateEff_DateActualBilled 1006ABCTN2006-07-01.1.5 1006ABCTN2008-02-15.27.6
I\'m using Pervasive SQL.I have the following UNION of mulitple SQL statements.Is there a way to clean this up, es开发者_JAVA技巧pecially the Pay Date an the Loc No fields that are selected in each st
Is it possible to const开发者_StackOverflowruct a query so that I can find out what tables have a particular column? Then if it has the column query that table for an ID number? Is this possible?Sure,
I have 2 totally separate databases - one MSSQL and one Pervasive.Due to the way our product data is stored in the Pervasive database, you cannot easily run a query to get a products\'s information an
加载中,请稍侯......