Interested to Buy Any Domain ? << Click Here >> for more details...
How To Find That One Week Change in My DataBase we Have Done
Like We Have A database Test I Change Table,Stored Procd.
Then I Find Which SP,Table We Have Edit/Change in Seven
Dayes
- 1 Answers
- 4446 Views
- INDUS, I also Faced
- E-Mail Answers
Answer / sandeep modapathi
just run this query
SELECT * FROM SYS.OBJECTS
WHERE TYPE='P' AND (CREATE_DATE>'<Date>' OR
MODIFY_DATE>'<Date>')
This query will return all the SPs modified or created
after the date specified. You can change the filter
condition according to your purpose.
For Tables ... use this query
SELECT * FROM SYS.TABLES
WHERE CREATE_DATE>'<Date>' OR MODIFY_DATE>'<Date>'
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain forward - only cursors?
What is the difference between implicit and explicit transaction?
What is update locks?
what is victor class
how can ur insert the emp table
What are the disadvantages of indexes?
What is a join and their types?
2 Answers Challenger Financial,
What is the command to change the recovery model?
What is a data collection table?
What do you understand by the analysis services in sql server?
How can you set the threshold at which sql server will generate keysets asynchronously?
HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY IN EMP TABLE
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
