SQL
Change the password in SqlServer
Change the password of SqlServer This is the common problem of new learner and programmer how to change the password of the SQL server in any versi…
Read more
SQL
Convert Number to Word in Sql Server
Here I am showing function which converts number value to words. You need to do just pass number in the parameter. this function converts Number to …
Read more
SQL
Show data in DataGridView
The DataGridView Control in dot net(c sharp) is the very useful data control. The DataGridView control makes it easy to define the basic appearance…
Read more
SQL
Using Sql Transaction in C Sharp
SqlTransaction class perform the sql transaction in c sharp these are the main thing to be kept in mind Create connection, create t…
Read more
SQL
Difference Between #Table And ##Table in Sql
Difference between local temporary table) and global temporary table are #TABLE(Local Temp table) Temp tables are available ONLY to the one ex…
Read more
SQL
Create Table in Sql Database
To create table using wizard in Sql Server we have to follow the following steps. 1. Expand database and right click on the table Create Table …
Read more
Sql Server
Create Databse in sql Server using Query
Using Sql Query editor CREATE DATABASE [tutorialsdb] CONTAINMENT = NONE ON PRIMARY ( NAME = N'tutorialsdb', FILENAME = N'C:\Progra…
Read more
SQL
Create New Database in Sql
Creating New Databse in Sql Using wizard 1. Right Click on the databse as shown in the figure 2.Give the name of the database name and if you wa…
Read more
SQL
Update Trigger Sql Server
update Trigger is very useful if you keep your deleted record or which data is replaced with new , here i have one table called tbluser which have a…
Read more
SQL
Delete Duplicate Data From Database
There may be many duplicate data in database so we need to delete it. But remember we have to keep one row of same data other wise it would be detel…
Read more
It's Edu Point is a blog that is all about tutorials and news for Microsoft office, dot net, Blazor Technology and other Programming and Information Solution.
Social Plugin