|
You should have different triggers for each table, mainly because each table will be structured differently, and I assume that the triggers will be different.
Arthur Dent - "That would explain it. All my life I've had this strange feeling that there's something big and sinister going on in the world."
Slartibartfast - "No. That's perfectly normal paranoia. Everybody in the universe gets that."
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
How i can detemine a changes that occure in my database and then i deside based on it.
for example :
i have a database program that locate in one server in my local network,two or more users run it and each one use own sections in my application.when one user add,delete or update records of my database Tables how i can determine this event.because i want to show changes immidiatly to other users that syncronously running my app.
please help me.
|
|
|
|
|
Each user is using a different DB? if so, then replication is what your looking for.You can also look at writing Trigers..
|
|
|
|
|
I have one App in Server and Each user Login to it then based on permissions that define , can access to own sections in app.my program have one database and 40 table.
Please guide me by sample.
|
|
|
|
|
Can we write a procedure in MS sql server to make a connection with oracle?
|
|
|
|
|
I'm not sure what you want to do, but it is possible that a linked server[^] is an answer to your problem.
|
|
|
|
|
Hi,
I am using MS SQL 7 and would like to know if there is a way to setup MS SQL to run a script at a given time, i.e running an end of day script at midnight on some tables.
Thanks in advance,
Pieter
|
|
|
|
|
There is - you're in luck. What you do is to set up a job in SQL Server to do this. Here's how:
http://support.microsoft.com/kb/269074[^]
Good luck.
Arthur Dent - "That would explain it. All my life I've had this strange feeling that there's something big and sinister going on in the world."
Slartibartfast - "No. That's perfectly normal paranoia. Everybody in the universe gets that."
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Hi All,
I am looking for the functions in SQL server which would return me the mid day, last day of the month given the current date and the param. I would appreciate if you could point me to some related links. I have written some SQLs to do this but looks very ugly with lots of code.
Input will be some date and period.
Output will be the Till ending date interval1 and Till ending date interval2
If period(1) = weekly then the Till ending date = end of the current week (Sun) - I assume a week begins on Monday.
If period(2) = bi-weekly then the Till ending date = end of the following week (Sun)
If period(3) = semi-monthly & today <= 15th of the month then the Till ending date = 15th of the current month, otherwise Till ending date = end of month.
If period(4) = monthly then the Till ending date = end of month
For example:
Input
Some_date : 1-Jan-2006
Period
Output
Period Out1 Out2
1 8-Jan 15-Jan
2 15-Jan 29-Jan
3 15-Jan 31-Jan
4 31-Jan 28-Feb
Thanks for the help.
|
|
|
|
|
Do you have SQL Server Help? Start by looking at the help for functions GETDATE() and DATEPART(). Then follow other related links from there.
Scott
|
|
|
|
|
I can not connect to a database oracle 10g from the .net
I receive this error msg "ORA-12154:TNS could not resolve the connect identifier specified
Dad
|
|
|
|
|
See my reply in the other thread. Please don't cross post 
Some people have a memory and an attention span, you should try them out one day. - Jeremy Falcon
|
|
|
|
|
ORA-12154 TNS:could not resolve service name
Cause: The service name specified is not defined correctly in the TNSNAMES.ORA file.
Action: Make the following checks and correct the error:
Verify that a TNSNAMES.ORA file exists and is in the proper place and accessible. See the operating system specific manual for details on the required name and location.
Check to see that the service name exists in one of the TNSNAMES.ORA files and add it if necessary.
Make sure there are no syntax errors anywhere in the file. Particularly look for unmatched parentheses or stray characters. Any error in a TNSNAMES.ORA file makes it unusable. See the Oracle Net Services Administrator's Guide. If possible, regenerate the configuration files using the Oracle Network Manager.
Rupa
|
|
|
|
|
User Id=SYSTEM;Password=MANAGER;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.4)(PORT=1521))(CONNECT_DATA=(SID=XE)))
Use you connection string like this.
Thanks & Regards,
Anil Chelasani
|
|
|
|
|
I need to show a grid on an asp.net C# page that has a list of customers and the count of records in a table for them.
I have a stored procedure that will return the count for a single customer.
I'm using a C# class that returns a dataset which then gets bound to the grid on the C# page that calls it.
I'm wondering what the best way of building the dataset is. I'm assuming that I call the stored procedure for each customer and then add the results to a dataset.
But do I need a temp dataset to put the stored procedure results in each time it is run and then add the results to a master dataset which I return to the grid page ? Or can I create one dataset and then keep adding to it by running the stored procedure for each customer ?
|
|
|
|
|
Yes, you can insert your data to one dataset for each stored procedure query.
However, making several round trips to your database and adding one record at a time to a dataset doesn't sound like the best usaged of resources if you have several customers to display. Why don't you let the database gather your data in one trip via your storaged procedure!
|
|
|
|
|
Hello,
Can tell me which is the best for sql server performance set rowcount 500 or select top 500 records.
500 is the number of records for select.
Best Regards,
S Kumar
|
|
|
|
|
Dunno if this helps...
"You may have heard of a SET command called SET ROWCOUNT. Like the TOP operator, it is designed to limit how many rows are returned from a SELECT statement. In effect, the SET ROWCOUNT and the TOP operator perform the same function.
While in most cases, using either option works equally efficiently, there are some instances (such as rows returned from an unsorted heap) where the TOP operator is more efficient than using SET ROWCOUNT. Because of this, using the TOP operator is preferable to using SET ROWCOUNT to limit the number of rows returned by a query."
Not my work but quoted from...
http://www.sql-server-performance.com/transact_sql_select.asp[^]
I've always used the TOP command myself. Better stick to that.
|
|
|
|
|
SET ROWCOUNT xxx operates on all transactions, so if you set it ALL queries running in the database at that time will be limited to 500 rows. This is most likely undesirable.
|
|
|
|
|
Hi,
I will not put database level, in sps I am using Set rowcount xxx and at last set rowcount 0.
Best Regards,
S Kumar
|
|
|
|
|
how can i represente a row in a numerical field in a star coordinate(1 star/row)
please help
|
|
|
|
|
how can i represente a row in a numerical field in a star coordinate(1 star/row)
please help
|
|
|
|
|
What exactly is a "star coordinate"?
--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters
|
|
|
|
|
it is a king of graph representation to represent numerical values in a graph form
|
|
|
|
|
MAYKY wrote: represent numerical values in a graph form
What development environment are you using to create the application in which you plan to display the graph?
What exactly is the data in each row?
What exactly is the graph suppose to look like?
--EricDV Sig---------
Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them.
- Laurence J. Peters
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
