Hi,

Create a trigger on the table

IF EXISTS (SELECT name FROM sysobjects
      WHERE name = 'deny_deletion' AND type = 'TR')
   DROP TRIGGER deny_deletion
GO
CREATE TRIGGER deny_deletion
ON table_name
FOR DELETE
AS
   RAISERROR('You are not...

Hi,

How about download and install msde.

Attach the database. (See: Microsoft Knowledge Base Article - 325003 http://support.microsoft.com/default.aspx?scid=kb;en-us;325003)

Use ms-access as a client.

regards,

Leon

Hi Chris,

Microsoft Knowledge Base Article - 263556

http://support.microsoft.com/default.aspx?scid=kb;en-us;263556

Regards,

Leon

Hi,

Don't know how to do this with rand() but...

Have a look at this.

#my_phone_numbers is "your" table with phone numbers.

HTH

Leon

create table #my_phone_numbers (phone_number varchar(5) not null)

set nocount on

declare @digits int

set @digits...

Hi,

Have a look here

http://www.sqlteam.com/item.asp?ItemID=2463

Regards,

Leon

Hi,

Maybe I do not understand you correctly but…

Why not run true the whole cursor, built your @comments string and insert it...

Use a FULL JOIN

SELECT  *

FROM db1.dbo.table1  A

FULL JOIN db2.dbo.table1 B

ON A.u_logon_name = B.u_logon_name

WHERE A.u_logon_name IS NULL OR B.u_logon_name IS NULL

Regards,

Leon

Here is a little script I use.

HTH

Leon

DECLARE @TABELNAME nVarchar(500)

SET @TABELNAME = 'PG_DATA_SALES'

SELECT

 column_name = object_columns.[name],

 value_type = object_column_type.[name] + '(' + CAST(object_columns.[length] AS varchar(5)) + ')',

 value_precision = object_columns.[xprec],

 value_scale =...

Thnx Chris,

I did not know that.

regards,

Leon

My answer was select datepart(dw,getdate())

My answer is not incorrect. The other answer may be better looking.

Strange answers anyway. So the highest sales occured...

It seems someone has reset the (wrong) answer.

The question is reopened for answering.

On a Windows System System.