Interview Questions – Section 4

WCF: 1. Different types of binding and their uses. 2. security configuration in WCF. 3. Transport level security with message credentials. https://msdn.microsoft.com/en-us/library/ms731884(v=vs.110).aspx https://msdn.microsoft.com/en-us/library/ms789011(v=vs.110).aspx 4. How to enable HTTPS. 5. How to register SSL certificate with X.509 in config file. 6. Different configuration of WCF in config file. 7. Different types of contract and their uses.… Continue reading Interview Questions – Section 4

GO, OFFSET and FETCH clauses & PAGING in MS SQL

GO: GO { integer_constant} GO will execute the related sql commands n times. INSERT INTO mytable DEFAULT VALUES GO 10 The above will insert 10 rows into mytable. OFFSET: OFFSET { integer_constant | offset_row_count_expression } { ROW | ROWS } Specifies the number of rows to skip, before starting to return rows from the query… Continue reading GO, OFFSET and FETCH clauses & PAGING in MS SQL