I have two tables.
First is CAT_TABLE_LIST ;
FIELD_NAME            OPPOSITE_NAME    TBL_NAME
Height (mm)                              COL_1                TBL_13

how to implement check constraint in the particular column

Has anyone found a solution in SQL Server 2005 for inserting default
constraint values into a table when an input parameter is NULL?
In SQL you can do the following:
INSERT tbl

I have a table that looks like
CREATE TABLE ZipStats
    ZipCode     CHAR(5),
    Cost        int

I am trying to get a list of stored procedures (not system stored
procedures) along with there parameters.
Is this possible?
Thanks,

Hi thanks for looking. I'm trying to create an index on a calculated column
in SQL Server 2000 using:
ALTER TABLE Trade ADD TradeDateTrimmed as DATEADD(dd, DATEDIFF(dd, 0,
TradeDate), 0)

I have a table in my SQL Server 2000 database that I do not want to allow
any rows being deleted from. So, I simply right clicked the table in
enterprise manager, clicked permissions, then placed an "X" beside all of
the users listed there under the "Delete" heading.

In the below I need to calculate (TransactionHistory.Quantity *
TransactionHistory.CostValue) AS ExtendedCost WHERE
TransactionHistory.TransactionTypeID=15 AND (TransactionHistory.Quantity *
TransactionHistory.CostValue*-1) AS ExtendedCost WHERE

I coded a parameter:
@RunDate As DateTime = GetDate()
and it complained, can this be done?

I am attempting to write "unit" tests for my procs.  one of those procs uses @@spid as a value in the table.  I need to
write a test that will check a different value of @@spid.
I was hoping for something like this (but i can't find the TSQL for it)
(do the stuff before)

The Microsoft online helps shows this syntax for modifying existing columns
to turn IDENTITY on with the following syntax:
ALTER TABLE MyCustomers ALTER COLUMN CustId IDENTITY (200, 2)
However other blogs state this is not supported(?) and I get an error when I

I need to do what a view does (return a table) but I need a variable
parameter (current date). I've heard about functions, can they do this and
how do I write one? Thanks.

I need an elegant way to determine the first and last of the current month so
I can compare if other dates are prior to or after the current month.
I do know that GetDate() gets me the current date and DatePart() gets me
individual parts of the month. I think I can see how to get ...

I've got code running from one particular database on a server.  I
want it to refer to tables in another database on the same server, and
maybe another database on another server.
Do I need to create the synonyms in the Master database, or in the

This is related to the problem I posted earlier, and might actually be the
route cause.
I have two tables, like this:
CREATE TABLE Events (