How to get TimeZone as default value

Question

0.00/5 (No votes)

See more:

How set default value of a column as only timezone(like "Indian Standard Time") using SQL Server2012.
I have write a code about that this is :

DECLARE @TimeZone VARCHAR(50);
EXEC MASTER.dbo.xp_regread 'HKEY_LOCAL_MACHINE','SYSTEM\CurrentControlSet\Control\TimeZoneInformation','TimeZoneKeyName',@TimeZone OUT;
SELECT @TimeZone

But how to set it as default value when ctreate a table ??

Posted 2-Apr-15 11:43am

RTK The Limited Edition

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

DamithSL · Answer 1 · 2015-04-02T17:00:00

Solution 1

declare string with table create script, you can use @TimeZone value to build that table script as default value for the column. then execute that dynamic sql string using

SQL

EXECUTE(@SQLStatement)

Posted 2-Apr-15 17:00pm

DamithSL

**Manoj K Bhoir** · Answer 2 · 2015-04-02T19:12:00

Hi, You can not set Default Value for column in Create Script. First Create Table and then using Alter Script you can set default value or bindings for specific column as you require. Please check this example:

SQL

DECLARE @TimeZone VARCHAR(50);
EXEC MASTER.dbo.xp_regread 'HKEY_LOCAL_MACHINE','SYSTEM\CurrentControlSet\Control\TimeZoneInformation','TimeZoneKeyName',@TimeZone OUT;
Select 'Create Table [dbo].[Test] (
            [Id] [int] IDENTITY(1,1) NOT NULL, 
			[Column1] [varchar] (50) NOT NULL, 
			[Column2] [varchar] (50) NOT NULL)
			GO
ALTER TABLE [dbo].[Test] ADD  CONSTRAINT [DF_SomeName]  DEFAULT (N'''+@TimeZone+''') FOR [Column2]
GO'

It will create following script :

SQL

Create Table [dbo].[Test] (
            [Id] [int] IDENTITY(1,1) NOT NULL, 
			[Column1] [varchar] (50) NOT NULL, 
			[Column2] [varchar] (50) NOT NULL)
			GO
ALTER TABLE [dbo].[Test] ADD  CONSTRAINT [DF_SomeName]  DEFAULT (N'India Standard Time') FOR [Column2]
GO

I hope this will help you. :)