logging in
database (7)
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 -
how to attach and detach databases in sql server
Written by Super Userconnecting Asp.net local MDF database files to sql
server management studio express is easy to do.
following are the steps to do so -
use command parameters to pass values to SQL statements
Written by Super Usercommand 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.
how to create tables using scripts with databaseOwner and objectQualifier
Written by Super UserIt'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.
how to autogenerete membership tables using membership provider
Written by Super Userwe 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.
Following are some SQL questions and answers, you may require it.
what is SQL Order by clause and how to use it
Written by Super UserThe ORDER BY clause used to sort the sql query results inÂ
ascending or in descending order