|
Eddy Vluggen wrote: Sql Server does not know about "domains". It hosts tables, records, and you can create things like databases and tables.
A DOMAIN in SQL is defined as a set of values for a given attribute! So, of course SqlServer knows something about domains! It just called different!
In SqlServer you use ADD CONSTRAINT to simulate domains.
------------------------------
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.
|
|
|
|
|
Goood morning
It is, you're right, stupid mistake. ..and twice as bad given the tone.
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
I saw some samples for creating UDDTs using Create Domain... .
I didn't that word from myself.
SignatureNotFoundException
|
|
|
|
|
..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
if you can't read my code, try converting it here[^]
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
Perhaps an alias data type ?
http://msdn.microsoft.com/en-us/library/ms175007(v=sql.100).aspx
|
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
Hi, Im using 2 oracle databases how this could be possibly done?
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
One option would be to use the Sync Framework[^].
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
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?
|
|
|
|
|
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
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
|
hi,
I am doing this stored procedure but getting Subquery returns more than 1 row
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..
|
|
|
|
|
SET @random_banner = (SELECT volow_banner_id FROM volow_banners WHERE volow_banner_size = param_volow_banner_size ORDER BY RAND());
should be
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.
|
|
|
|
|
|
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.
|
|
|
|
|
|
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.
|
|
|
|
|
working now.
thanks Marcus
|
|
|
|
|
You are welcome.
I wasn't, now I am, then I won't be anymore.
|
|
|
|