tag:blogger.com,1999:blog-6082652835152798567.post7407492751253656759..comments2024-03-28T21:41:58.974-07:00Comments on Sql server, .net and c# video tutorial: IIF function in SQL ServerUnknownnoreply@blogger.comBlogger8125tag:blogger.com,1999:blog-6082652835152798567.post-6617419273470813272020-05-22T06:28:10.448-07:002020-05-22T06:28:10.448-07:00Can you please create a video using IFF or IF in U...Can you please create a video using IFF or IF in UPDATE query?<br />It will be a big help.<br />Thank youAnonymoushttps://www.blogger.com/profile/03133333124047118643noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-35502504513579195292019-07-04T20:31:55.911-07:002019-07-04T20:31:55.911-07:00Venkat; You are a real gift from God, the Mighty. ...Venkat; You are a real gift from God, the Mighty. I have never seen a real generous knowledge source like you. Thank you stay blessed. Ayenoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-8556467496587042312018-03-31T04:03:56.443-07:002018-03-31T04:03:56.443-07:00THE main difference in between Truncate and Delete...THE main difference in between Truncate and Delete is:<br />in case of delete we can use rollback stateent the data <br />but in case of truncate it's not possible to use rollback the data.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-77589635978249001942016-10-10T04:49:23.926-07:002016-10-10T04:49:23.926-07:00Truncate:Delete all Rows from Table
Truncate tabl...Truncate:Delete all Rows from Table<br /><br />Truncate table tablename<br /><br />Delete:Delete Row BY Row From Table Or You Can Also Delete All Row From Table<br /> Delete from tblename<br />delete from tablename where id=1<br /><br />Drop:Delete Table Schema Means Delete<br />drop table table nameAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-91001797386509461562016-01-19T04:08:12.933-08:002016-01-19T04:08:12.933-08:001:Drop is DDL Command
2:Drop is used fro drop the ...1:Drop is DDL Command<br />2:Drop is used fro drop the tableAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-1111956040151153412016-01-19T04:06:34.225-08:002016-01-19T04:06:34.225-08:001:Truncate is DDL Command where as Delete is DMl C...1:Truncate is DDL Command where as Delete is DMl Commant.<br />2:Delete command can be delete all or selected data from a table with where condition where as Truncate delete the all data from a table and we can use filter criteria in truncate.<br />3: Truncate is much faster than delete command<br />4:Trunacte command reset the identity column where as delete command cant be reset the identity column.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-5929985149989878162015-10-15T03:47:23.793-07:002015-10-15T03:47:23.793-07:00What are difference between Truncate and Delete an...What are difference between Truncate and Delete and Drop in SQL Server ?Anonymoushttps://www.blogger.com/profile/10599328314455512537noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-8666201192071196172015-10-15T03:20:19.216-07:002015-10-15T03:20:19.216-07:00Hi Venkat sir,
Can you upload videos on SQL Jobs?...Hi Venkat sir,<br /><br />Can you upload videos on SQL Jobs?<br /><br />Thank you!Anonymousnoreply@blogger.com