Database

FirstPrevNext

Re: How to reset identity(ID) field Blue_Boy25-Jul-07 22:16 Blue_Boy 25-Jul-07 22:16  dbcc checkident(tablename,reseed,1) I Love SQL asp horizontal data calvinjb888825-Jul-07 21:31 calvinjb8888 25-Jul-07 21:31  Do any one know how to display data from the data base by extracting it out using the unique id of the database. I wan to display the whole row of information of that unique id. calvin Re: asp horizontal data Vasudevan Deepak Kumar25-Jul-07 22:17 Vasudevan Deepak Kumar 25-Jul-07 22:17  Emphasizing through Multiple Duplicate Posts? Check out your original post at http://www.codeproject.com/script/comments/forums.asp?msg=2151132&forumid=1725#xx2151132xx[^] Vasudevan Deepak Kumar Personal Homepage Tech Gossips Re: asp horizontal data Pete O'Hanlon25-Jul-07 23:44 Pete O'Hanlon 25-Jul-07 23:44  Please don't repost things so quickly. It's not good practice and won't get your question answered any quicker. In fact, as you are finding out, people are more likely just to respond and tell you not to do this. Deja View - the feeling that you've seen this post before. asp horizontal data calvinjb888825-Jul-07 21:31 calvinjb8888 25-Jul-07 21:31  Do any one know how to display data from the data base by extracting it out using the unique id of the database. I wan to display the whole row of information of that unique id. calvin calvin Identity Field Muhammad Qasim Pasta25-Jul-07 21:17 Muhammad Qasim Pasta 25-Jul-07 21:17  If we have an identity field wit data type of BigInt ... but at certain stage it will overflow ... then what will happen and how can prevent for such scenario? Re: Identity Field Krish - KP25-Jul-07 21:38 Krish - KP 25-Jul-07 21:38  use decimal data type this allows max value i.e. 38 digits Regards KP Re: Identity Field Muhammad Qasim Pasta26-Jul-07 0:56 Muhammad Qasim Pasta 26-Jul-07 0:56  But at certain stage ... it could overflow too! then? for example.. in case of Amazon or any service like that... Re: Identity Field Krish - KP26-Jul-07 2:17 Krish - KP 26-Jul-07 2:17  every s/w has its own limitations. in SQL Server 2000 decimal is the one which can be used max digits pls check whether your number is more than 38 digits or in how many yrs it is going to reach this limit. or use a char/varchar data type which allowes you even more. or else take a new table. Regards KP Sql server Authentication Problem nareshss25-Jul-07 20:28 nareshss 25-Jul-07 20:28  Hi .... Iam new to dotnet and Sql server ... I want to install sql server in my system .. Ive 180 days trail version ... its installed but i cant able to login ... My System name is NARESH ... It asking about system name , username and passwords .. I gave "sa" , "sa" . But it is showling like unable to login with NARESH ... Plz help me ... Ive .net framework 2.0 in my system .. Thanks in advance Naresh Re: Sql server Authentication Problem Krish - KP25-Jul-07 20:37 Krish - KP 25-Jul-07 20:37  not getting where the probelm. however check this http://www.connectionstrings.com/[^] may help you Regards KP Re: Sql server Authentication Problem nareshss25-Jul-07 20:52 nareshss 25-Jul-07 20:52  hiiiiii... k i think u didnt get it... k my problem is not about the database connectivity ... iam juz starting sql server ... i wanna practice queries ... So i installed Sql server studio 2005 management express edition ... i installed in my PC ... Its successfully installed .. but wen am going to use sql server it is asking about username and password for sql server connection enabling ... but i dont kw how to login .. the window options r like this ... Server Type : Database Engine Sql Server Compact edition Server Name : My system name or browse Authe mode : Windows Sql Server wen i click on Sql server Login : Pwd Connect cancel ----- -------- plz help me thanks in advance naresh Re: Sql server Authentication Problem okkishore25-Jul-07 21:13 okkishore 25-Jul-07 21:13  give ur systemname as username and pwd as sa Re: Sql server Authentication Problem nareshss25-Jul-07 21:24 nareshss 25-Jul-07 21:24  no am not getting .... same error ....... unable to connect wat ive to do... is there any compatible verson of sql server ...... Re: Sql server Authentication Problem okkishore25-Jul-07 22:52 okkishore 25-Jul-07 22:52  go to enterprise manager inthat u can create ur own user name and password by that user name and pwd will help u to access query analyzer Re: Sql server Authentication Problem Blue_Boy25-Jul-07 21:29 Blue_Boy 25-Jul-07 21:29  try to connect in Windows Authentication and after you conenct create one username and password then next time connect with SQL Server Authencation mode, that (SQL Server Authencation mode) require username and password. Or check rights for your created username. I Love SQL Re: Sql server Authentication Problem nareshss25-Jul-07 21:36 nareshss 25-Jul-07 21:36  sssssssss....... i aslo done like this .... i created usrname , pswd for that ... iam getting the query enalizer ... but wer shud i get Enterprise manager in this scenario ... Re: Sql server Authentication Problem Blue_Boy25-Jul-07 22:04 Blue_Boy 25-Jul-07 22:04  Which version of SQL Server did you install? (check if service is stoped) I Love SQL Re: Sql server Authentication Problem Krish - KP25-Jul-07 22:58 Krish - KP 25-Jul-07 22:58  hope you might have installed SQL Server with Windows Authentication. if so, reinstall in mixed mode. Regards KP Re: Sql server Authentication Problem nareshss25-Jul-07 23:01 nareshss 25-Jul-07 23:01  k ill do it now... Thanks for ur help... if i face any prob ill let u kw.. bye ... naresh Re: Sql server Authentication Problem Pete O'Hanlon25-Jul-07 23:48 Pete O'Hanlon 25-Jul-07 23:48  And please - don't use textspeak. It's very very irritating because I have to spend time inserting consonants and vowels into your sentences in order for them to make any sense. Deja View - the feeling that you've seen this post before. ASP getting data from data base by the unique ID horizontally calvinjb888825-Jul-07 20:24 calvinjb8888 25-Jul-07 20:24  Do any one know how to display data from the data base by extracting it out using the unique id of the database. I wan to display the whole row of information of that unique id. calvin SubSonic Project ctrlnick25-Jul-07 17:25 ctrlnick 25-Jul-07 17:25  Hi All , I am planning to write an Article on how to use the Sub Sonic(subsonic) Data Access layer Generator. with neat illustrations. But I want to know how many are really interested in it as quite a lot of tutorials are available on the Internet. If a majority are interested then for sure I will write an article. Thank You , Warm Regards, Nikhil Pagidala Happy Programming! Regards, Nikhil Pagidala display data in crystal report shereem khaleel25-Jul-07 13:17 shereem khaleel 25-Jul-07 13:17  hello i was connect to oracle database using oracleadapter and generate for this adapter a dataset ,the dataset contain data from database when i display it on datagride but it dose not contain anything on the crystal report ????!!!!! i write these linwe on the load form event oraqcleadapter1.fill( dataset1 ) and i use .NET2005 how i can solve this problem ????? !!!!!!!!!!!!!!!!!!! Re: display data in crystal report Paul Conrad25-Jul-07 13:35 Paul Conrad 25-Jul-07 13:35  Stick to the C# or VB forum. Pick either one of those two and stick with the replies that come, if any. "The clue train passed his station without stopping." - John Simmons / outlaw programmer

Last Visit: 31-Dec-99 18:00     Last Update: 5-May-24 21:58 Refresh ᐊ Prev1...1475147614771478147914801481148214831484 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.