Saige Blog

What is JavascriptJavaScript is a dynamic computer programming language. It is lightweight and most commonly used as a part of web pages, whose implementations allow client-side script to interact with the user and make dynamic pages. It is an interpreted programming language with object-oriented capabilities. console.log(document.querySelector(“#username”).value) Client-side JavascriptClient-side JavaScript is the most common form of the language. The script should be included in or referenced ...

Subqueries Introduction to Subqueries Using a Subquery as a Derived Table Using a Subquery as an Expression Using a Subquery to Correlate Data Using EXISTS and NOT EXISTS Working with Objects Creating Objects Altering Objects Renaming Objects Dropping Objects Data Integrity Entity Integrity Referential integrity Different Constraints SQL Server Day 3 Assignment TriggerWhat is Trigger? What types of Triggers are there?A trigger is a special type of stored procedure that automatically runs when an ...

PreviewSubqueries● Introduction to Subqueries● Using a Subquery as a Derived Table● Using a Subquery as an Expression● Using a Subquery to Correlate Data● Using EXISTS and NOT EXISTS Working with Objects ● Creating Objects● Altering Objects● Renaming Objects● Dropping Objects Data Integrity● Entity Integrity● Referential integrity● Different Constraints● SQL Server Day 3 Assignment AssignmentJoins inner join, outer, cross What is View? What are the benefits of using views?View is a virtual ta ...

PreviewWorking with Subqueries● Introduction to Subqueries● Using a Subquery as a Derived Table● Using a Subquery as an Expression● Using a Subquery to Correlate Data● Using EXISTS and NOT EXISTS Working with Objects ● Creating Objects● Altering Objects● Renaming Objects● Dropping Objects Data Integrity● Entity Integrity● Referential integrity● Different Constraints● SQL Server Day 3 Assignment AssignmentJoins inner join, outer, cross What is View? What are the benefits of using views?View is ...

Result Set Result set is a set of data, could be empty or not, returned by a select statement, or a stored procedure, that is saved in RAM or displayed on the screen. A result set is a set of records, including not only the data itself, but also metadata like column names, types and sizes. A TSQL script can have 0 to multiple result sets. Use the following command can export the result set into file. ​ sqlcmd -i c:\sql\myquery.sql -o c:\sql\myoutput.txt UNION, UNION ALL, Other SET Oper ...

Modifying DataUsing TransactionsInserting DataUpdating DataDeleting DataTruncatePerformance Considerations Programming ObjectsStatementsViewsStored ProceduresFunctions (User Defined & System Defined)Trigger SQL Server Day 4 Assignment ViewWhat is View? What are the benefits of using views?View is a virtual table whose contents (columns and rows) are defined by a query. In a database, a view is the result set of a stored query on the data, which the database users can query just as they would ...

General ConceptsDatabase definitionOrganized collection of logically related data DataKnown factsTypes: text, graphics, images, sound, videos Database management system (DBMS)Software package for defining and managing a database. Examples:Proprietary: MS Access, MS SQL Server, DB2, Oracle, Sybase Open source: MySql, PostgreSQL Relational database and non-relational database Types Of DBMS With respect to the need and requirement of users in industry, different types of Database Management System ...

SQL Server ReplicationReplication is a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency. SQL Server Account Service Account Name SQL Server Agent NT Service\SQLAgent$ANTRA SQL Server Database Engine NT Service\MSSQL$ANTRA SQL Server Browser NT AUTHORITY\LOCALSERVICE NT_AUTHORITY essentially refers to the Windows operating system itself. Or perhaps as “things the OS ...

Antra Interview ExperiencePart I First Interview12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364import java.io.*;import java.util.*;class MyCode { /** * 1. Question: Why the amap size is 3? Instead of 4 even though we called put() method 3 times * Answer: * In the main method we only create 3 new objects , even we set a2 = a , they are the same object so the size is 3 * 2. Fixed the code(Apple clas ...

DevianceWhat exactly is deviance, and where is the line between deviance and nondeviance? Many people would likely express the absolutist view that certain things are deviant in all places, for all groups, and at all times (Little 2007). However, from a sociological perspective, no act, belief, or human characteristic is inherently deviant (Perrin 2007). Thus, even genocide, while morally reprehensible and indefensible, has not been defined as deviance in some societies and at certain points in ...