tag:blogger.com,1999:blog-6082652835152798567.post1943151134174502933..comments2024-03-28T21:41:58.974-07:00Comments on Sql server, .net and c# video tutorial: Instead of delete trigger - Part 47Unknownnoreply@blogger.comBlogger4125tag:blogger.com,1999:blog-6082652835152798567.post-24022276628962364702015-12-04T00:35:29.369-08:002015-12-04T00:35:29.369-08:00Hi,venkat..join will give better performance compa...Hi,venkat..join will give better performance comparing to subquries..please can you explain with an example.Anonymoushttps://www.blogger.com/profile/10118995593537869950noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-50151833258380344982015-05-13T03:38:14.118-07:002015-05-13T03:38:14.118-07:00Hi Shaolin Tourist
When using the Delete command i...Hi Shaolin Tourist<br />When using the Delete command in Tsql 'from' is optional, it is simply the same as saying Delete * From tablename. So that satement is the same as Delete * From tblEmployee Join deleted on tblEmployee.Id=deleted.Id <br />This link shows that 'from' is an optional key word in the delete command syntax in tsql<br />https://msdn.microsoft.com/en-us/library/ms189835.aspxAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-10289780781850139532015-02-19T07:19:29.846-08:002015-02-19T07:19:29.846-08:00Hi venkat , Can u please upload the Jquery Tutorai...Hi venkat , Can u please upload the Jquery Tutorails and Web API'sAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-60058469243973845632014-02-24T06:15:56.689-08:002014-02-24T06:15:56.689-08:00Hi Venkat,
The syntax is a little different from...Hi Venkat, <br /><br />The syntax is a little different from the standard delete statement ... could you explain the logic for the delete tbl from tbl please? The subquery version I understand.<br /><br />Delete tblEmployee from tblEmployee<br /> join deleted on tblEmployee.Id = deleted.Id<br /> Shaolin Tourist Monk(ey)https://www.blogger.com/profile/04760107832714644218noreply@blogger.com