Saturday, 23 November 2019 16:59

what is SQL Order by clause and how to use it

The ORDER BY clause used to sort the sql query results in 

ascending or in descending order

Published in database
Saturday, 23 November 2019 16:51

Some SQL questions and answers

Following are some SQL questions and answers, you may require it.

Published in database
Friday, 21 December 2012 13:51

how to Use View tables in Sql server

if we need some fields from different tables
temporarily in our software or application then

Published in database
Wednesday, 19 December 2012 13:55

how to attach and detach databases in sql server

connecting local MDF database files to sql
server management studio express is easy to do.
following are the steps to do so -

Published in database

It's a good idea to use a class say gateway where all
database access codes will be this gateway class
you will implement db connection as follows -

first create another class -

Published in database