In this article, you’ll learn how to create a view and table based on a select statement. -~ To create a viewCREATE VIEW Emp_View ASSELECT Ename,
Category: SQL Server
An alternative to ISNULL() and NVL() functions in Hive
The NVL() function enables you to substitute null for a more relevant alternative in the query results. This function accepts two arguments. If the first
TOP, LIMIT, ROWNUM vs DENSE_RANK
What would you do if you were asked to identify top-ten products based on their prices? In SQL Server, using a TOP clause with a
Get Table Row Count And Used Size
The following query will help you in checking the total number of rows and the size of the table(s). SELECTs.Name AS SchemaName,t.Name AS TableName,p.rows AS
Last Modified Date – Stored Procedure
Usually, several stored procedures will be provided to DBAs to deploy in the Production environment. Some of the existing stored procedures need to be replaced
Import from Excel – Named Sheet
This article is to let you know how to import Excel data into SQL Server. First of all download a set of components i.e OLE
Big Data & SQL 