I am attempting to document a sql server 2000 based accounting system.
Is there any way to see what tables a stored procedure affects
without diving into the code?
"Tyler Hudson" <ty****@allpax.com> wrote in message
news:80*************************@posting.google.co m...
I am attempting to document a sql server 2000 based accounting system. Is there any way to see what tables a stored procedure affects without diving into the code?
Regards,
Ty
You can try sp_depends, although it may not be completely accurate,
depending on the order in which objects were created.
Hello, I not sure if this is the right place to ask this... I am using
mysql.
What I need is a SQL statement that can find what years are in the
database that is greater than last year.
For...
Hello,
If I run an action SP from MS Access using ADO:
...
cmd.execute
where the SP is something like Create...
Update tbl1 set fld1 = 'something' where...
how can I retrive the count of...
Timings... sometimes there are almost too many ways to do the same thing.
The only significant findings I see from all the below timings is:
1) Integer math is generally fastest, naturally....
Hi there
Situration :- One of the servers disk drive is very "dodgy" - decided
to move folders for databases from 1 server to another. I hardcore
the letter of drives - as fixed - e.g. V:\ used...
i use this code to get data into dataset
cmd.CommandType = CommandType.Text
cmdUpdate.CommandType = CommandType.Text
cmdUpdate.CommandText = "Update BigOne Set Rezultat=? where ID=?"
...
by: Bob Vlad via DotNetMonster.com |
last post by:
What I am trying to do is wipe information from a number of tables after
submission to a SQL server database. Of the 6 tables I am trying to wipe I
have had no issues with 5 of them. Multiple...
I've found that for IE6+, if you add the property text-align:center to a
DIV, then *anything* inside it gets centered. That can be a table, an
object/embed, another DIV, an image, or some text.
...
Hi,
Regarding : OracleCommand.ExecuteNonQuery()
Lets say I want to delete a record from a table and this deletion triggers other deletions from other tables.
So, does the number of rows...
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...