PL/SQL Block Program written in PL/SQL language as divided into blocks.Block are basic programming...
Author - shohal
Language
Language Here you Can find Oracle, SQL,PL/SQL,ASP.NET Programming Languages.
SQL Server Interview Questions on Indexes – Part 2
SQL Server Interview Questions What are the disadvantages of an Index? There are 2 disadvantages of...
SQL Server Interview Questions on Indexes – Part 1
SQL Server Interview Questions What is the use of an Index in SQL Server? Relational databases like...
Built in string functions in sql server 2008
Built in string functions in sql server 2008 Functions in SQL server can be broadly divided into 2...
Basic SQL Server Interview Questions
Basic SQL Server Interview Questions Explain DML, DDL, DCL and TCL statements with examples? DML:...
What is sp_depends in SQL Server?
What is sp_depends in SQL Server? sp_depends is a system stored procedure that displays information...
Replicate, Space, Patindex, Replace and Stuff functions
Replicate REPLICATE(String_To_Be_Replicated, Number_Of_Times_To_Replicate) – Repeats the...
Sequence object in SQL Server 2012
Sequence object in SQL Server 2012 what is sql sequence? A sequence is a user-defined schema bound...
Scalar User-Defined Functions in SQL Server
User-defined functions. In short UDF. We will cover1. User Defined Functions in sql server2. Types...