Database Discussion Boards

sonywar25-Nov-07 14:29

25-Nov-07 14:29

yes i am in MySQL Server command prompt and need to know how to get back to the regular prompt after pressing enter before my statement was complete.

do you know what the command is? i have read my starter sql book, and looked on many forums though i can not find a solution. I can restart the prompt though that is the long way. there is a simple backslash command i can type.

mysql> (is the regular prompt)

'>
'>
'>
'> (my prompt)

Re: n00bish SQL Question

DQNOK26-Nov-07 6:05

DQNOK

26-Nov-07 6:05

I'm not familiar with MySQL, but it may be waiting for a ';' semicolon to terminate the statement. Try ; <enter>. Don't use any non-whitespace characters after the ';', just press the enter key after the semicolon.

David
---------
Empirical studies indicate that 20% of the people drink 80% of the beer. With C++ developers, the rule is that 80% of the developers understand at most 20% of the language. It is not the same 20% for different people, so don't count on them to understand each other's code.
http://yosefk.com/c++fqa/picture.html#fqa-6.6
---------

Re: n00bish SQL Question

TJoe30-Nov-07 2:36

TJoe

30-Nov-07 2:36

Try "go" to send the command to the server.

Take care,
Tom

-----------------------------------------------
Check out my blog at http://tjoe.wordpress.com

SQL Server 2000 Backup

Ali el25-Nov-07 4:15

Ali el

25-Nov-07 4:15

Hello
i wanna know how can create a maintenance plan tl back up the database to remote server
i can do it but it backup the data on local desk. i want to do that but on remote desk

plz help me in this problem, its important to me
iam waiting ur responses.
thanks

SQL 2005 Imports

Vimalsoft(Pty) Ltd25-Nov-07 1:13

Vimalsoft(Pty) Ltd

25-Nov-07 1:13

Hi all

I have installed a SQL2005, i have an Acces database that i want to import to SQL200, i know that the Wizard we had in version 2000, is no longer available, please help me to import the database.

Thanks

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za

Re: SQL 2005 Imports

pmarfleet25-Nov-07 3:53

pmarfleet

25-Nov-07 3:53

It looks like you want the SQL Server Migration Assistant for Access[^].

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Re: SQL 2005 Imports

Vimalsoft(Pty) Ltd25-Nov-07 19:13

Vimalsoft(Pty) Ltd

25-Nov-07 19:13

Thanks Paul

Date of Birth

Brendan Vogt24-Nov-07 22:08

Brendan Vogt

24-Nov-07 22:08

Hi,

I am looking at saving my customer's date of birth, what is the best data type to use for this. I'm looking for advice. Should I just use varchar(8) or should I use the datetime datatype?

Regards
Brendan

Re: Date of Birth

Christian Graus24-Nov-07 23:13

Christian Graus

24-Nov-07 23:13

Well, the obvious question is, why do you think there's a datetime type ? Some ideas that spring to mind:

1 - if you use the date type, you can do queries based on date ranges, etc
2 - if your DB gets moved to a PC with a different date format, the varchar will break, but the datatime will work fine

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Re: Date of Birth

Cristian Amarie26-Nov-07 7:54

Cristian Amarie

26-Nov-07 7:54

Always for a date field use datetime.

Nuclear launch detected

Re: Date of Birth

PIEBALDconsult26-Nov-07 11:42

PIEBALDconsult

26-Nov-07 11:42

DateTime every time.

And why would you want to know the customer's birthdate? I always enter 1900-01-01.

Re: Date of Birth

Cristian Amarie26-Nov-07 23:11

Cristian Amarie

26-Nov-07 23:11

Marketing. Use a HTML template to congratulate the customer on birthday date...

Nuclear launch detected

SP with create table

kimo code23-Nov-07 23:42

kimo code

23-Nov-07 23:42

hi all,
can I create sp which take table name ,first column ,secound column as a parameters to create table
(2 columns only) with this varibles name
for example to demonestrate my idea
ex:
---------------------------------
create proc Createtable
@tablename,
@firstColumn Varchar(40),
@secoundColumn Varchar(40)
as
create table @Tablename (@FirstColumn Varchar(40),@SecoundColumn Varchar(40))
----------------------------------

this is my idea Plz help me

Kareem Elhosseny

Re: SP with create table

John-ph24-Nov-07 0:19

John-ph

24-Nov-07 0:19

sp_executesql 'create table ' + @Tablename + '(' + @FirstColumn + <br />
 ' Varchar(40), ' + @SecoundColumn + ' Varchar(40))'

- Regards -
JON

Life is not measured by the amount of breaths we take, but by the moments that take our breath away.

[Message Deleted]

gubba23-Nov-07 21:33

gubba

23-Nov-07 21:33

[Message Deleted]

Re: generating random numnbers

SVb.net23-Nov-07 21:36

SVb.net

23-Nov-07 21:36

you can use this command
SELECT RAND(@counter) Random_Number

123

Select Top

mehrdadc4823-Nov-07 21:20

mehrdadc48

23-Nov-07 21:20

Hi,
How can Select first 5 records of a table In SQL Server 2000?
In SQL Server 2005 can use Select Top(5) ... but in 2000 what?

Best wishes

Re: Select Top

SVb.net23-Nov-07 21:39

SVb.net

23-Nov-07 21:39

Select Top Num? * from Tablename?

example ;
i need top 5 rows from Orders.
Select top 5 from Orders

123

Re: Select Top

pmarfleet23-Nov-07 22:33

pmarfleet

23-Nov-07 22:33

It's the same syntax in both versions.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

index

SVb.net23-Nov-07 21:07

SVb.net

23-Nov-07 21:07

what's different between index and primarykey?

123

Re: index

John-ph23-Nov-07 23:45

John-ph

23-Nov-07 23:45

SVb.net wrote:
what's different between index and primarykey?

1. Primary Key Is A UNIQUE Constraint created against the table to uniquely identify each record in the table.
2. A table can have only one PRIMARY KEY constraint.
3. PRIMARY KEY constraint automatically creates Clustered Index against the Column. Physical order of rows is the same as the indexed order of the rows.

1.An Index is a UNIQUE Reference internally created by the Database engine against the Table or View for reference.
2. A table can have 250 Indexes (1 Clustered and 249 Non-Clustered).
3. Physical order of the rows is independent of their indexed order for Non-Clustered Indexes.

- Regards -
JON

Life is not measured by the amount of breaths we take, but by the moments that take our breath away.

Re: index

Xmen Real 24-Nov-07 3:50

Xmen Real

24-Nov-07 3:50

John Prabhu wrote:
Clustered Index against the Column

what does it mean? can you please explain in details ?

Becoming Programmer...

Re: index

John-ph24-Nov-07 18:17

John-ph

24-Nov-07 18:17

xmen_xwk wrote:
can you please explain in details ?

Initially when a new table is created, there is no index created by default. As I said in the previous post that an Index is a Reference created by the Database engine for reference, Just like an Index in the book to locate the information. there are 2 types of Indexes created in an Sql Server table - Clustered and Non-Clustered. As I said that When you create a Primary key on a table, By default a clustered Index is created on the table. A Clustered Index is similar to a dictionary. In a dictionary, the words are organized and sorted alphabetically. Same way on Clustered Index Column the records are sorted in the same order as the indexed order of the rows.

- Regards -
JON

Life is not measured by the amount of breaths we take, but by the moments that take our breath away.

Re: index

Xmen Real 24-Nov-07 18:32

Xmen Real

24-Nov-07 18:32

i hope, i shall understand it soon XD

Becoming Programmer...

using datasets

haseeb_saeed23-Nov-07 20:40

haseeb_saeed

23-Nov-07 20:40

Hello....i've been working in ado.net for a few months now... and am quite confused how to use the dataset object. though i know it depends on what type of project a person is upto but still i wanted to know which one is the better approach to usin the datasets...
Approach 1: fill the dataset with all tables at project load and use the dataset for all searches and things. though as sqlserver is locally placed, i update the sqlserver tables as soon as i update the data set...
Approach 2: fill dataset with only the rows that are required... ie if u need some rows according to a criteria, write a select statement, discard ur present dataset and refil it with this statement...

Please provide full information,based on performance issues of a system...
as far as i think , i believe approach1 will be better but it becomes hard to handle when u have more tables, like 60 tables... so wat should be done in this case, "A dataset for every 10 tables"? or wat...

Thanx
haseeb

haseeb

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