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 1744
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 END512
how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.433
Tab 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.
What the is the diff between local index and global index. give some example.
What is snapshot is too old? Give and example for better understand.
How would you best determine why your MVIEW couldn't FAST REFRESH?
What would you do with an in-doubt distributed transaction?
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
How can I give auto reorder mean when my stock will go below the reorder level at that time automaticaly replace order to supplier?
whats the maximum size of view state??
3. Steps in UAT?
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
Have you come across the error ?Failed while printing ?. Why it is happened and How to solve that?
where the dff data will be stored
dear sir please provide what question will be asked in CWE in bank it officer
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
default triggers available for reports
How can we check whether A S M instance is up or down?
give a simple example of physical and logical data independence
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?