Oracle SQL & PL/SQL

SQL, SQL Server, Tutorials, Oracle, PL/SQL, Interview Questions & Answers, Joins, Multiple Choice Questions, Quiz, Stored Procedures, Select, Insert, Update, Delete and other latest topics on SQL, SQL Server and Oracle.

VB .Net Good Books

Programming Microsoft Visual Basic .NET Version 2003 (Book & CD-ROM) by Francesco Balena

Sams Teach Yourself Microsoft Visual Basic .NET 2003 (VB .NET) in 24 Hours Complete Starter Kit by James Foxall

The Ultimate VB .NET and ASP.NET Code Book by Karl Moore

Murach's VB.NET Database Programming with ADO.NET by Doug Lowe and Anne Prince

Programming VB .NET: A Guide for Experienced Programmers by Gary Cornell and Jonathan Morrison

Security for Microsoft Visual Basic .NET by Ed Robinson and Michael James Bond

Professional VB.NET, Second Edition by Fred Barwell, Richard Case, Bill Forgey, and Billy Hollis

C# & VB.NET Conversion Pocket Reference by Jose Mojica

The Book of Visual Basic 2005: .NET Insight for Classic VB Developers

Professional Design Patterns in VB .NET: Building Adaptable Applications by Tom Fischer, John Slater, Pete Stromquist, and Chaur G. Wu

Professional VB.NET 2003, 3rd Edition by Bill Evjen, Billy Hollis, Rockford Lhotka, and Tim McCarthy

Object-Oriented Programming with Visual Basic.NET by Michael McMillan

Learn VB .NET Through Game Programming by Matthew Tagliaferri

Beginning VB.NET Databases by Thearon Willis

The Book of VB .NET: .NET Insight for VB Developers by Matthew MacDonald

Moving to VB .NET: Strategies, Concepts, and Code, Second Edition by Dan Appleman

Beginning Visual Web Programming in VB .NET: From Novice to Professional by Daniel Cazzulino, Victor Garcia Aprea, James Greenwood, and Chris Hart

Build Your Own ASP.NET Website Using C# & VB.NET (Build Your Own) by Zak Ruvalcaba

Mastering Visual Basic .NET by Evangelos Petroutsos

Sams Teach Yourself Object-Oriented Programming with VB.NET in 21 Days by Richard J. Simon, Leslie Koorhan, and Ken Cox

Professional .NET Framework 2.0 (Programmer to Programmer) by Joe Duffy

.NET Programming 10-Minute Solutions by Russell A. Jones

Essential VB .NET fast (Essential Series) by John Cowell

VB.NET Language Pocket Reference by Steven Roman, Ron Petrusha, and Paul Lomax

No comments:

Post a Comment

Newer Post Older Post Home

Subscribe to: Post Comments (Atom)

SQL Server - Multiple Choice Questions

SQL - Multiple Choice Questions

SQL Server, Oracle, SQL & PL/SQL

If you like reading this SQL Server, Oracle, SQL / PLSQL blog, please help increase the blogs' visibility by clicking on the 'g +1' button.

SQL Server / Oracle SQL

sql introduction

SQL Introduction

SQL Syntax

SQL Select

SQL Insert

SQL Update

SQL Delete

SQL Joins

Examples of Joins

SQL Examples of Joins

Explicit vs. Implicit Joins

SQL Explicit vs. Implicit Joins

SQL Group By

SQL Group By Examples

SQL Group By Examples

SQL Having

SQL - IN

SQL - NULLs

Functional Dependencies

Functional Dependencies

Normalization

ACID Properties

ACID Properties

SQL SubQueries

SQL - Queries With Examples

SQL - Queries With Examples

SQL Views

Insert, Update, Delete Views

Insert, Update, Delete Views

SQL Join Views

SQL Inline Views

Nth Highest Salary

SQL - Nth Highest Salary

Second Highest Salary

SQL Second Highest Salary

Difference Truncate / Delete

SQL - Difference Truncate / Delete

Difference Truncate / Drop

SQL - Difference Truncate / Drop

Difference HAVING / WHERE

SQL - Difference HAVING / WHERE

Difference CAST / CONVERT

SQL - Difference CAST / CONVERT

Difference NOT IN / NOT EXIST

SQL - Difference NOT IN / NOT EXIST

SQL - Difference IN / EXISTS

SQL - Difference IN / EXISTS

Difference UNION / UNION ALL

SQL - Difference UNION / UNION ALL

Difference Nested / Correlated Subquery

SQL - Difference Nested / Correlated Subquery

SQL - REPLACE

SQL - TOP

SQL - LIKE

SQL - SELECT INTO

SQL - SELECT INTO

SQL - CREATE TABLE

SQL - CREATE TABLE

SQL - CREATE TABLE

SQL - CREATE TABLE (More Examples)

SQL - ALTER TABLE

SQL - ALTER TABLE

Difference views / Materialized views

SQL - Difference views / Materialized views

SQL Count

SQL Update

SQL Clustered / Non-Clustered Indexes

SQL Clustered / Non-Clustered Indexes

SQL - Delete Duplicate Records

SQL - Delete Duplicate Records

SQL - Difference Unique/Primary Key

SQL - Difference Unique/Primary Key

SQL - GETDATE()

SQL - DATEDIFF()

SQL - DATEADD()

SQL - DATEPART()

SQL - Convert()

SQL - Convert()

SQL - SUM()

SQL - AVG()

SQL - MIN()

SQL - MAX()

SQL - Insert Into Select

SQL - Insert Into Select

Insert Multiple Values In Table

SQL - Insert Multiple Values In Table

Referential Integrity

SQL - Referential Integrity

Not Null Constraint

SQL - Not Null Constraint

SQL - Unique Constraint

SQL - Unique Constraint

Primary Key Constraint

SQL - Primary Key Constraint

Foreign Key Constraint

SQL - Foreign Key Constraint

Default Constraint

SQL - Default Constraint

Check Constraint

SQL - Check Constraint

SQL - ROLLUP

SQL - CUBE

SQL - STUFF()

SQL - Count_Big

SQL - Count_Big

SQL - Binary_Checksum

SQL - Binary_Checksum

SQL - Checksum_AGG

SQL - Checksum_AGG

SQL - Index Include

SQL - Index Include

SQL - Covered Query

SQL - Covered Query

SQL - Identity

SQL - sp_columns

SQL - sp_columns

Difference Local / Global Temporary Tables

SQL - Diff Local/Global Temporary Tables

Stored Procedure

SQL - Stored Procedure

SQL - sp_who

SQL - Session

SQL - Dynamic SQL

SQL Server Execution Plan

SQL - SQL Server Execution Plan

SQL - sp_executesql

Difference Execute/Execute()

SQL - Difference Execute/Execute()

SQL - Case Expression

SQL - Case Expression

SQL - XML Variable Example

SQL - XML Variable Example

SQL - Pivot

Example of SQL Merge

Example of SQL Merge

Example of Merge Output Clause

Example of Merge Output Clause

SQL - Compute / Compute by

SQL - Compute / Compute by

SCOPE_IDENTITY / IDENT_CURRENT / @@IDENTITY

SQL - Diff SCOPE_IDENTITY / IDENT_CURRENT / @@IDENTITY

SQL Coalesce

Import Data into SQL Server Table

SQL - Import Data into SQL Server Table

Delete Duplicate Records in SQL Server Table

SQL - Delete Duplicate Records in SQL Server Table

Check If a Column Exists in SQL Server Table

SQL - Check If a Column Exists in SQL Server Table

Has_perms_by_name

SQL - Has_perms_by_name

SQL - Difference between Logins / Users

SQL - Difference between Logins / Users

Diff between Table Variable/Temp Table

SQL - Diff between Table Variable/Temp Table

SQLServer 2012 features

SQL - SQLServer 2012 features

SQL - SERVERPROPERTY

SQL - SERVERPROPERTY

Find Primary Key / Foreign Key in Table

SQL - Find Primary Key / Foreign Key in Table

SQL - Sequence

Columnstore Indexes

SQL - Columnstore Indexes

Difference Primary / Candidate Key

SQL - Difference Primary / Candidate Key

SQL - Throw - SQL Server 2012

SQL - Throw - SQL Server 2012

Difference GUID / INT

SQL - Difference GUID / INT

SQL Server 2012 Enhancements

SQL Server 2012 Enhancements

Difference between Cross Join / Full Outer Join

SQL - Diff between Cross Join / Full Outer Join

SQL - NTILE()

SQL - Object Dependencies

SQL - Object Dependencies

SQL - Email Reminder on Updating Table

SQL - Email Reminder on Updating Table

SQL - Object Definition

SQL - Object Definition

SQL Server - Report Builder 3

SQL Server - Report Builder 3

SQL Server - User Defined Roles

SQL Server - User Defined Roles

SQL Server - Filetables

SQL Server - Filetables

SQL Server - Contained Databases

SQL Server - Contained Databases

Update from Select

SQL Server - Update from Select

SQL Server - XML Methods

SQL Server - XML Methods

Add a Column to Table

SQL Server - Add a Column to Table

SQL Insert Multiple Rows

SQL Server - Insert Multiple Rows

Add Identity Column to Table

SQL Server - Add Identity Column to Table

SQL Server - Indexes

SQL Server - Indexes

Difference Functions / Stored Procedures

SQL Server - Diff Functions / Stored Procedures

SQL - Comparison Operators Any / All

SQL - Comparison Operators Any / All

Difference Primary / Foreign Key

SQL - Difference Primary / Foreign Key

Difference Replace / Stuff

SQL - Difference Replace / Stuff

SQL - ROW_NUMBER()

SQL - ROW_NUMBER()

SQL - Intersect

SQL - Intersect

SQL Server - Local Variables

SQL Server - Local Variables

Update with Join

SQL Server - Update with Join

Difference Merge / Hash Join

SQL Server - Difference Merge / Hash Join

Difference Update / Exclusive Lock

SQL Server - Difference Update / Exclusive Lock

sql Difference Instance / Database

SQL Server - Difference Instance / Database

Difference Datetime2 / Datetime

SQL Server - Difference Datetime2 / Datetime

Difference Disable / Drop Indexes

SQL Server - Difference Disable / Drop Indexes

SQL Server - Difference Decimal / Float

SQL Server - Difference Decimal / Float

DATEDIFF with Examples

SQL Server - DATEDIFF with Examples

sql Difference Raiserror / Throw

SQL Server - Difference Raiserror / Throw

Check If Column Exists in Table

SQL Server - Check If Column Exists in Table

Query Excel Using Linked Server

SQL Server - Query Excel Using Linked Server

SQL Server - WaitFor

SQL Server - WaitFor

Difference Rank, Dense_Rank & Row_Number

SQL Server - Difference Rank, Dense_Rank & Row_Number

PATINDEX Examples

SQL Server - PATINDEX Examples

COLLATE Examples

SQL Server - COLLATE Examples

Difference CHAR / VARCHAR

SQL Server - Difference CHAR / VARCHAR

SQL Interview Questions

SQL Server - Interview Questions for Testers

SQL Interview Questions

SQL Interview Questions

Difference GRANT / DENY / REVOKE

Difference GRANT / DENY / REVOKE

Subqueries in WHERE clause - Examples

Subqueries in WHERE clause - Examples

How to check indexes on a table?

How to check indexes on a table?

DATENAME examples

DATENAME examples

SQL Join Interview Questions

SQL Join Interview Questions

Oracle PL/SQL

PL/SQL Introduction

PL/SQL Introduction

PL/SQL Procedures

PL/SQL Procedures

PL/SQL Functions

PL/SQL Functions

PL/SQL Collections

PL/SQL Collections

PL/SQL Records

PL/SQL Table Based Records

PL/SQL Table Based Records

PL/SQL Programmer Defined Records

PL/SQL Programmer Defined Records

PL/SQL Cursor Based Records

PL/SQL Cursor Based Records

PL/SQL Tables

PL/SQL Varrays

PL/SQL Nested Tables

PL/SQL Nested Tables

PL/SQL Loops

PL/SQL Triggers

PL/SQL Triggers

PL/SQL Cursors

PL/SQL Implicit Cursors

PL/SQL Implicit Cursors

PL/SQL Explicit Cursors

PL/SQL Explicit Cursors

PL/SQL REF Cursors

PL/SQL REF Cursors

PL/SQL Cursor For Loop

PL/SQL Cursor For Loop

PL/SQL Cursors with Parameters

PL/SQL Cursors with Parameters

PL/SQL Where Current Of and For Update

PL/SQL Where Current Of and For Update

Examples of PL/SQL Cursors

Examples of PL/SQL Cursors

PL/SQL Exceptions

PL/SQL Exceptions

PL/SQL Interview Questions

PL/SQL Interview Questions

SQL PL/SQL Sitemap

SQL PL/SQL Sitemap

SQL Tutorials / Topics

'12/31/2022') AS Result @@IDENTITY @@identity in sql server example @@identity vs scope_identity @local_variable 0) 1NF 2NF 3NF ACID ACID Properties ACID Properties in DBMS Add column in Oracle table sql add column to table oracle add column to table sql add identity column in sql add identity column sql server add identity column to existing table add identity column to existing table oracle ALL_VIEWS Alternate key always encrypted and BCNF Examples and Filtered Index Artificial key atomicity backup and restore backup and restore in sql server Best Practices for Creating Indexes Boolean Expressions Candidate key candidate key sql candidate key vs composite key candidate key vs primary key case expression in sql case statement in select query in sql CAST() change data type of column in oracle change data type of column in sql char char and varchar examples check if column exists check if column exists in table sql check if column exists in temp table sql server Check if Field/Column exists in Table? check indexes on table oracle check indexes on table sql server Checking If a Column Exists in a Table CHOOSE() Clustered and Non-Clustered Indexes clustered columnstore Clustered Index Co-Related Vs Nested-SubQueries COALESCE function in SQL Server COALESCE() COALESCE(col1 Collate Collate Examples column exists in table sql columnstore index Columnstore Indexes columnstore indexes in sql server common table expression in sql Common Table Expressions Comparison Operators sql server Composite Index composite index in oracle composite index in sql Composite Key COMPUTE COMPUTE & COMPUTE BY Clause COMPUTE BY CONCAT() concat() in sql CONNECT BY CONNECT BY BASICS CONNECT BY EXAMPLE CONNECT BY ORACLE consistency consistency of a database contained database in sql server Contained database users Contained Databases correlated subquery COUNT() Covering Index covering index example covering index in oracle covering index in sql server covering index scan create clustered columnstore index CREATE SEQUENCE CREATE TABLE ##GlobalTemp CREATE TABLE #LocalTemp create Temp table create view in sql create XML schema sql server Cross join CTE Data Types in Oracle data types in sql Database files and filegroups Database normalization database user is not the same as a login Date and time Expressions DATEDIFF DateDiff Examples DATEDIFF Oracle datediff sql DATEDIFF() SQL FUNCTION DATEFROMPARTS() Function in SQL Server DATENAME DATENAME Examples datename function in sql datetime2 in sql server datetime2 to datetime datetime2 vs datetime datetimefromparts sql DATETIMEFROMPARTS() DECLARE @tbl TABLE () DECLARE @x xml declare a table variable DELETE FROM Table DELETE FROM table_name Delete With SubQuery deleting duplicate records in oracle deleting duplicate records in sql Dense_Rank Dense_Rank & Row_Number DENY & REVOKE difference between coalesce and isnull with example difference between coalesce() & isnull() Difference between Cross Join and Full Outer Join difference between decimal and float difference between decimal and float in sql difference between decimal and float in sql server Difference Between Drop and Delete Difference Between EXEC and EXECUTE vs EXEC() Difference between EXISTS and IN in SQL difference between full outer join and cross join in oracle Difference between GRANT Difference between Grant and Revoke Difference between isNull & COALESCE difference between local and global temporary tables in sql server Difference between Merge Join and Hash Join difference between merge join and hash join in sql server difference between nested and correlated subqueries Difference between Primary and Candidate Key Difference between Primary Key and Foreign Key Difference Between Rank difference char and varchar difference char and varchar in sql difference char varchar Difference Cross Join Full Outer Join Difference decimal / float difference disable and drop index in sql server Difference RAISERROR and THROW Difference Server Instance / Database difference stored procedure and function disable index sql server disable vs drop index sql server drop column in sql example drop index drop index in oracle drop index in sql server drop index sql DROP TABLE drop unique index durability Dynamic Data Masking dynamic data masking in sql server Dynamic SQL Dynamic SQL in Oracle Dynamic SQL in sql server Dynamic SQL is a SQL built from strings at runtime eomonth sql EOMONTH() Examples of Joins Examples of Joins Oracle Examples of Joins SQL Examples of NTILE() Exception Handling in PL/SQL EXCEPTION WHEN NO_DATA_FOUND THEN NULL exclusive lock in sql exclusive lock in sql server example exclusive lock vs update lock EXEC and EXECUTE EXEC Command EXEC msdb.dbo.sp_send_dbmail EXEC sp_who EXEC sp_who2 EXEC VS SP_EXECUTESQL EXEC vs SP_EXECUTESQL in SQL Server Execute a stored procedure Execution Plans in SQL Server exist sql exists sql oracle exists sql vs in FETCH FIRST 10 ROWS ONLY FileStream vs FileTable filetable sql server example Find Foreign Key find indexes on table Find primary key Foreign key FORMAT Function in SQL FORMAT SQL Server FORMAT() full outer join vs cross join Full-Text Index fully contained database Functional Dependencies Functional Dependencies DBMS functional dependencies examples functional dependencies in normalization getdate in oracle getdate sql server Global Temporary Tables GUID has_perms_by_name HAS_PERMS_BY_NAME returns 1 Hash Join hash join example hash join in dbms hash join in oracle hash join in sql hash join vs merge join HAVING COUNT (*) > 1 Hierarchical Queries How can I remove duplicate rows? how to check column exists in table in oracle How to check if a column exists in a SQL Server table How to find all the dependencies of a table How to find all the dependencies of a table in sql server How to order by with union in SQL? How to transpose columns to rows in SQL? How to use CONCAT() how to use datename in sql how to use index in sql server Identifying Object Dependencies in SQL Server identity column identity column in oracle identity column in sql IFNULL() IIF() IIF() Function import an Excel file into SQL Server Import Data into SQL Server Table Incorrect statement near 'THROW' index column by column indexed views Indexed views improve the performance of queries indexed views in oracle indexed views in sql server indexes indexes in sql indexes on table indexes on temp tables indexes on views INFORMATION_SCHEMA Information_schema.COLUMNS inner join insert multiple rows in oracle insert multiple rows in sql server insert triggers Interview Questions SQL isnull and coalesce difference ISNULL() isolation Join Hints join hints in sql server join hints oracle JOIN Interview Questions JOIN ON CASE Joining multiple tables in SQL joins joins in sql JOINS Interview Questions know indexes on a table Left join LEFT() LIKE SQL Server list all columns in a table sql query Local temporary tables locking in sql locks in sql server query Login grants entry into the SERVER Loops in Oracle PL/SQL MAX() MERGE INTO Merge Join merge join example merge join in dbms merge join in sql merge join in sql server Merge SQL MIN() ms sql server instance vs database msdb.dbo.sp_send_dbmail multiple Candidate Keys Multiple Choice mysql join hints natural join Nested Queries in SQL NEWID() non-clustered columnstore index Non-Clustered Index Normal Forms in DBMS Normalization normalization in dbms normalization in sql NTILE () NTILE() function in SQL Server NULLIF Numeric Expressions NVL() OBJECT_DEFINITION(object_id) OFFSET clause skips One Login can be associated with many users oracle common table expression oracle data types ORACLE NULLIF Oracle SQL oracle sql case expression oracle sql data types oracle sql joins ORACLE SQL NULLIF ORDER BY ORDER BY DESC OFFSET 0 ROWS FETCH NEXT 20 ROWS ONLY OUTER JOIN OUTPUT clause SQL Server PARSE() Partially Contained Databases patindex patindex in Oracle patindex in sql server Pivot and Unpivot in SQL pl sql loop cursor PL/SQL - Loops PL/SQL Exception Handling PL/SQL Exceptions PL/SQL Loops PL/SQL Loops examples Primary key Primary Key vs Foreign Key primary vs candidate key Query Execution Plan in SQL Query to check index on a table quickest way to get your Excel file into SQL raise error in Oracle raise error in sql server raise error vs throw in sql server RAND() Rank read analyze SQL Server execution plans RECURSIVE QUERY Remove Duplicate Data in SQL Report Builder Report Builder 3.0 Report Builder 3.0 for SQL Server 2012 restore in sql server revoke vs deny : what is the difference row level security row level security in sql server Row_Number ROW_NUMBER() ROWNUM SCOPE_IDENTITY() SCOPE_IDENTITY() with sp_executesql SELECT @guid as 'GUID' select cast(dbo.parseSqlToXml(@sql) SELECT CHOOSE() select datefromparts() SELECT EOMONTH () select has_perms_by_name() SELECT IIF() SELECT OBJECT_DEFINITION(object_id) From sys.objects SELECT ROW_NUMBER() SELECT TRY_CONVERT(DATETIME2 SELECT TRY_PARSE('01-Jan-0001' AS datetime2) SELECT TRY_PARSE() self join self join examples self join questions self join sql Sending mail when a table is updated sequence in oracle sql sequence in oracle with example sequence object in oracle sequence object in sql sequence objects in sql server Server-level roles SQL Server SERVERPROPERTY( 'ServerName' ) SESSION_USER sp_executesql sp_executesql sql server sp_executesql uses parameter values sp_who sql sp_who sparse columns sparse columns in sql server SQL sql all sql always encrypted sql always encrypted c# sql always encrypted connection string sql any sql any and all sql backup and restore sql Binary Data Types sql Boolean Data Types sql candidate key SQL CASE sql case expression sql case expression in where clause SQL CASE Statement sql case statement in join sql cast sql cast and convert sql cast and convert difference sql cast function sql cast varchar to int sql cast vs convert sql Character and String Data Types SQL Choose() SQL CHOOSE() Function SQL COALESCE sql coalesce vs isnull sql columnstore index sql columnstore index example SQL Common Table Expression sql comparison operators sql composite key SQL COMPUTE SQL COMPUTE BY sql concat SQL CONCAT() SQL CONNECT BY sql convert sql convert() SQL Correlated Subqueries sql create composite index SQL CREATE TABLE Statement SQL CTE SQL Data Types sql data types with examples sql database and instance sql Date and Time Data Types SQL DateDiff SQL DATENAME sql datetime sql datetime2 SQL DATETIMEFROMPARTS() SQL decimal / float difference sql declare local variable SQL Delete SQL DELETE JOIN sql delete statement sql delete statement with join sql delete with join sql deny vs revoke SQL Difference Between Login Vs User sql drop column sql drop index sql drop index if exists SQL DROP TABLE SQL DROP TABLE and TRUNCATE TABLE Keywords sql eomonth start of month SQL EOMONTH() SQL Excel Linked Server SQL EXEC sql Execution Plan sql execution plan in sql server SQL EXISTS & IN SQL Expressions SQL Fetch sql filetable sql filetable vs filestream SQL FORMAT() sql function vs stored procedure sql functions SQL Functions with Examples sql get table columns SQL GRANT sql grant and revoke sql grant command sql grant statement sql grant syntax sql group by sql group by having sql group by having count SQL GROUP BY Statement SQL GUID SQL HAS_PERMS_BY_NAME sql having SQL IDENT_CURRENT() Function SQL Identity Column Questions sql iif null SQL IIF() SQL Inbuilt Functions sql index types SQL Insert SQL Insert and Update sql insert into select statement SQL INSERT INTO Statement sql insert statement sql insert statement with multiple values sql insert vs update sql intersect sql intersect and union sql intersect example sql intersect operator sql intersect vs inner join SQL Interview Questions SQL Join SQL JOIN Interview Questions sql join multiple tables SQL Join Questions SQL Join Questions & Answers sql joins SQL Joins & Nulls sql joins interview questions sql joins practice sql joins practice questions sql joins questions sql joins with examples SQL Keys SQL LIKE Operator sql like query SQL LIKE Statement sql like wildcard sql local table sql local variable in select sql local variable types SQL Local Variables sql locks on table SQL Merge sql merge example sql merge example oracle sql merge on multiple columns sql merge output sql merge output clause sql merge statement sql merge statement example sql merge with where clause sql normal forms SQL Normalization sql normalization forms sql normalization rules sql ntile function sql ntile() SQL NULL sql null functions SQL NULLIF sql nullif vs isnull sql Numeric Datatypes SQL Offset SQL ORDER BY sql order by multiple columns sql order by practice questions sql order by two columns SQL PARSE() SQL PARSE() Function sql parser SQL patindex SQL PIVOT SQL PL/SQL Interview Questions sql primary key sql primary key and foreign key sql primary key vs foreign key SQL Query to convert rows to columns SQL Query to Delete Duplicate Rows SQL Query to Insert Multiple Rows sql replace sql replace vs stuff SQL Row Level Security sql ROW_NUMBER() sql row_number() function sql rowcount sql self join sql sequence sql sequence example sql sequence object SQL Server - WAITFOR sql server - WAITFOR DELAY and PRINT statement SQL Server 2012 features sql server 2012 new features SQL Server Backup & Restore SQL Server Collate SQL Server Collation Examples SQL Server Columns to Rows SQL Server CONCAT() Function SQL Server Contained Databases Sql server convert datetime to sql server date sql server date conversion sql server dateadd sql server datediff SQL Server DATEDIFF() Function SQL Server DATENAME() Function SQL Server DATEPART() Function sql server datetime sql server ddm sql server dynamic data masking SQL Server end of month SQL Server Exclusive Lock sql server filegroup sql server files and filegroups sql server files location SQL Server FORMAT() Function SQL Server IIF() Function sql server index sql server index creation best practices sql server indexed view SQL Server Indexed Views SQL Server Indexes SQL Server Indexes best practices SQL Server INSERT Multiple Rows sql server instance vs database SQL Server Interview SQL Server Interview Questions SQL Server Linked Server sql server linked server query sql server linked server to oracle sql server lock query sql server lock types SQL Server Locks SQL Server MERGE sql server OBJECT_DEFINITION SQL Server OFFSET FETCH sql server permission levels SQL Server Permissions SQL Server PIVOT SQL Server Questions SQL Server Questions Answers sql server replace vs stuff SQL Server Roles sql server roles and permissions SQL Server Row Level Security sql server select top syntax SQL Server Sequence Objects sql server serverproperty SQL Server SESSION_USER Function SQL Server SOUNDEX() Function SQL Server sparse columns SQL Server Table Columns SQL Server Table Variable sql server top clause SQL Server Transpose rows to columns SQL Server TRY PARSE() Function SQL Server Update Lock sql server user defined server roles sql server vs instance SQL Server Window Functions sql server window functions examples SQL SERVERPROPERTY sql serverproperty all sql session sql session kill query sql session query sql session variables SQL sparse columns sql Special Data Types sql stored procedure and function sql stored procedure example sql stored procedure practice exercises sql stored procedure vs function sql stored procedures sql stuff SQL Subqueries SQL Subquery sql subquery examples SQL Tables sql temp table sql temp table vs cte sql temp table vs table variable sql tempdb sql temporary tables SQL Truncate sql truncate function sql truncate vs delete sql truncate vs drop sql try convert vs cast sql try_convert date format SQL TRY_CONVERT() SQL TRY_PARSE() SQL Union sql union all sql union distinct sql union examples sql union vs union all sql update sql update from select sql update multiple columns sql update with join sql view types SQL Views sql views examples sql where 1=1 SQL Where Clause sql where clause with multiple values sql where date = today sql where in sql where not null sql where vs having sql wildcard in statement sql wildcard in where clause sql wildcard not like SQL Wildcard Questions sql wildcards sql window functions sql window functions interview questions sql window functions practice sql xml sql xml nodes sql xml path sql xml query sql XML Schema Collection sql xml to table sql xml value stored procedure Stored Procedure in SQL Server stored procedures stored procedures in oracle stored procedures in sql STUFF() And REPLACE() In SQL Server subqueries subqueries examples subqueries in where Subqueries in WHERE Clause subquery subquery in sql Super Key syntax for COALESCE table columns table columns in oracle table columns in sql server Temporary Tables And Table Variables In SQL Temporary Tables in SQL Server The OUTPUT Clause for the MERGE Statements The SQL DELETE Statement THROW 51000 'ERROR' 1 throw in sql THROW SQL Server TOP SQL Server transaction TRANSPOSE COLUMNS TO ROWS transpose rows to columns in Oracle transpose rows to columns in sql truncate in sql truncate table TRUNCATE TABLE Oracle Truncate tables TRY_CONVERT() try_parse in sql server TRY_PARSE() Types of Functional dependencies in DBMS types of joins types of subqueries in sql Understanding the SQL MERGE statement union all union all example union all in oracle union all in sql union all vs union Unique Index unique index oracle unique index sql server Unique Indexes unique indexes in sql update from select update from select join update from select oracle update triggers update with join in oracle update with join in sql update with join in sql server Use THROW to raise an exception User grants a login into single DATABASE using Pivot in SQL Server Using sp_who varchar View dependencies of a table views in oracle sql waitfor delay sql server waitfor in sql server Ways to Import CSV File to SQL Server ways to transpose columns and rows in SQL what is a contained database What is Temporary Table in SQL? Why & When should I use SPARSE COLUMN Writing Subqueries in SQL xml data type example xml data type in oracle xml data type in sql XML data type variables columns xml data types XML Variable sql

Powered by Blogger.