In order to know which procedures, functions, and triggers exist in the database, the following queries can help you to find this out.: The below
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
SQL Server – Insert Data From Linked Server Table
In a situation where Servers are linked, it is possible to retrieve data from a table in one server to a table on the other
SQL Server – Self Joins
To join tables, at-least two tables are required. This does not indicate two different tables. It is possible to join a table with itself to
SQL Server – Date Time Functions
Here are a few examples of functions that can help you manipulate DATE in different manners. These will comprise most of your daily job routines.
SQL Server – CHARINDEX – Oracle INSTR
There is a ‘CharIndex’ function in SQL Server which is similar to the Oracle ‘Instr’ function. In Oracle, the syntax of the INSTR function is
SQL Server – List Out Number of Rows from all tables
To Find-Out Number Of Rows In Each Table In Database. METHOD-1 DECLARE @TotalRows INT, @FirstID INT, @table VARCHAR(255), @cmd VARCHAR(500) CREATE TABLE #tableData (TableName VARCHAR(255),
Big Data and SQL 