declare

@datetime datetimeoffset = '2012-10-25 00:00:00.000 +04:30'

select

case

when (DATEPART(TZ, @datetime) <> 0 and DATEPART(TZ, @datetime) is not null OR CONVERT(TIME(0),@datetime) <> '00:00:00')

then 0

when (DATEPART(TZ, @datetime) = 0 and @datetime <> '')

then...

anthony.green (1/8/2013)

---

With difficulty

You could do a check in the string for the + or - symbol to indicate Offset

You could then do a check for a : to detail if...

If i use isdate() function also will not solve my issue.

my issue is to find out what is the datatype?

Please try trigger for that particular table.

tr_TableName_After_Insert

create trigger [dbo].[tr_TableName_After_Insert]

on [dbo].[TableName]

after insert

as

begin

(your operation to insert into different table)

end

Your Question is not clear.

hey did you change the question? what happended?????

Q1)-SQL server wait until a lock release before giving another connection access to the same data, By default how long will sql server wait for the first connection to release...

Hi,

i had gone through your example its look wrong.

please find the detail.

declare @int1 varchar(100) = '100000000',

@int2 varchar(100) = '984541',

@int3 varchar(100)

your suggestion was mentioned below:

set @int3 = STUFF( @int1,...

Your welcome dude 🙂

Hi,

Please go through this url, which explains each and everything in depth.

http://www.sqlservercentral.com/articles/Temporary+Tables/66720/

Regards

your welcome 🙂

Hi Trout,

I am suggesting some code please correct me if i am wrong.

the column ageatdeath will always contain values like eg:

51years

62years

45years

suppose the age is "100years" then the below mention query...

Please go through the url and my mistake its error code.

SQL Server has encountered 22953 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [H:\MSSQL10_50.MSSQLSERVER\MSSQL\Data\xxxxxxxxx.MDF] in database [CORETABLES_PROD] (6). The OS file handle is 0x0000000000000DE4. The...

Hey please go through the below mentioned link.

http://www.codeproject.com/Articles/173275/Clustered-and-Non-Clustered-Index-in-SQL-2005