EC Info System 2

What is use of CTE

Ans : https://interview-preparation-for-you.blogspot.com/2018/04/cte-sql-server.html

In which view we can not use DML statement

Ans : Complex View Contains Multiple Tables Data hence it is not possible to perform DML command on this view.

What is delayed execution

Ans :  https://interview-preparation-for-you.blogspot.com/2018/05/deferred-execution-or-delayed-execution.html

Where we have to create control in ASP .net so that it's view state would maintain

How to initiate printing action in ASP .net asynchronously

How to update database from data set?
Ans using Update method

What is other use of data adoptor other than fill data set.
Ans you can run queries with data adaptor.

What design pattern you see in ATM?
Ans. Abstract Factory while selecting account and chain responsibility while withdrawing money for selecting the note.

What is materialized view ?

Ans : https://interview-preparation-for-you.blogspot.com/2021/06/materialized-views.html

What is index view?

Ans : https://interview-preparation-for-you.blogspot.com/2021/06/indexed-view.html

How to extract date part from datetime string?
Ans cast the string in date type
Convert(date, getdate()).

What is the use of GetDate()?
Ans gives the current date time

What is lambda expression how to use it?