|
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
|
|
|
|
|
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?
|
|
|
|
|
use decimal data type
this allows max value i.e. 38 digits
Regards
KP
|
|
|
|
|
But at certain stage ... it could overflow too! then? for example.. in case of Amazon or any service like that...
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
|
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
|
|
|
|
|
give ur systemname as username and pwd as sa
|
|
|
|
|
no am not getting ....
same error .......
unable to connect
wat ive to do...
is there any compatible verson of sql server ......
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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 ...
|
|
|
|
|
Which version of SQL Server did you install?
(check if service is stoped)
I Love SQL
|
|
|
|
|
hope you might have installed SQL Server with Windows Authentication.
if so, reinstall in mixed mode.
Regards
KP
|
|
|
|
|
k ill do it now...
Thanks for ur help...
if i face any prob ill let u kw..
bye ...
naresh
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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 ????? !!!!!!!!!!!!!!!!!!!
|
|
|
|
|
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
|
|
|
|
|
he's a frequent cross poster and must be punished.
_____________________________________________
Flea Market! It's just like...it's just like...A MINI-MALL!
|
|
|
|
|
leckey wrote: he's a frequent cross poster and must be punished
I am starting to get very cranky about these cross posts the past few weeks and idiotic questions, so it time to ...
[Emeril voice] Kick it up a notch [/Emeril voice]
"It's only that urgent if you have to pee.." - Dave Kreskowiak
|
|
|
|
|
How do I change one format column to another format?.Please any help is appreciated
Sabina
|
|
|
|
|
do mean changing one column datatype format to antoher datatype format
then
alter table tablename alter column columnname newdatatype
example:
sno is int then changing int to float
alter table student alter column sno float
|
|
|
|