This will work in SQL Server:
ALTER TABLE Employee ADD CONSTRAINT DF_SomeName DEFAULT N'SANDNES' FOR CityBorn;
More Related Contents:
- Comma separated results in SQL
- How to check if a column exists in a SQL Server table
- Understanding PIVOT function in T-SQL
- Using T-SQL, return nth delimited element from a string
- Get first day of week in SQL Server
- Using RegEx in SQL Server
- How do you view ALL text from an ntext or nvarchar(max) in SSMS?
- Confused about UPDLOCK, HOLDLOCK
- INSERT INTO vs SELECT INTO
- SQL Server 2008 Empty String vs. Space
- How do I use the CONCAT function in SQL Server 2008 R2?
- Select / Insert version of an Upsert: is there a design pattern for high concurrency?
- TSQL: How to convert local time to UTC? (SQL Server 2008)
- SQL Server: combining multiple rows into one row
- How do I find a stored procedure containing ?
- SQL Recursive CTE: Finding objects linked by property
- How to convert number of minutes to hh:mm format in TSQL?
- Convert decimal time to hours and minutes
- SQL Server 2008 – How do i return a User-Defined Table Type from a Table-Valued Function?
- How do I move a table into a schema in T-SQL
- Instead of trigger in SQL Server loses SCOPE_IDENTITY?
- How Can I Detect and Bound Changes Between Row Values in a SQL Table?
- How to wait for 2 seconds?
- What are row, page and table locks? And when they are acquired?
- Generate MD5 hash string with T-SQL
- How can I automate the “generate scripts” task in SQL Server Management Studio 2008?
- How to add xml encoding to xml Output in SQL Server
- Can I set ignore_dup_key on for a primary key?
- Compute MD5 hash of a UTF8 string
- Sort Bullets in Database