Monday , December 11 2017
Home / 2016 / June

Monthly Archives: June 2016

C# Complete Tutorial(Step By Step)

C# Complete Tutorials (Step by Step): C# (pronounced as see sharp) is a general-purpose, object-oriented programming language. The most recent version is C# 6.0, which was released on July 20, 2015. From This Article We can Learn C# Step by Step. Lesson1 : C# Introduction Lesson2 : .Net Framework Lesson3 : Visual Studio Software …

Read More »

Lesson 3:Hello World Example in C#

Hello World Example in C#: For Making Progrms in C# we need Visual Studio Software. You can Download Visual Studio software following Microsft Link   Now Open Visual Studio and Follow Below Steps Step 1: Go to File>New>Project Step 2:From Left Side Project Templates Select Visual C#>Select Console Application Step …

Read More »

OTP Generation in Asp.net with C#

OTP Generator C#

OTP Generation in C#: OTP Generation is very important in today’s programming. OTP Stands for one time Password. it is a password that is valid for only one login session or transaction OTPs avoid a number of shortcomings that are associated with traditional (static) password-based authentication. Now a days OTP is used …

Read More »

Sql Server Date Functions(One by One):

Sql Server Date Functions

Sql Server Date functions: SQL Server date functions are scalar functions that perform an operation on a date and time input value and returns either a string, numeric, or date and time value.  Some date and time functions are categorized as deterministic functions while others are non-deterministic. 1.GETDATE() 2.GETUTCDATE() 3.SYSDATETIME() …

Read More »

Sql Server String Functions (ONE BY ONE):-

Sql Server String Functions

Sql Server String Functions  :- 1)ASCII(s) 2)CHAR(n) 3)NCHAR(n) 4) LEN(s) 5) CHARINDEX() 6)CONCAT() 7)LEFT(s,n) 8)RIGHT(s,n) 9) SUBSTRING(s,start,length) 10)LOWER(s) 11)UPPER(s) 12)LTRIM(expression) 13) RTIMM(expression) 14) REPLACE(Expression,Pattern, Replacement_Value) 15) REPLICATE(s,n) 16) REVERSE(s) 17)  STUFF(Eepression, Start, length, Replacement_expression) 18) SPACE(n) 1)ASCII(s):- ASCII(s) function returns ASCII code of the given character expression. [crayon-5a2e82d58859f799287844/] Note:-Here “s” is …

Read More »

Mathematical Functions in Sql Server(One By One):-

Mathematical Functions

Mathematical Functions in Sql Server:- Sql Server Contains different  types of Mathematical Functions:- Abs() Ceiling() Floor() Power() Square() SQRT() Rand() Round() Sign() PI() Log()   1.Abs() :-  Abs() stands for absolute and returns  the absolute (positive) number. [crayon-5a2e82d589cb2001746119/] Note :- Here “n” is a numeric expression. [crayon-5a2e82d589cc0319005048/] 2.Ceiling() :-  Ceiling() …

Read More »

SQL Server Management Studio Shortcut Keys

Sql server shortcut keys

SQL Server Management Studio Shortcut Keys: Keyboard shortcuts save a lot of time and can improve productivity as well. SQL server Management Studio has several keyboard shortcuts. Here, we will explore the most essential and Important shortcuts which will make our daily programming More easily.   See Also Visual Studio Shortcut …

Read More »