On which table the SSIS SQL Server logs are stored?
How many types of internal joins are there in SQL Server?
I have table name'temp' in that I wanted to add some partial data for a particular column name 'policyno' where data is existing in that column. Ex.Policyno like 'R-KT-SK- EA-134526' like 100 records. In that 100 records some policynos are just like 134527 I mean with out prefix like'R-KT-SK-EA-' now I wanted add this prefix as 'R-KT-SK- EA-134527' for some 50 records. How can I add partial data?
What severity level errors are managed in TRY-CATCH block?
when i save float data value 11.22 but this see in table 11.220000004758456 type ? how to save only two decimal point.
What is the use of NOLOCK locking hint?
why we are using shift key in unix shell script
How to solve -805 error i.e. Bind issue. There are two conditions- 1) If you have access to the database table 2) If you don't have access to the table
Hi, I am trying to encode data from flatfile and then to decode the encoded data to original form. Procedures that I followed:- 1. Encoded the field 'A_ID' using AES_ENCRYPT(A_ID,'abd') in the expression transformation. The A_ID got encoded in the output table(oracle) 2. To decode this back I used AES_DECRYPT(A_ID,'abd'). But after executing the workflow, I am not getting any data in output. can anybody tell me how to decrypt the encoded data back to original form ??
How to view the error log for any specific instance?
WHAT IS HTTP 500 Internal Server Error? CAN I SOLVE THIS?
Is the company liable to deduct professional tax of directors?
What are the required/mandatory parameters that have to be passed with RAISEERROR statement?