جهل بسیط

 Common Table Expressions

Using APPLY

 Cross Apply

عملگرهای جبر رابطه ای

عملگرهای معمولی: اجتماع، اشتراک، تفاضل، ضرب کارتزین

عملگرهای خاص: گزینش(تحدید)، پرتو، پیوند، تقسیم

خلاصه جلسه اوّل نهایه

بسم الله الرحمن الرحیم

بالوجدان می فهمیم که واقعیتی وجود دارد و می فهمیم که در شناخت واقعیت خطا می تواند اتفاق بیفتد. تنها برهان می تواند ما را از شک برهاند و به یقین برساند. برهان فقط به کلیات تعلق می گیرد. پس در فلسفه به احوال موجود کلی یا موجود از آن جهت که موجود است می پردازیم. این احوال و صفات نمی تواند خود نا موجود باشد. پس وصف موجود، خود موجود است. حال این وصف یا مساوی موجود مطلیق است مثل خارجیت مطلقه و وحدت مطلقه یا به ضمیمه مقابلش مساوی موجود مطلق است مثل اینکه می گوییم موجود یا خارجی است و یا ذهنی و یا اینکه می گوییم موجود یا واحد است یا کثیر.

پایان جلسه اوّل.

POCO

Plain old CLR object

From Wikipedia, the free encyclopedia

"POCO" redirects here. For other uses, see Poco (disambiguation).

In software engineering, a plain old CLR object (POCO) is a simple object created in the Common Language Runtime (CLR) of the .NET Framework which is unencumbered by inheritance or attributes. This is often used in opposition to the complex or specialised objects that object-relational mapping frameworks often require^[1]. In essence, a POCO does not have any dependency on an external framework and generally does not have any attached behaviour.

دو خطا در SQL Server که الان به آن برخوردم و راه حل آن‏ها

تعریف عضو وارون

تعریف عضو وارون چپ و راست روشن است.

Definition. Let be a semigroup with identity e. Let a E S. If there exists an element b in S such that ab = e = ba,

then b is called the inverse of a, and a is said to be invertible.

Definition. A nonempty set G with a binary operation . on G is called a group jfthefollowing axioms hold:

(i) a(bc) = (ab)cfor all a,b,c E G. (ii) There exists e E G such that ea = afor all a E G. (iii) For every a E G there exists a' G such that a'a = e.

If the binary operation in a group (G,•) is commutative — that is. ab = ba for all a,b E G — then the group is called commutative or abelian.

تا اینجا: یک مجموعه که ضرب شرکت پذیر، عضو خنثی و وارون گروه. اگر ضرب جابجایی گروه آبلی

Let (S,') be a semigroup. Since- is associative, Theorem 4.2 (Chapter 1) holds here, and therefore there is a unique product of any given elements E S, in that order, that are written For any positive integer n we define, as before, a = aa...a (n-fold product), which is called the nih power of a. 

تعریف عضو خنثی

Definition. Let (S. ) be a semigroup. Ifthere is an element e inS such that ex—x=xe for aJixES,

then e is called the identity of the semigroup (S,).

تعریف right identity

 right identity مشابه left identity تعریف می‏ شود.

نکته

On 14th December 1900, German theoretical physicist Max Plank published his seminal paper on the Quantum Theory of Radiation, and quantum physics was born! In the early years of the 20th century, quantum physics was further developed and applied to explain several other experiments by Albert Einstein, Paul Dirac, Neils Bohr and many others.

Quantum theory is extremely non-intuitive, and came as a shock to the physics community, shaking the foundations of scientific knowledge. American physicist Richard Feynman once said, “I think I can safely say that nobody understands quantum mechanics.”

Though a century old now, its interpretations still puzzle scientists and students alike, making it a hot topic for research, with new ‘theories’ coming up all the time!

Sass: Syntactically Awesome Style Sheets

Angular Gaurd

برای اینکه وسط یک کاری یک کاری انجام دهد مثلا وقتی کاربر یک آدرس را می اورد با استفاده از روت ها چک کند که آیا دسترسی دارد یا نه یا مثلا لاگ کند.

Angular Pipe

Pipes transform displayed values within a template.

Sign up

SET versus SELECT when assigning variables?

SET is the ANSI standard for variable assignment, SELECT is not.

SET can only assign one variable at a time, SELECT can make multiple assignments at once.

If assigning from a query, SET can only assign a scalar value. If the query returns multiple values/rows then SET will raise an error. SELECT will assign one of the values to the variable and hide the fact that multiple values were returned (so you'd likely never know why something was going wrong elsewhere - have fun troubleshooting that one)

When assigning from a query if there is no value returned then SET will assign NULL, where SELECT will not make the assignment at all (so the variable will not be changed from its previous value)

As far as speed differences - there are no direct differences between SET and SELECT. However SELECT's ability to make multiple assignments in one shot does give it a slight speed advantage over SET.

تعریف left identity

Let (S, ) be a semigroup and let a,b E S. We usually write ab instead of a b. An element e in S is called a left identity if ea=a for all a E S.