Database Discussion Boards

Re: Can I use "Create Domain" in Sql Server 2008?

Eddy Vluggen25-Oct-12 5:41

Eddy Vluggen

25-Oct-12 5:41

Goood morning Big Grin | :-D

It is, you're right, stupid mistake. ..and twice as bad given the tone.

Bastard Programmer from Hell Suspicious | :suss:

if you can't read my code, try converting it here[^]

Re: Can I use "Create Domain" in Sql Server 2008?

WebMaster28-Oct-12 22:33

WebMaster

28-Oct-12 22:33

I saw some samples for creating UDDTs using Create Domain... .
I didn't that word from myself.

SignatureNotFoundException

Re: Can I use "Create Domain" in Sql Server 2008?

Eddy Vluggen25-Oct-12 4:11

Eddy Vluggen

25-Oct-12 4:11

..now that I had my rant, let's try and find an answer to your problem. For that, we first need to get a clear description on the problem itself; as is know, I can only guess at what you are trying to do.

Are you trying to store email-adresses? (creating them is done in another server)
Create a login? (Google for "create login")
Something else?

Bastard Programmer from Hell Suspicious | :suss:

if you can't read my code, try converting it here[^]

Re: Can I use "Create Domain" in Sql Server 2008?

WebMaster28-Oct-12 22:42

WebMaster

28-Oct-12 22:42

I am trying to create a UDDT. I know how to do it using "Create Type", but I have also saw some query like I have posted.

SignatureNotFoundException

Re: Can I use "Create Domain" in Sql Server 2008?

Ingo25-Oct-12 4:24

Ingo

25-Oct-12 4:24

Well, as I know, DOMAIN is not implemented in SqlServer but as a SQL-Language element it's a reserved word.
You can use ADD CONSTRAINT to check the values (google for sql server add constraint, there are lot of samples).

------------------------------
Author of Primary ROleplaying SysTem

How do I take my coffee? Black as midnight on a moonless night.
War doesn't determine who's right. War determines who's left.

Re: Can I use "Create Domain" in Sql Server 2008?

Member 954700625-Oct-12 18:21

Member 9547006

25-Oct-12 18:21

Perhaps an alias data type ?

http://msdn.microsoft.com/en-us/library/ms175007(v=sql.100).aspx

Re: Can I use "Create Domain" in Sql Server 2008?

J4amieC25-Oct-12 21:32

J4amieC

25-Oct-12 21:32

Link police, at your service

http://msdn.microsoft.com/en-us/library/ms175007(v=sql.100).aspx[^]

Database Synchronization

KingJames0624-Oct-12 16:31

KingJames06

24-Oct-12 16:31

Hi guys, I need to update the data in local database from other database automatically, by date or suggest if there is other way thanks for the help Smile | :)

Re: Database Synchronization

Jörgen Andersson24-Oct-12 20:09

Jörgen Andersson

24-Oct-12 20:09

Depends, on the connection, databases used, and your data.
Running a script on a timer is the obvious way, but you might want to take a look into materialized views, or indexed views depending on your flavour of RDBMS.
I don't necessarily recommend it, it depends.

Light moves faster than sound. That is why some people appear bright, until you hear them speak.
List of common misconceptions

Re: Database Synchronization

KingJames0624-Oct-12 21:27

KingJames06

24-Oct-12 21:27

Hi, Im using 2 oracle databases how this could be possibly done?

Re: Database Synchronization

Jörgen Andersson24-Oct-12 23:54

Jörgen Andersson

24-Oct-12 23:54

Start with creating a database link.
Here's[^] the reference. But as the Oracle reference sucks for learning, I suggest that you google it instead. There's a ton of info on the net.

When you have created the link you should be able to SELECT * FROM mytable@the_other_server.
If this works you can either run a script to update the tables on your server, or create a materialized view that does this automatically.
How to create a materialized view is a much to big subject to answer here, I suggest google again.
Just remember that there are a lot of conditions that needs to be met to get a MV to work.

Light moves faster than sound. That is why some people appear bright, until you hear them speak.
List of common misconceptions

Re: Database Synchronization

Jörgen Andersson25-Oct-12 3:55

Jörgen Andersson

25-Oct-12 3:55

More info on Advanced Replication[^]

It always helps having the right search term.

You can also find Advanced Replication setup in the Oracle Enterprise Manager under the Data Movement tab.

Light moves faster than sound. That is why some people appear bright, until you hear them speak.
List of common misconceptions

Re: Database Synchronization

Eddy Vluggen24-Oct-12 22:51

Eddy Vluggen

24-Oct-12 22:51

One option would be to use the Sync Framework[^].

Bastard Programmer from Hell Suspicious | :suss:

if you can't read my code, try converting it here[^]

Re: Database Synchronization

KingJames0624-Oct-12 23:00

KingJames06

24-Oct-12 23:00

Hi, can I use stored procedure to sync data from other database using DBLink? What are the possible querries that I need to do in this process?

Re: Database Synchronization

Eddy Vluggen24-Oct-12 23:17

Eddy Vluggen

24-Oct-12 23:17

KingJames06 wrote:
Hi, can I use stored procedure to sync data from other database using DBLink?

Dunno, I don't know DBLink. Hence, I can also not say if it is an easier or more efficient approach than the Sync Framework which I did recommend.

KingJames06 wrote:
What are the possible querries that I need to do in this process?

Depends on your database and it's structure. Syncing is a delicate process, I suggest you take a few days to read everything on the topic that you can find Smile | :)

Bastard Programmer from Hell Suspicious | :suss:

if you can't read my code, try converting it here[^]

Re: Database Synchronization

ENOTTY24-Nov-12 19:35

ENOTTY

24-Nov-12 19:35

Use SymmetricDS: http://www.symmetricds.org/[^]

Subquery returns more than 1 row

Jassim Rahma24-Oct-12 10:27

Jassim Rahma

24-Oct-12 10:27

hi,

I am doing this stored procedure but getting Subquery returns more than 1 row

SQL

CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_populate_advertisement`(IN `param_volow_banner_size` varchar(255))
BEGIN
    SET @random_banner = (SELECT volow_banner_id FROM volow_banners WHERE volow_banner_size = param_volow_banner_size ORDER BY RAND());
    INSERT INTO volow_banner_log (volow_banner_id) VALUES (@random_banner);
    SELECT volow_banner_file FROM volow_banners WHERE volow_banner_id = @random_banner;
END

can you help please..

Re: Subquery returns more than 1 row

fjdiewornncalwe24-Oct-12 10:34

fjdiewornncalwe

24-Oct-12 10:34

SQL

SET @random_banner = (SELECT volow_banner_id FROM volow_banners WHERE volow_banner_size = param_volow_banner_size ORDER BY RAND());

should be

SQL

SET @random_banner = (SELECT volow_banner_id FROM volow_banners WHERE volow_banner_size = param_volow_banner_size ORDER BY RAND() LIMIT 1);

I wasn't, now I am, then I won't be anymore.

modified 24-Oct-12 16:49pm.

Re: Subquery returns more than 1 row

Jassim Rahma24-Oct-12 10:38

Jassim Rahma

24-Oct-12 10:38

syntax error

Re: Subquery returns more than 1 row

fjdiewornncalwe24-Oct-12 10:42

fjdiewornncalwe

24-Oct-12 10:42

what db are you using. I wasn't paying attention and assumed MSSQL.

I wasn't, now I am, then I won't be anymore.

Re: Subquery returns more than 1 row

Jassim Rahma24-Oct-12 10:46

Jassim Rahma

24-Oct-12 10:46

it's MySQL

Re: Subquery returns more than 1 row

fjdiewornncalwe24-Oct-12 10:49

fjdiewornncalwe

24-Oct-12 10:49

I've updated my original answer to reflect MySql. Sorry for the confusion.

I wasn't, now I am, then I won't be anymore.

Re: Subquery returns more than 1 row

Jassim Rahma24-Oct-12 10:52

Jassim Rahma

24-Oct-12 10:52

working now.

thanks Marcus

Re: Subquery returns more than 1 row

fjdiewornncalwe24-Oct-12 11:03

fjdiewornncalwe

24-Oct-12 11:03

You are welcome.

I wasn't, now I am, then I won't be anymore.

locking on select

dabuskol20-Oct-12 19:37

dabuskol

20-Oct-12 19:37

Hi,

I have a SP that calculates data based on criteria, the result were % and duration. It takes 8-10 seconds before it displays the result.
The problem is when more users are trying to generate the report, it seems that it takes more time.

My problem was when I tried to update a simple statement such as below, it resulted to a "time out expired" and it affects the entire process of the application becuase users cannot perform their task.

update table
set status = 1
where keyId = 6

I don't have any locking on my select nor update.
What is the best practice to resolve it?
I have 100 users nationwide aside from report users, please need help.

Thanks in advance
Dabuskol

Dabsukol

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