Beside its an opensource and supported by community, what's the fundamental
differences between PostgreSQL and those high-price commercial database (and
some are bloated such as Oracle) from software giant such as Microsoft SQL
Server, Oracle, and Sybase?
Is PostgreSQL reliable enough to be used for high-end commercial
application? Thanks
Trying to work on INNER and OUTER JOIN. Can someone help me to write to SQL statements.
Thanks
Sam
Consider the following schema:
suppliers(sid: integer, sname: string, address: string)
parts(pid: integer, pname: string, color: string)
catalog(sid: integer, pid: integer, cost: real)
Write the following queries in SQL:
1. Find the pname of parts for which there is some supplier.
2. Find the snames of suppliers who supply every part.
3. Find the snames of suppliers who supply every red part.
4. Find the pnames of parts supplied by Acme Widget Suppliers and no one else.
5. Find the sids of suppliers who charge more for some part than the average cost of that part.
6. For each part, find the sname of the supplier who charges the most for that part.
7. Find the sids of suppliers who supply only red parts.
8. Find the sids of suppliers who supply a red part and a green part.
9. Find the sids of suppliers who supply a red part or a green part.
10. For every supplier that only supplies green parts print the name of the supplier and the total number of parts that she supplies.
11. For every supplier that supplies a green part and a red part, print the name and price of the most expensive part that she supplies.
Obviously Excel is the tool of choice for most people but with it's limited ability to leverage RAM (32 bit) and it's limitation with rows at just over 1 million what other choices do we have for viewing data?
My bosses boss created several OLAP universes and they seems to fly a lot fast than regular relational database. This still doesn't work with the fact the data can't be worked with unless you have a strong front end that can handle processing all those rows.
We're looking at using SSRS for all our new reporting requirements. However, we use SQLServer(2000 and 2005), Ingres and Postgres DBMSs. Ideally, we'd like to use SSRS against databases within all 3 DBMS. Ingres can be accessed via ODBC, JDBC, and has a .NET data provider, but no oledb data provider. Postgres can be accessed via ODBC. Reading some of the threads on this forum, there appears to be some limitations on the features of SSRS that can be used when accessing a database via ODBC compared to OLEDB. I'd like to understand these limitations if they exist so that we can work round them. Could anyone point me in the direction of a document that covers this issue, or outline what the issues are.
Many Thanks
Tony.
Can anybody give me information that where i can found he online edition of Sudarshan and Korth's DBMS book
Regards
Praveen Kumar Pandey
Hello,
I've proposed to the head of IT at my organisation to head an database development export group to:
- Provide assistance in improving the performance of existing relational databases
- Provide assistance for the development of new database, e.g. correct construction of indexes; data contention, etc.
- Creation of database development standards
- Enforce the above standards for new databases so that the database is not deployed to production servers until it passes the standards.
I'd really like this to be a success as it should improve our rather crappy databases, basically because the people currently creating the databases don't know much about relational design.
Can anyone please post their experiences of setting something like this up, or working on such an expert group where they work? I'd really like to hear the good and bad experiences and what and (what not) to avoid.
Thanks
Hi all
I hope you can help me in some way.
Basically for the last 5 months i've developed a SQL 2k db for my company.
All of a sudden they quite fancy using Linux on the server, therefore i would be required to use PostgreSQL instead of SQL Server 2k.
I could do with some advice about how PostgreSQL and SQL Server compare? and how much work would be involved in migrating from one to the other.
Points i've found myself and may be an issue are:
I've used some of SQL Servers XML capabilites and as far as i can tell PostgreSQL doesn't support XML.
I've made extensive use of functions that return table variables etc... is there a similar idea i can use in PostgreSQL?
Extensive use of Stored Procedures and T-SQL etc...
DTS packages. Any equivalent or similar idea?
(ps i've also posted this in the PostgreSQL but since no one replyed i was hoping the sql server boffs could help).
can ne 1 specify, how to insert a picture into a PostgreSql DB?
pl tell which data type to use and how can i display the picture in my client app
I am wondering if it is possible to access a remote postgresql database using the sql server ce access classes. I do not want to run a postgresql server on windows ce, just access one from a mobile device.
View 7 Replies View Relatedhello everyone!
I'm currently dumping tables from PostgreSQL 7 to SQL Server 2K and I've been wondering if it's possible to create a trigger between the two databases.
..like if there's an insert to a PostgreSQL table, the trigger inserts the same row to the SQL Server table.
If it is possible, please do send me a sample code.
Thanks!
Forgive me if this question is a bit too generic, if it is, feel free tojust not respond.I have a database which has been running in PostgreSQL for a number ofyears at this stage which I want to port into MS SQL server.It seems that the SQL that Postgre outputs when I do a backup is notsyntactically correct within MS-SQL server.My question is, does anyone have any documentation on how to convert adatabase from the Postgre platform to SQL server? Is it possible usingan ODBC connection to import a database structure including tabledefinitions, views etc into SQL Server?Failing this, does anyone have any suggestions on where I might start -I did attempt to go through the SQL code and modify it to suit SQLserver, but it's about 3,500 lines of code excluding the insertstatements (which themselves are also wrong) and almost every line needssomething changed when comparing SQL syntax from Postgre to MSSQL serverThanks in advance for any comments/suggestions.Engada.--Posted via a free Usenet account from http://www.teranews.com
View 1 Replies View RelatedHi,
I´m building an aplication with VB.net and SQL Server 9, but in the future it will be compatible with PostgreSQL (by another developer), so my question is, if anyone knows what "data types" in SQL Server 9 i must use to maintain compatibility with PostgreSQL, so that when the time come for the conversion i don t have to chage the "Data Types" on each table.
Any help would be apreciated.
I am trying to import one table from postgreSQL to SQL Server 2005 using sql server import and export wizard. When i test the connection after providing data source, location, username, password in the Data Link Properties section I get the message "Test Connection Succeeded". As soon as i press next to go onto next step i get the following error.
TITLE: SQL Server Import and Export Wizard
------------------------------
Cannot get string literals from the database connection "Provider=PostgreSQL.1;User ID=sa;Data Source=localhost;Location=TestMasterMap;Extended Properties=".
------------------------------
ADDITIONAL INFORMATION:
Object reference not set to an instance of an object. (DTSWizard)
------------------------------
BUTTONS:
OK
------------------------------
I have tried all sorts of different combinations for these properties but it always fails on this step. Can anybody help me with this?
Hi Friends,
I want to know if there are a manner of replication(two-way) between MSSQL SERVER and (postgresql or mysql or ORACLE).
Thanks
I am working on two versions of an application, one of which will be awindows forms application (which will need to be redistributable) andthe other will be a web application.I have MS Visual Studio 2005 (along with the developer's edition of MSSQL Server), but not MS Access. I also have MySQL, PostgreSQL, Sun'sapplication server, Tomcat and Apache web server. I am working onWindows XP Pro, and have installed the .NET 3 SDK and all relevantrelated products I could find (e.g. 2 extensions packages for VisualStudio).I have one MS Access database, to which my users should have read onlyaccess. I have, and have used, a tool for importing MS Accessdatabases into MySQL. I expect that SQL Server has a similar utilityhidden somewhere (where I haven't yet looked, though I HAVE beenlooking - obviously in the wrong places). I have located a similarutility for importing MS Access databases into PostgreSQL. I have notyet decided which servers to use for the web version, but that isanother story, for which I may raise another thread in due course (butI welcome suggestions which may reduce the effort required givenrequired effort for the windows forms app).My problem is for the windows form aplication (intended for use by asingle family). I expect to use ADO.NET. The question is, should Iimport the Access database into MS SQL, and redistribute it, along withMS SQL Server Express (or is that necessary), or distribute it just asan Access database and use the jet engine to access it. A relatedquestion is, "Does ADO.NET support creating new databases for a givenengine?" Imagine a recipe database. It is easy enough to create a SQLscript that creates all the required tables, indices, foreign keys,&c., but can I submit that SQL script to an ADO.NET object, along witha file name, and have it create, e.g., an Access database with thesupplied name. Or do I have to create a database file with nothing init other than the schema?I have more questions, but they'll have to wait.ThanksTed
View 5 Replies View RelatedHello all,I have been trying to find some information about exporting data frompostgresql on linux to ms-sqlserver 2000 on windows but have not beenable to get hold of any information. I would really appreciate ifsomeone can point me to some source of information.Thanks in advance,Nishy
View 2 Replies View RelatedHello,
First of all, this is my first time using SQL SERVER 2005 express, before that i'm using POSTGRESQL database.
I would like to know how what's the equivalent command for "BEGIN","ROLLBACK","COMMIT", these are the POSTGRESQL COMMAND use to start transaction, rollback transaction and commit transaction.
Example when i use this kind of command is . I need to insert data into 3 table. before insert into table1, i issue "begin", start to insert data into table1, if table1 no error, then i proceed to table 2 and table3. if table2 and table3 no error. then issue "commit" to commit the changes. but if any error happen between table1 and table 2 or table 2 and table3, i will issue "rollback" to roll any changes that i make to table1, table2 and table3.
Maybe some one can teach me how to achieve using SQL SERVER 2005 EXPRESS.
Thanks and Regards.
Beh Chun Yit
Hi
I want to know is a flat file faster than a RDBMS for indexing for example a search engine indexing would a flat file be better in terms of performance, scalability etc than a RDBMS?
I want to thank Brett Kaiser and Pat Phelan for advising me to get the "The Guru's Guide to Transcact-SQL" HOLY MOLY what an awesome book and the software that comes with it is so awesome "Sequin". This book is better then any of the Microsoft books, it breaks it all down for you and doesnt make it too difficult to understand I stayed up late last night reading this book. (which is why I'm exhausted today). This is by far the best Transact-SQL book I have ever come across.
THANKS GUYS :):):)
Hi,
i have the following problem:
I like to extract all special characters in one table with many fields.
How can I handle this without using 'replace' for each field and many characters ?
Thx. for ur suggestions.
dajm
Hi All
I have a database I want to check whether any special characters are entered or not
E.g.
Post
-------
Director
Asst*Director
Ma^nager
I want to see all the entires where special characters like !@#$%^&*()_+ are entered
Plz help
Thanks
Hi,
I an concatenating a string using char(187) as the separator. When I run the command "select char(187)" I get the symbol >>
However, when it writes to a csv file it is showing as an overscore instead.
Is there a known problem with special characters when writing to files?
How can I insert by asp a string containing 'That's the stringAsp code:SQL = "insert into tablename (columnA) values ('" & variable & "')"The problem is when variable contains a ' (single quote), it stops thestring definition and get an error.Can I do something?Thanks--Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
View 2 Replies View Related Our SQL 2005 databases have "SQL_Latin1_General_CP1_CI_AS"
collation settings on the server. One of tables has one column declared as "ntext".
When we try to insert "‚¬" character directly trough insert statement and retrieve it, we're getting right results. When we use web-services to insert data with this character (euro), and retrieving the data back, we're not getting this sign back. We are getting some characters like little squares. If I try to copy and paste them into notepad, I am getting ???
However, when I tried to place them here, I got them right:
‚¬ Å Å¡ Ž ž Å’ Å“ Ÿ
How can we assure visually they are inserted properly?
I have the following:
Demograph Table (PK MemberID)
-MemberID
-FirstName
-LastName
InsuranceSegments Table (PK = all columns combined)
-MemberID
-ProgramCode
-StatusCode
-BeginDate
-EndDate
I need to get the data into this table (i'll call the table MyTest)
-MemberID
-FirstName
-LastName
-BeginDate
-EndDate
-ProgramCode
-StatusCode
The catch:
For each record in the demograph table I need only one segment and that segment is to be based on the greatest EndDate.
What I need:
Give me the last segment for each demograph record and put each into it table MyTest
In my pseodo thinking
INSERT INTO MyTest (MemberID, FirstName, LastName, BeginDate, EndDate, ProgramCode, StatusCode)
SELECT
Demograph.MemberID, Demograph.FirstName, Demograph.LastName,
InsuranceSegments.BeginDate, InsuranceSegments.EndDate, InsuranceSegments.ProgramCode, InsuranceSegments.StatusCode
FROM
Demograph
INNER JOIN
InsuranceSegments
ON
Demograph.MemberID = InsuranceSegments.MemberID
WHERE { Need help :-) }
Need help with the where clause to get the segment with the 'highest/latest' EndDate
Sorry for the wall of text. I hope this is enough information to receive help and would like to thank you in advance for your time :-)
J
Hi everybody,
I need to write a special count on my table and I don't have idea how to do it.
I have an Audit table like that:
EventTime (DateTimeColumn) - Description (varchar) - UserID
----------------------------------------------------------------
2008-01-28 08:47:19 blabla User 12008-01-28 08:49:04 blabla User 1
2008-01-28 08:51:52 blabla User 2
2008-01-28 08:56:38 blabla User 3
2008-01-28 11:20:03 blabla User 2
2008-01-28 11:59:57 blabla User 32008-01-28 12:00:07 blabla User 32008-01-28 12:00:16 blabla User 32008-01-28 14:52:31 blabla User 32008-01-28 14:52:34 blabla User 4
2008-01-28 15:15:43 blabla User 4
I need to count the number of record for each user (on the datetime) BUT if there are x records in the same minute, I want to count it only one time.
Exemple: the user 1 and the user 3
For the user 1, the result should be 1 because there are 2 records for him, but 2 in the same minute.
For the user 3, the result should be 3 because there are 4 records for him, but 3 in the same minute.
I have any idea about the way to do it.
Your council are welcom ;o)
Thanks in advance
Jerome
Hello,
I am starting to use SQL Server 2005. I am having trouble connecting remotely. I tried to enable the 'sa' user and got this error:
Cannot use the special principal 'sa'
Is the 'sa' user no longer valid for remote connections?
Thank you
Ok, here's my issue... SQL 2005.
I have about 12 different databases, which about 4 of them are have no user mapped to it. Under the SA login, databases are mapped to the "dbo". The 4 I am having issues with have no user mapped. They are blank.
Here is where I am at... Security>Logins>sa>Login Properties>User Mapping
The columns are "Map", "Database", "User", and "Default Schema"
Here is an example of the correct Selection
Map=checked, Database=eDistribution, User=dbo, Default Schema=dbo
Now here is an example of a problem database
Map=unchecked, Database=FORMS, User=blank, Default Schema=blank
Here is the error when trying to add the "dbo" as a user
Any ideas?
TITLE: Microsoft SQL Server Management Studio
------------------------------
Create failed for User 'sa'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+User&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Cannot use the special principal 'sa'. (Microsoft SQL Server, Error: 15405)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1406&EvtSrc=MSSQLServer&EvtID=15405&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
TITLE: Microsoft SQL Server Management Studio
------------------------------
Create failed for User 'dbo'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+User&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
User, group, or role 'dbo' already exists in the current database. (Microsoft SQL Server, Error: 15023)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1406&EvtSrc=MSSQLServer&EvtID=15023&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
Im starting a project that will be used to reserve rooms in a building. My problem right now is writing an sql statement that will return a dataset with the proper results. I have three tables setup below. I need a dataset that returns rooms that are closed on a certain date and a set that returns open rooms on a particular date.I cant seem to figure out that sql statement... Any suggestions will be greatly appreciated. tblRooms pkRoomID fkReservationID tblDates pkDateID fkReservationID tblReservation pkReservationID fkRoomID fkDateID
View 3 Replies View RelatedOn the bills that our system generates there is a comments field that users fillout. We have occasional problems with special characters in the text messing up the validation code. Does anyone know of a query that can identify special characters in a text field? Like carriage returns, tabs, etc.?
Thanks, Dave
The following SELECT query gives me a list of 50 plus countries. How do I order them by 'United States' First (happens to be ID 225) and then alphabetical?
SELECT Country_ID, Country_Long FROM Countries WHERE isIndustrial = 1 ORDER BY Country_Long
how do i remove
in all of my fields in the table ? using a TSQL command ?
"DesktopModules/Events/Events.ascx
"
thanx !!
I made a stored proc for update fields in a table everything is correct but when my new field contains a special caracter like *,/,[, ' , and a space too i have an error. I wrote it and i don't understand why it doesn't work.
CREATE PROCEDURE [sp_modif](@ID varchar(100),
@Table varchar(100),
@NewId varchar(100),
@CUSTOMER varchar(100),
@NewCUSTOMER nvarchar(255))
DECLARE @Commandvarchar(8000)
SELECT @Command = "UPDATE "+@Table+" SET ["+@CUSTOMER+"] = '"+@NewCUSTOMER+"' where ID like "+@NewId
execute (@Command)
Thank you