How to check dotnet SDK and runtime version installed

2020-12-04T09:10:00.000+06:00

I need to install dot net SDK 5 but first, I need to know which versions of SDK installed on my system. So, use dotnet --info. This command will display the SDKs and also runtimes installed on your system with path together where they are installed.For example on my Windows 10 development machine, dotnet --info Microsoft Windows [Version 10.0.18363.1082](c) 2019 Microsoft

Ubuntu/Unix Console Command -Cheat Sheet

2020-11-07T19:59:00.000+06:00

Most popular Linux/Unix command those are required to know during working on Linux/Unix environment.Primarily, when I started the work on ubuntu, I faced a common problem that was not familiar to know about the basic ubuntu command. After that, I aggregate basic commands and work very well.Besides that, most of the time forgot the command and this helps me to cut-down googling time.

Creating and consuming asp.net web api services

2017-11-01T00:54:00.000+06:00

Hi buddy, greetings to you all. If you are newbie in asp.net Web API, today you will learn Microsoft hottest service technology named “Web API” or you are expert, please read this post and leave a comment. So let’s start: Microsoft Asp.net Web API is a wonderful framework that makes it easy to build HTTP services that reach a broad range of clients, including browsers and mobile devices

What are the difference between DDL, DML , DCL and TCL commands?

2017-07-18T00:03:00.002+06:00

Database Command Types DDL Data Definition Language (DDL) statements are used to define the database structure or schema. - CREATE - to create objects in the database - ALTER - alters the

Create SQL Server Job in Easy Steps

2017-07-15T22:05:00.001+06:00

Job is a set of one or more management tasks. The SQL Server Agent service is managing SQL server jobs. SQL Server Agent is a windows service. This topic will help to beginners to create SQL Server Jobs in a easy steps. Install Sql Server Management Studio and Go SQL Server Agent. Purpose: Some time customer want to complete a specific action in periodically like “Daily”, “Weekly”, and “

Stored Procedure -SQL Server

2016-11-09T18:35:00.002+06:00

Stored Procedure is most popular database object. A stored procedure in SQL Server is a group of one or more Transact-SQL statements . Procedures resemble constructs in other programming languages because they can: ü Allow input parameters and return multiple values in the form of output parameters to the calling program.

HTTP Error 404.2 - Not Found The page you are requesting cannot be served because of the ISAPI and CGI Restriction list settings on the Web server

2016-11-05T12:07:00.002+06:00

When we try to visit a Web page that is hosted on a computer that is running Internet Information Services (IIS) 7.0, sometimes we may receive the following error message: HTTP Error 404.2 - Not Found The page you are requesting cannot be served because of the ISAPI and CGI Restriction list settings on the Web server Reason: -----------------------------------

DBCC CHECKDB

2016-10-05T18:17:00.001+06:00

Checks the logical and physical integrity of all the objects in the specified database. DBCC CHECKDB('Galaxy'); Message Results: DBCC results for 'Galaxy'. Service Broker Msg 9675, State 1: Message Types analyzed: 14. Service Broker Msg 9676, State 1: Service Contracts analyzed: 6. Service Broker Msg 9667,

How to get all connected DBLINK information -SP_LINKEDSERVERS

2016-10-05T17:14:00.002+06:00

I am working several remote server those are connected with DB link. I need create a DB link (remote server oracle db) with my SQL Server, but don't know the required server is connected or not. at this moment used SQL server default procedure EXEC SP_LINKEDSERVERS Found below results: all link server name, provider name, DataSource IP

How to check if a column exists in table -SQL Server

2016-10-04T18:40:00.001+06:00

In this tutorial i will check 'TestCulumns' column exists in a table, when its not exist, add this column. IF EXISTS( SELECT * FROM sys.columns WHERE Name = N'TestCulumns' AND Object_ID = Object_ID(N'Categories')) BEGIN SELECT * FROM Categories; END ELSE BEGIN ALTER TABLE Categories ADD TestCulumns VARCHAR(20); END

How to get first day and last day Of the current and Previous year on Oracle

2016-10-02T15:14:00.006+06:00

Get current year : SELECT TO_CHAR(SYSDATE, 'YYYY') AS Current_Year FROM DUAL; First Day of Current Year: SELECT TO_CHAR(TRUNC (SYSDATE , 'YEAR') ,'DD/MM/YYYY') FROM DUAL; Last Day of Current Year: SELECT TO_CHAR(ADD_MONTHS(TRUNC (SYSDATE ,'YEAR'),12)-1,'DD/MM/YYYY') AS LastDay_Current_Year

Repair statement not processed. Database needs to be in single user mode.

2016-10-01T01:27:00.005+06:00

When I try to run DBCC repair I get the below the errors .Database needs to DBCC CHECKTABLE('Person.Address', REPAIR_REBUILD ) Msg 7919, Level 16, State 3, Line 1 Repair statement not processed. Database needs to be in single user mode. The correct way to run a DBCC CHECKDB or DBCC CHECKTABLE statement with valid REPAIR options is to start SQL Server normally and then explicitly set

DBCC CHECKTABLE

2016-09-30T23:46:00.002+06:00

Checks the integrity of all the pages and structures that make up the table or indexed view. Syntax: DBCC CHECKTABLE ( table_name | view_name [ , { NOINDEX | index_id } |, { REPAIR_ALLOW_DATA_LOSS | REPAIR_FAST | REPAIR_REBUILD } ] ) [ WITH { ALL_ERRORMSGS ] [ ,

DBCC Command (Database Consistency Checker) -Sql Server

2016-09-30T22:35:00.002+06:00

Database Consistency Checker act as Database Console Commands give details in form of statistics about the SQL Server. They can be used for Maintenance of database, index, or file group. DBCC Commands can be used to perform validation operations on a database, table, index, catalog, file group, or allocation of database pages. Database Console Command statements are grouped into the following

Split a string to a table using T-SQL

2016-09-30T17:04:00.001+06:00

In this tutorial, I will create a utility function used for string split and return in a table. ALTER FUNCTION Splitstring_to_table ( @string NVARCHAR(MAX), @delimiter CHAR(1) ) RETURNS @output TABLE( id INT IDENTITY(1,1) PRIMARY KEY, data NVARCHAR(MAX) ) BEGIN DECLARE @start INT, @end INT SELECT @start = 1, @end = CHARINDEX(

Count number of columns returned by a query -Sqlserver

2016-09-25T16:12:00.002+06:00

I have done this with Sql server temp table. SELECT * INTO #temp FROM CIF_CARDpro_IRIS_USDDATA --Select from temp table SELECT * FROM #temp --List of columns SELECT COUNT(name) NumOfColumns FROM tempdb.sys.columns WHERE object_id = object_id('tempdb..#temp'); --drop temp table DROP TABLE #temp

How to count the number of columns in a table using SQL

2016-09-25T15:56:00.001+06:00

For SQL Server : SELECT COUNT(COLUMN_NAME) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG = 'GALAXY' AND TABLE_SCHEMA = 'DBO' AND TABLE_NAME = 'CIF_CARDPRO_IRIS_USDDATA' For Oracle : SELECT COUNT(*) FROM USER_TAB_COLUMNS WHERE TABLE_NAME='TBLTRANSACTIONLOG'

Select Record From Link Server -Sql Server

2016-09-24T17:36:00.003+06:00

Sometimes we need to CRUD operation in different server. SQL Server using An OLE DB provider , An OLE DB data source for this. SELECT * FROM [LinkServer].[databasename].[schemaname].[tablename] SELECT * FROM TLINK.Northwink.NRTH.Customers Note: At first you create a Link server like : TLINK

Generate HASH string with T-SQL -Sqlserver

2016-09-19T18:18:00.001+06:00

Using HASHBYTES Generate HASH string : HASHBYTES ( '<algorithm>', { @input | 'input' } ) <algorithm>::= MD2 | MD4 | MD5 | SHA | SHA1 | SHA2_256 | SHA2_512 Algorithm MD5: SELECT CONVERT(VARCHAR(32), HashBytes('MD5', 'code-lake@blogspot.com'),2) Output:

SQL Server blocked access to procedure ‘sys.sp_OACreate’ of component ‘Ole Automation Procedures’

2016-09-19T16:36:00.001+06:00

I am working on banking project. For migration purpose, I will call web service in store procedure and based on this response I will process another task. Create a Procedure named WebserviceCall CREATE procedure WebserviceCall @UsrID as varchar(50) ,@Password AS Varchar(50) ,@AccountNo AS Varchar(50) AS BEGIN DECLARE @obj INT DECLARE @

How to Refresh/Reload a Page frequently or periodically

2016-09-06T12:53:00.002+06:00

We can automatically webpage refresh/ reload with two ways. one of them is using HTML Meta Tag and another is Javascript. in this tutorial you can learn both technique. Using Meta Tag <!DOCTYPE html> <html class="k-ff k-ff43"> <head> <meta http-equiv="refresh" content="10" /> </head>

How to show/ hide child element on mouse hover of parent element -CSS

2016-09-05T15:34:00.003+06:00

In this tutorial, you learn how to show or hide child element of parent element. simply doing this with html and CSS. There are two DIV, child div contain two button controls and child div to keep in parent div. when parent div mouse hover action happened , child div will display . let's try it …! <!DOCTYPE html> <html class="k-ff k-ff43"> <head> &

Table Variable - Sql Server

2016-08-31T01:00:00.003+06:00

Microsoft first time introduce Table variable in sqlserver 2000. it is alternative to using temporary table, but has some difference. Table variable acts like general table to store, update, delete and delete records. Table variable store in TempDB in sqlserver. I will explain TempDB in later. Table variable declaration similar to CREATE TABLE Statement Declaration : DECLARE @

Efficiently Paging Through Large Amounts of Data (PageIndex, Page Size) -SQL Server

2016-08-17T18:13:00.002+06:00

In this article you learn how to fetch data according PageIndex and PageSize. In web application, it is much more important to increase webform performance, loadbalance. In my development experience, some of table hold large amount of records (more than 2GB) and user need to shows records in GridView. But problem is when we select all records and loads in webforms, webform has crashed. In

Password only alphanumeric no special character -MVC C#

2016-07-20T17:36:00.000+06:00

Password matching expression. Password must be at least 4 characters, no more than 8 characters, and must include at least one upper case letter, one lower case letter, and one numeric digit. Expression: ^(?=.*\d)(?=.*[a-z])(?=.*[A-Z]).{4,8}$ public class LoginViewModel { [Required(ErrorMessage="Required")] [Display(Name = "User name")] public

Code By Experience