What are the required/mandatory parameters that have to be passed with RAISEERROR statement?
How many types of internal joins are there in SQL Server?
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 ??
definion of tcp
What is Mutex error in Triggers?
When you get following error? Error 3154: The backup set holds a backup of a database other than the existing database.
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 HTTP 500 Internal Server Error? CAN I SOLVE THIS?
Difference between Bookmark lookup & RID lookup?
Does DBCC CHECKDB requires DB to be in SINGLE_USER mode?
today's peformance is less than yesturday.it took 1 mint and today's performance is 7 mints.guys can anyone answer to mu question in sql
why we are using shift key in unix shell script
What is the use of NOLOCK locking hint?