database

database (5)

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.

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)

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.