The answer is not incorrect but the wording is a bit misleading. While it is true that adding 'not null' changes the outcome, it is not true that the column...

Freddy

I think you are experiencing the problem of transferring the authentication from the IIS-machine to the (remote) SQL Server.

By default, IIS is using the IUSR_machine account which shouldn't be granted...

Hi Freddy

As a starting point you might want to disallow anonymous access on the IIS thereby forcing an authentication of the user making requests to the IIS. This way, you can avoid...

A little more info would be helpful. What does "We need 'batch cycle times'" mean. I understand that you want to do something about the intervals between batch runs. But...

Hi Chris

I think you're asking function arguments to be what they were not meant to, namely join fields.

Table functions with arguments come in handy where you need to restrict...

Try:

CREATE VIEW viewPTrans

AS

Select PeriodIDs.PerId,

IsNull(PTransactions.Transamount,0) 

FROM PeriodIds

LEFT OUTER JOIN PTransactions ON PeriodIDs.PerID=PTransactions.PerID

Regards

Mads

smv929,

Your trigger seems to be expecting that only one row has changed. In some situations you can rule out the possibility of getting more than one row changed at a...