Explain the difference between delete,drop and truncate in SQL Server?

1040

What is data modelling in sql?

976

What type of database is access?

874

What is full text indexing in mysql?

910

You look at your fragmentation report and see that smon has not coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?

572

What is server replication?

921

Explain about the properties of cursors?

976

What are the different sql languages?

996

What do you mean by foreign key and primary key?

1012

Can you edit long shell operations with an external text editor?

5

what is the difference between data migration and production migration.

2288

How do I manually uninstall an instance of sql server 2016?

976

Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END

1586

Explain concurrency transparency.

997

What is the difference between unix timestamps and mysql timestamps?

977