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

Recent Comments

Re: What is the difference between SSIS parameters and variables

First of all, there is no such thing as SSIS project-level variables. Note that SSIS is an extens...


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...