I have a table in orcale database where I am inserting records. I am able to insert a record in a table but it is not being saved permenantly.When inserting there is no error. what could be causing this?
View Complete Post
Is there any direct equivalent concept of Oracles ,ROWID in SQL Server. As you might be knowing that ROWID is the unique hex number given to each record of a table in Oracle. The column is not added explicitly , automatically it will come ..
and we can do certain queries using ROWID ..
Please let me know ,is there any equal concept in SQL Server. I verifyied , NEWID(),GUID() ... etc concepts ..
NOTE: I don't want to add the column to the table EXPLICITLY ...
Please let us know if there is any ALTERNATE way ...
Thans in advance
I have a reports table with column report id and and report version. I created a trigger on this table to execute an application to do some processing each time a row is inserted in reports table. I need to pass the new report id execute this application from the trigger. How do I get the report id from the row that was inserted?
Julie Lerman shows database administrators how to limit access to databases from the Entity Framework by allowing it to work only with views and stored procedures instead of tables-without impacting application code or alienating developers.
MSDN Magazine August 2010