Database

FirstPrevNext

Re: Identity in a field M. J. Jaya Chitra26-Dec-07 16:49 M. J. Jaya Chitra 26-Dec-07 16:49  Already my data type is big int. My application is going to store voluminous transactions in the database. Best Regards, M. J. Jaya Chitra Re: Identity in a field vimal_yet27-Dec-07 1:00 vimal_yet 27-Dec-07 1:00  Then use GUID in SQL Server. by using the function newid() If U Get Errors U Will Learn If U Don't Get Errors U Have Learnt Re: Identity in a field Dave Kreskowiak27-Dec-07 5:07 Dave Kreskowiak 27-Dec-07 5:07  BigInt and you think you're going to run out of IDs?? You can't possibly tell me that your table is going to hold more than 9,223,372,036,854,775,807 (time 2 for negative numbers) records. I'd like to see the storage drive array that's going to hold this database, not to mention the backup scheme you've got. A guide to posting questions on CodeProject[^] Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic      2006, 2007 access to temprory table colum in Mysql sepel24-Dec-07 20:48 sepel 24-Dec-07 20:48  hi all. i write a sp to create a temprory table with a select query and then with special column of myTemp table update another table. i can access myTemp table after create it in a select query: CREATE TEMPORARY TABLE wgrade select //some code FROM `engage_applicant` where //some code select wgrade.idApplicant from wgrade where ; it works ok. but when i use update query: CREATE TEMPORARY TABLE wgrade select //some code FROM `engage_applicant` where //some code update tb2 set tb2.WrittenExamGrade=wgrade.WrittenExamGrade where tb2.idApplicant=wgrade.idApplicant; i have this error: Unknown column 'wgrade.idApplicant' in 'where clause' Can any one help me? sepel error in sql 2005 break_day24-Dec-07 4:24 break_day 24-Dec-07 4:24  hi, i create the form1 Private Sub form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load AttachDB() End Sub and create module1 Module Module1 Public myConnection As New SqlConnection() Public Sub AttachDB() myConnection.ConnectionString = " Data Source=.\SQLEXPRESS;AttachDbFilename=C:\WindowsApplication1\SQLDB\ATM.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True" myConnection.Open() End Sub End Module and in run time stop the project and say there error in "AttachDB() and error is "The type initializer for 'WindowsApplication1.Module1' threw an exception" Re: error in sql 2005 Paul Conrad26-Dec-07 12:12 Paul Conrad 26-Dec-07 12:12  Have you figured out why this is happening? "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon How to insert record from XML document without using sp_xml_preparedocument procedure Software_Guy_12323-Dec-07 22:59 Software_Guy_123 23-Dec-07 22:59  Hi, In couple of procedures we are passing xml formatted data and inserting into temporary tables using sp_xml_preparedocument. Is there any other approach without using sp_xml_preparedocument procedure we can insert data from xml formatted data. We are looking for better performance. I hope somebody can help on this. Thanks in advance. Thanks & Regards, Kumar Re: How to insert record from XML document without using sp_xml_preparedocument procedure Paul Conrad6-Jan-08 10:01 Paul Conrad 6-Jan-08 10:01  What is wrong with the stored procedure? Software_Guy_123 wrote: We are looking for better performance. Might not be much else you can do. Maybe relook at how the xml data is being stored/fetched. "I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon how can export my image data... koolprasad200323-Dec-07 18:01 koolprasad2003 23-Dec-07 18:01  hello frnds, i have a table having 2 columns of type IMAGE i want to export the data and take it to my office, i try with export to excel facility but failed. what can do ???? Is there any other method to export image data...please tell where i am wrong...? thaknx in advance -koolprasad2003 Be a good listener...Because Opprtunity knoughts softly...N-Joy Re: how can export my image data... Pete O'Hanlon23-Dec-07 23:33 Pete O'Hanlon 23-Dec-07 23:33  You need to write some code to take the raw data and convert it into an image format. There are numerous samples around that show how to do this, but without knowing which languages you are familiar with, I can't refine this down for you. Deja View - the feeling that you've seen this post before. My blog | My articles MySQL and Images [modified] - RESOLVED Mike L.22-Dec-07 21:56 Mike L. 22-Dec-07 21:56  I'm generally familiar with SQL Server 2005 and I know there's an IMAGE data type that I can use to store pictures in the db. Can MySQL do the same? I'll be heading to the book store tomorrow to pick up a book and read up on this, but any experience in this area, particularly including taking pictures that are saved on my local disk and storing them in a web-based MySQL db would be greatly appreciated. I've seen sample apps for SQL Server 2005 that do this, but not MySQL and get the impression it's not nearly as easy, but probably possible. Thanks!! modified on Monday, December 24, 2007 10:29:00 PM Re: MySQL and Images Paul Conrad23-Dec-07 6:09 Paul Conrad 23-Dec-07 6:09  Mike L. wrote: IMAGE data type that I can use to store pictures in the db. Can MySQL do the same? Yes. I think it is the blob datatype. "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon Re: MySQL and Images Mike L.23-Dec-07 11:38 Mike L. 23-Dec-07 11:38  Thanks - I'll go get a book and see if I can find some examples. Re: MySQL and Images Paul Conrad23-Dec-07 13:40 Paul Conrad 23-Dec-07 13:40  I have a sample around here somewheres. I'll try to find it. "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon Re: MySQL and Images Mike L.23-Dec-07 13:44 Mike L. 23-Dec-07 13:44  Thanks Paul. I also have the ability to use Access, and have samples for storing & retrieving files from that. Any advantage to MySQL, since I don't have MySQL, but do have Access? i.e., it'll cost me some money to use MySQL, where I can use Access for free, and this is a personal web site for storing photo's, etc. Re: MySQL and Images Paul Conrad23-Dec-07 13:52 Paul Conrad 23-Dec-07 13:52  Go ahead and use Access. Shouldn't be any problems. Since you are going to be storing photos, the best approach with a database is to save just the path on the server to the photos rather than putting the photos in the database. "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon Re: MySQL and Images Mike L.23-Dec-07 13:59 Mike L. 23-Dec-07 13:59  That would certainly make it easier, but won't having a database and an "add picture and keywords" type of functionality make it easier to store, retrieve, and catalog? I have literally thousands and thousands of travel photos from all over the world, and want to be able to give friends and family the ability to search by subject, then return those that match the criteria, which would then show thumbnails, and a click would bring up the full size image.... Thanks for all the help! Re: MySQL and Images Paul Conrad23-Dec-07 14:21 Paul Conrad 23-Dec-07 14:21  You could still just store the path to the pictures even with searching abilities. "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon Re: MySQL and Images Mike L.24-Dec-07 16:28 Mike L. 24-Dec-07 16:28  The logic and the simplicity of that just dawned on me - I still get "protected" storage from the site, and retain search and keyword capbilities. Plus I don't have the overhead of database load/unload and the associated database size issues. Thanks Paul - that seems to be the most sensible approach and also easiest. Re: MySQL and Images Paul Conrad24-Dec-07 16:44 Paul Conrad 24-Dec-07 16:44  No problem. Glad it is working out for you "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon connecting to mssql 2005 express from vs2008 - RESOLVED l a u r e n22-Dec-07 21:06 l a u r e n 22-Dec-07 21:06  using c# ... is driving me insane it wont let me connect no matter what i do or what incantations i try can somebody point me to the reqd small animals to sacrifice?? thnx [edit] i figured it out ... twisted isnt the word [/edit] "mostly watching the human race is like watching dogs watch tv ... they see the pictures move but the meaning escapes them" modified on Sunday, December 23, 2007 4:40:10 AM Help in query design NetBot22-Dec-07 18:08 NetBot 22-Dec-07 18:08  Hi all, following is my yable schema Tic_pk | Tic_Denom_No | Tic_start_no | Tic_end_no -------------------------------------------------- 100 | 5 |111112411| 111112510 101 | 5 |111112511 | 111112610 102 | 5 |111112611 | 111112710 all i want that when user selects a Tic_denom, a start num and an end number the middle record should also b considered eg: tic_denom_no=5 startno:111112411 end no: 111112710 the middle record should also be returned because the start and end of the middle rec also falls in the range.. pls help thanks in adv Re: Help in query design Paul Conrad23-Dec-07 6:14 Paul Conrad 23-Dec-07 6:14  Maybe something like: SELECT DISTINCT * FROM YourTable WHERE Tic_Denom_No=5 AND (Tic_start_no > 111112411 AND Tic_end_no < 111112710) Or something along those lines... "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon Transfer records From Local To Host mehrdadc4822-Dec-07 9:01 mehrdadc48 22-Dec-07 9:01  Hi, I have a web site that the DB of it (SQL Server) is created on host but its tables is empty. I populate tables Locally and now I want to transfer the records from local (My Computer) to Server. The host don't permit for restore and attach, and if I develope an application for transfering data, a problem occures: Spot this table(on local): ID Name --- ------- 1 John 2 Merry 4 Simon that ID Field, its identity is 'yes'. Now if I want to insert this in server 'simon' gives '3' ID, And this table have relation with other table on 'ID' field? what should I do? Best wishes Re: Transfer records From Local To Host DigiOz Multimedia22-Dec-07 11:49 DigiOz Multimedia 22-Dec-07 11:49  You need to disable foreign key constraints (and triggers if needed) before inserting. For SQL Server 2005 this is: Disable all Constraints: ALTER TABLE YourTable NOCHECK CONSTRAINT ALL Disable all Triggers on a table DISABLE Trigger ALL ON YourTable Make sure to turn them back on when you are done. Pete Soheil DigiOz Multimedia http://www.digioz.com

Last Visit: 31-Dec-99 18:00     Last Update: 27-Apr-24 22:30 Refresh ᐊ Prev1...1295129612971298129913001301130213031304 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.