mayuri budakeVIEW IN SQL SERVERView is a virtual table based on the result-set of an SQL statement.Jan 2, 2020Jan 2, 2020
mayuri budakeSQL Interview QuestionsQ.1. Write a SQL query to fetch the count of employees working in project ‘P1’. Ans. Here, we use aggregate function count() with the SQL…Dec 30, 2019Dec 30, 2019
mayuri budakePATINDEX FUNCTION IN SQL· The PATINDEX() function returns the starting position of the first occurrence a pattern in a string.Dec 30, 2019Dec 30, 2019
mayuri budakeColumn Store IndexA columnstore index is a technology for storing, retrieving, and managing data by using a columnar data format .Dec 12, 2019Dec 12, 2019