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 |
|
jdizzle
Starting Member
1 Post |
 Posted - 2009-06-04 : 15:19:47
|
| I want to see the actual SQL sent to the database for EVERY delete on a specific table. I don't care about any other SQL.A trigger we have on a table is tell me that we are getting unexpected deletes on that table periodically. I am hoping that reviewing the Actual SQL will help me track the source because we comment all of our sql. Thanks for your help |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
HaniaGueiros
Starting Member
3 Posts |
Posted - 2009-06-05 : 08:28:28
|
| Hello all,My question is about SQL Server 2005.I was wondering if it was at all possible to creat a field in a table which "gets" a value for other field from the same table.For example: Table Studentfield BDT (birthdate - mm/dd/yyyy) field BYM (birthyearMonth - yyyymm)I want to insert the birthdate field (BDT) and the field birthYearMonth (BYM)automatically will receive the Value from BDT.I hope this isn't confusing. Just wondering if this is possible.Thank you!Hania Christina GueirosHania Christina Gueiros |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
tracking SQL, SQL Server 2005