Emeka Okeke
+ FollowFull stack developer, Software aficionado, and SQL Server Pro.
locationPennsburg, PennsylvaniajoinedDec 11, 2019
18 posts Published5 comments left0 authors followed

Recent Comments


The purpose of TSQL FORMATMESSAGE function is to print or output formated string to the caller.

Re: ERROR :Msg 8117, Level 16, State 1, Line 37 Operand data type varchar is invalid for minus operator.

The second argument of the DATEADD system function must be a numeric integer type. This means it ...

Re: Can you change datatypes in columns already populated with data?

It depends on the datatype you are changing from, and the datatype you are changing to.

Re: Can you join table variables with tables

Yes of course you can join normal T-SQL tables with table variables.

Re: Converting Historical Database DateTime Records to UTC or GMT TimeZone While Accounting for DST

I am not sure what you mean by "all client database". If you don't have existing database datetim...