What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..
1 3205Please 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
1148how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.
1098Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
TCS,
1250
What is oracle in java?
What is the main purpose of triggers in database?
What is mysql used for?
Can I create table without primary key?
Which are the two editions in which SQL Azure database available?
How to backup encryption key ?
what is a record in a database ? : Sql dba
How to bring a tablespace online?
Tell me what is a linked server?
What is rank () in sql?
What is data set in report?
Define concurrency control. : Transact sql
What is difference between rownum and row_number?
Explain vdl (view definition language)?
How to load a csv file into a table