default value in SQL

  • Thread starter Thread starter Calvin Lai
  • Start date Start date
C

Calvin Lai

Hi all,

Does anyone know how to retrieve the default value set in Sql server in
ASP.Net? any help or guildence will be appreciated.

Calvin
 
Hi Calvin,

You will have to execute sql stored procedure
exec sp_columns 'tablename'
and check out COLUMN_DEF column.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem w/ SQL server's default value 7
Problem connecting to SQL 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
How to initialice a default value for a column in a typed DataSet 2
SQL Server 2000 9
MS SQL 2005 Configuration ??? 9
retrieve default values 2
Can't insert record into SQL server express from ADO.NET inside IIS 4

Back
Top