Stored Procedures

 

 

 

 

 

SQL Identity Key ,T-SQL

Microsoft SQL Server?s identity column generates sequential values for new records using a seed value. Seeding and reseeding an identity column is easy and relatively safe, if you do it correctly. Susan Sales Harkins shows you how it works.

 

Real Life AI projects

Success Hacks

LICT .NET Training | Kamal Protap Sir

DDL – Data definition Language(Which deals with database schemas and descriptions that how the data should reside in database) – create,alter,drop, truncate, comment
DML – Data manipulation language(Modify, Update, Delete data in database) – select, insert, update, delete
DCL – Data Control Language(Regarding the rights of the database)  grant,revoke

 

31-10-17 vids

SQL Query

SQL Aggregate functions, slides presentation: This presentation describes SQL Aggregate function covering SQL COUNT(), SUM(), MAX(), MIN(), AVG) functions with examples.

SubQuery:

A query within another query is called subquery or nested query . Inner Query, Outer query is in subquery.

Sub Query are two types they are, co-related sub query and non co-related subquery. They works for both DDL and DML statements
Co-related means relationship/dependent on
Non co-related means independent

There are two queries in sub query. You will see group by, order by is single type query but in sub query it needs multiple query

Non co related: They are two types,
Inner query: It will first execute. It will return some result. Independently it will execute.
Outer Query: Based on the inner query result now outer query will execute. The whole process is known as non co-related

 

= for comapring single value
IN for comparing multiple value

Co-related: It is dependent query. Inner query can’t execute independently. Inner query depends on outer query. Without returning row from the outer query inner can’t execute. In co-related sub query. All execute first.


Store Procedure:

MS SQL Server store procedure is used to save time write the same code again and again for storing in database and also get the rquired output by passing parameters.

Syntax:

Following the basic syntax of stored procedure creation.

Lots of parameters used in stored procedure:

IN paramater is a paramater whose value is past inside of the procedure
OUT paramater is a paramater whose value is pass outside the parameter
OUT parameter return some value
IN does not return any value
create procedure

 

Here are the store procedure example basic in my blog

Stored Procedures

 

Sentiment Analysis

 

 

IELTS Writing Hack

IELTS Hacks

Collection Initializer

codes:

 

Various Things in C#

Identifier in C#

https://www.programiz.com/csharp-programming/keywords-identifiers

int @break; means identifier in c#
but int break; will give the error.

this:
it uses to make from the total program

C# Object Initializer

https://www.tutorialspoint.com/csharp_online_training/c_object_initializer.asp

 

 

Constructor in C#

code:

https://www.dotnetperls.com/constructor

 

https://www.tutorialspoint.com/csharp_online_training/c_constructors.asp

Extension Methods in C# 3.0

program.cs

StaticClass.cs

TestExtensionMethods.cs

 

 

 

 

 

 

 

output:

 

Just Be Yourself

Machine Learning Scikit Learn