Database

future3839 wrote: start with SQL Server or Oracle? No. You need a broader understanding of the subject. future3839 wrote: how should I start? Go to school. Get a high-level understanding of all types of database.

You're welcome :)

thanks that help a lot, cheers

Mixing cultures in a database are a recipe for severe headache's. mehrdadc48 wrote: What collation I shoud use for my DB? The appropriate one for the required sort-method (binary or dictionary? case sensitive, or not?) for the language, they're listed here[^]. mehrdadc48 wrote: for char types I shoud use varchar or nvarchar? NVARCHAR, NTEXT and/or NCHAR. Important note; Windows Unicode-only collations can only be used with the COLLATE clause to apply collations to the nchar, nvarchar, and ntext data types on column-level and expression-level data; they cannot be used with the COLLATE clause to change the collation of a database or server instance. Says so here[^]. That page also mentions that there's three different levels where you can manage your collations. I'd like to suggest that you append the collation that's required by the current UI to the query. Are you also going to store dates from regions where they speak those languages? If that's the case, you'd also need to check whether the datatimes in the database are all stored in the same timezone (using server-time!) or the local users' time. The latter should be entered in the database re-adjusted to the timezone of your server, or, alternatively, stored the timezoneinformation in an accompanying field. That should be enough to get you up and running. Enjoy :) I are Troll :suss:

Before you shrink/truncate your transaction log, make sure you have a proper backup so that you can recover the data. You may want to investigate the Simple Recovery Model for your backups. Read this article http://databases.about.com/od/sqlserver/a/recoverymodels.htm[^]

jrahma wrote: I am looking for the steps on how to save and how to read images from/to mysql using C#? Would a CodeProject article[^] on the subject help? I are Troll :suss:

ta, I am sure that there is a way to pass those values though another option that I have used before is to update a parm table with the values from the stored procedure and then kick off the SSIS package which reads the parm table. I hope that this helps Robert Ford

Like this[^] ;P I are Troll :suss:

logicon wrote: I have a table with 50000000+ rows in SQL Server 2008 R2 Express...Datagridview You need to change your requirements. And what is the growth rate of this table? What happens when it is 10 times bigger than it is now?

thanku.. for reply i have just change the language setting..

chandru222 wrote: i have successfully inserted image in database but i couldn't update it Why not? Did you get an error? What did it say? I are Troll :suss:

Hum Dum wrote: for that i have to use cursor. I presume you select statement will not do the job for you Insert Tablename (columnames....) select columnnames... from #Temp_940 Never underestimate the power of human stupidity RAH

thanks .. i got in 2008 enterprise edition....

Hi Luc pattyn, Thanks for your reply. Instead of restoring database Is there any other way by changing configuration in "my.cnf" file?. Thanks, Periyasamy.R

How about where instr(substr(xfield,1,3),'(') > 0 or instr(substr(xfield,1,3),')') > 0 or instr(substr(xfield,1,3),'/') > 0 or instr(substr(xfield,1,3),'%') > 0 or instr(substr(xfield,1,3),':') > 0 Can't remember if the % or : character need to be escaped. :) Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra] posting about Crystal Reports here is like discussing gay marriage on a catholic church’s website.[Nishant Sivakumar]

Wow, I'm impressed. I had no idea it could be accomplished in so few of steps. Of course, I'm still trying to decode some of the "ADD CONSTRAINT" and REFERENCES language but I get the basic gist of what you're saying. I also had no idea that you could do the self referencing and thought, at minimum, it would require two tables. Very cool. Thanks so much !!

Please don't give people bad advice like this. You've basically just advised the poster that they should leave themselves wide open to a SQL Injection attack, and that's not cool. I have CDO, it's OCD with the letters in the right order; just as they ruddy well should be Forgive your enemies - it messes with their heads My blog | My articles | MoXAML PowerToys | Onyx

Thank you for your help. Yes, actually the IntelliSense was off and doing a Build Solution fixed it so that the IntelliSense told me the return type was object, and I was off and running! :D Brian Sincerely Yours, Brian Hart

My Preference goes to PostgreSQL.