Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 creating table statement gets stuck

Author  Topic 

Codname47
Starting Member

4 Posts

Posted - 2010-08-25 : 16:02:32
Hi everyone, i can use "select" statements without any problem but when i want to create a table with 100-1000 rows, it gets stuck and never returns and after i close the sql navigator and restart it, it creates my table easily but after 20-30 seconds when i want to create an another table, it stucks again. What can be the problem??(At the first times that i use sql, there was no problem)

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-08-25 : 16:08:01
You've posted your question on a Microsoft SQL Server forum. It seems you are using Oracle, is that correct?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Codname47
Starting Member

4 Posts

Posted - 2010-08-25 : 16:18:18
yes, it's correct so what should i do:)
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-08-25 : 16:19:25
I don't know, we don't specialize in Oracle here. You should post your question on a site that deals with Oracle, such as the one on dbforums.com or how about the Oracle site.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Codname47
Starting Member

4 Posts

Posted - 2010-08-25 : 16:25:20
what about this question:)
Is there any way that i put a spesific column's data(only one data) into a variable??
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-08-25 : 16:26:34
Here's how you'd do it in Microsoft SQL Server (it won't work in Oracle):

DECLARE @d datetime

SELECT @d = Column1
FROM Table1
WHERE Table1Id = 1

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Codname47
Starting Member

4 Posts

Posted - 2010-08-25 : 16:31:12
Everything's hard in this oracle i don't understand why the hack that my company uses that oracle!! anyway thanks a lot..
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-08-25 : 18:33:48
That's why Oracle DBAs get paid more.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -