Database

FirstPrevNext

Re: coping data in sql server express Blue_Boy26-Jul-07 3:55 Blue_Boy 26-Jul-07 3:55  Why did you replied to me?! I Love SQL How to reset identity(ID) field Mubashir Javaid25-Jul-07 22:09 Mubashir Javaid 25-Jul-07 22:09  I am using SQL server 2000. I have added some records in table. and then deleted. Now I would like ID field to start count from 1 and onward. what command will be used. God Bless you. Always do good to others Re: How to reset identity(ID) field Vasudevan Deepak Kumar25-Jul-07 22:15 Vasudevan Deepak Kumar 25-Jul-07 22:15  DBCC CHECKIDENT Check out http://www.mssqlcity.com/FAQ/Devel/reset_identity_column.htm[^] Vasudevan Deepak Kumar Personal Homepage Tech Gossips Re: How to reset identity(ID) field Muhammad Qasim Pasta25-Jul-07 22:37 Muhammad Qasim Pasta 25-Jul-07 22:37  I agree... but what about the relationships and constraints ... if I have a primary key of identity column .. then that statement will generate value that already exists in my table.... m I right? 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.

Last Visit: 31-Dec-99 18:00     Last Update: 21-Sep-24 22:47 Refresh ᐊ Prev1...1476147714781479148014811482148314841485 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.