database

database (7)

Friday, 08 March 2013 13:55

how to join two tables by Left Join sql

Written by
Rate this item
(0 votes)

there are different kind of joins available by sql like
inner join,left join,etc.by the following example i will show
how to do left join which i used in my application to
get data from two tables -

Wednesday, 19 December 2012 13:55

how to attach and detach databases in sql server

Written by
Rate this item
(0 votes)

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

Rate this item
(0 votes)

command objects use parameters for passing values
to sql statements for type cheking,validation,guarding
against SQL injection attacks,etc.so its a good practice
to use command parameters to sql statements.

Rate this item
(0 votes)

It's a professional logic to use the databaseOwner
and objectQualifier values when creating tables
else you will not be able to identify the tables
in databases with ease and gain other benefits of it.

Rate this item
(0 votes)

we know how to use asp.net membership provider.
most of the time we create membership tables
manualy.But those tables can be created
automatically by adding a line in the membership
provider configuration in web.config file.

Saturday, 23 November 2019 16:51

Some SQL questions and answers

Written by
Rate this item
(0 votes)

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

Saturday, 23 November 2019 16:59

what is SQL Order by clause and how to use it

Written by
Rate this item
(0 votes)

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

ascending or in descending order


Latest discussions

  • No posts to display.