Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
manu
Starting Member
41 Posts |
 Posted - 2006-04-03 : 04:15:59
|
| How to get information , if there is no insertion of a row in a table within particular span of time. |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-04-03 : 04:44:14
|
| There is no direct way to get.. you need to have column in the table called lastmodifieddatetime and set it default property to currentdate or GetDate() and then using query you can find out the same....If Debugging is the process of removing Bugs then i Guess programming should be process of Adding them. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-04-03 : 04:53:02
|
| Have a datetime column and do query If not exists(select * from table where datecol between date1 and date2)--Doesnt have data for the date rangeMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
About Insertion