Database

Glad to be able to help. :) Appreciative feed back is the best driving force there is! Wrong is evil and must be defeated. - Jeff Ello[^]

...for the moment.... thank you for your kind replies

It looks like you are performing an insert within your trigger on the table the trigger is running from CREATE trigger In_LoaiDG1 on KhaoSat_LoaiDG1 insert into KhaoSat_LoaiDG1 Any clues as to why this may be a bad idea? Hint - infinity... Just remove: else insert into KhaoSat_LoaiDG1(MaLoaiTT,Muc1,NgayDG) values (@MaLoaiTT,1,@NgayDG) and see what happens. “That which can be asserted without evidence, can be dismissed without evidence.” ― Christopher Hitchens

Refer ssrs-reports-browser-compatability-issues[^] Hope it will help.. :)

Just noting that if your intent is that your application will be doing all of the database administration then choosing a database that is less full featured might be a better option. And choosing an embedded database might be a better option as well.

Not sure. You might need to add a mysql_set_charset('utf8'); between the connection and the selection of the db.

Hi, I am a user of MySql. In Mysql we can go for the query select * from Patient where time=(select max(time) from Patient); Hope it will work for you. Check n update.

What's the exact error message? Wrong is evil and must be defeated. - Jeff Ello[^]

Use a DSN-less connection like OLEDB. It is much faster than ODBC anyway. "Go forth into the source" - Neal Morse

many functions are available in php for how to connect to mysql and be interactive between both of them These functions allow you to access MySQL database servers. More information about MySQL can be found at » http://www.mysql.com/. Documentation for MySQL can be found at » http://dev.mysql.com/doc/.

why you dont declare the column in the design of table auto increamnet ?

http://dev.mysql.com/[^]

Does "Indexed" mean using primary key as filter or something else?

Databases save datetime values as numbers. There is no datetime format in which the computer system stores a datetime. Once you understand this you can then understand that the format of the datetime data returned to you will be dependent on the collation of your database, when you perform a simple select,or the format you extract the data as. All you need to remember is that the datetime value is saved, within the database, as a number and you will then understand that all formatting issues are resolvable. N.B. for this reason never save a datetime as a string as if you do you will lose precision. “That which can be asserted without evidence, can be dismissed without evidence.” ― Christopher Hitchens

Thanks for your replay can you please suggest me the better links to refer that will help me to create my own DLL file .

Quote: 1. So while designing the database model whether is it a good idea to keep separate databases for each merchant or keep a single database?. Separate databases with separate security credentials. You really don't want a data breach if you can possibly avoid it. Quote: 5. Which kind of sever solution in this case we need to propose, Cloud based database or Godaddy like hosting server?. Cloud database - as you have already specified SQL Server I recommend SQL Azure.

columbos14927 wrote: but the CustomerId is changed from 3045 to 1 and save I am going to guess that CustomerID at the database level is an Identity Column? If that's the case then the value you are trying to set is not going to be accepted by the database engine. Common sense is admitting there is cause and effect and that you can exert some control over what you understand.

It's entirely doable, our EDW team does it. Loosely 1) Pull data from SalesForce.com into a staging environment (we use their dbamp application to do it) 2) Pull data from Prism into a staging environment (AS400 ODBC connection) 3) Pair the data together into Facts and Dimensions. Log data miss matches for user reporting Both systems should have customer numbers that match up, it entirely probably some where Salesforce.com is getting your Prism Customer numbers (or should be). 4) Once a solid data model has been built generating a cube off of that data is then easy. For more conceptual information -> http://en.wikipedia.org/wiki/Data_warehouse[^] Common sense is admitting there is cause and effect and that you can exert some control over what you understand.

gmhanna wrote: wonder what happens when I've added and deleted 4 Billion records Instead of running a delete command, use truncate table. That will reseed the identity field, thus allowing you to regenerate the numbers. (Not that there is anything wrong with what others suggested of just using a BIGINT for the ID field. Once MAX INT has been reached you will no longer be able to insert records into that table.) 2) If you are unable to truncate the table, then you can reseed the key. More information can be found here http://blog.sqlauthority.com/2007/03/15/sql-server-dbcc-reseed-table-identity-value-reset-table-identity/[^] A quick example CREATE TABLE Test(id INT IDENTITY(1, 1), TestValue INT) GO INSERT INTO test VALUES(1) INSERT INTO test VALUES(2) INSERT INTO test VALUES(3) INSERT INTO test VALUES(4) INSERT INTO test VALUES(5) GO SELECT * FROM test GO DELETE test GO INSERT INTO test VALUES(1) INSERT INTO test VALUES(2) INSERT INTO test VALUES(3) INSERT INTO test VALUES(4) INSERT INTO test VALUES(5) GO SELECT * FROM test GO TRUNCATE TABLE TEST GO INSERT INTO test VALUES(1) INSERT INTO test VALUES(2) INSERT INTO test VALUES(3) INSERT INTO test VALUES(4) INSERT INTO test VALUES(5) GO SELECT * FROM test GO DBCC CHECKIDENT(test, reseed, 1) GO INSERT INTO test VALUES(1) INSERT INTO test VALUES(2) INSERT INTO test VALUES(3) INSERT INTO test VALUES(4) INSERT INTO test VALUES(5) GO SELECT * FROM test GO DROP TABLE test gmhanna wrote: This is SQL Server, and I'm wondering if I should be doing a database REORGs like we do with DB2. From IBM's website, looks like the same feature would exist in SQL Server as clustered index management (more information http://technet.microsoft.com/en-us/library/ms189858.aspx[^]) Common sense is admitting there is cause and effect and that you can exert some control over what you understand.