It is possible.

delete from TableName where ColumnName < getdate() - 31

>> to prevent users from entering whatever they like for an email address.

It is better to do this validation in the front end.

In my openion, second one is better. The key word 'AS' serves as a hint. It is easy to guess that mycolumnname is an alias.

1) Add linked server

2) SELECT column_list FROM Server.Database.Schema.Table

Why is your client changing from DAS to SAN?

Is it for clustering?

Do you mean softcopy (PDF) in the Net?

I suggest you to purchase the hardcopy (book). It will be convenient to read. You can underline the points that are usefull to...

Use Surface Area Configuration to enable remote connections.

1) If you use .BAK extension, you can configure Database Maintenance Plan to delete older backup files.

2) File name extension should not affect the file content. The parameters will determin...

nchar,nvarchar, and ntext are unicode data types.

They are used to support multiple languages.

Storage size is double of normal data types.

Use sp_changedbowner to set the database ower name.

Suresh

If you are storing the date and time of insertion in a column, you can use following query:

select * from TableName where ColumnName >= dateadd(mi, -30, getdate())

You have to write seprate UPDATE/DELETE statements to update/delete rows from each table.

INNER JOIN can be used in UPDATE/DELETE statements.

INSERT INTO #TEMPTBL (formula, final_formula) VALUES (@FORMULA, @FINAL_FORMULA)

select PersonId, count(PersonId) as NullCount

from dbo.Table_1

where value is null

group by PersonId

1) Create a temporary table with required columns (3 columns for given year, 3 for previous year).

2) Insert values to the first 3 columns for the date range passes as...