Is there a way of obtaining the ID of a newly inserted record where this is defaulted to newsequentialid() in the table definition. For int identities you can use '@@identity' or scope_identity() however when I try and use scope_identity() I get the following error message:
Operand type clash: numeric is incompatible with uniqueidentifier
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.