Viewing 15 posts - 1 through 15 (of 139 total)
Thanks for your reply. We need to call a function from a view; the function contains complex calculation, whuch needed dynamic sql.
There are number of limitations:
1. We cant call...
April 9, 2012 at 10:10 pm
I am sorry that I hv not informed you...this issue has been resolved. I have reinstalled SQL server with mixed authentication and now it is working fine. Previously it seemed...
March 29, 2012 at 6:08 am
Thanks for your response.
Problem is I am not able to open any editor even to run this error message. I ahve not the administrator of the machine,but I have...
March 27, 2012 at 11:06 pm
Any solution for my problem?
March 27, 2012 at 10:03 pm
March 19, 2012 at 4:50 am
select CONVERT(binary(16),'0x2139aec19f212447bb23ba307d611a1e') will give...
March 19, 2012 at 4:10 am
Thanks Anthony, I will try this and let you know
March 19, 2012 at 3:58 am
Sorry as I cant post code or table def. for security reason.
Could you just answer one thing:
I have this type of column( ex. 0x2139aec19f212447bb23ba307d611a1e) already in binary format but the...
March 19, 2012 at 3:33 am
This is not the problem with ntext conversion. I ahve extracted uid as nvarchar from the ntext. Now need to convert that uid to binary which is throwing error.
March 19, 2012 at 3:04 am
Thanks for quick reply. Actually I am parsing this string from a ntext column and storing this inside a table variable. If I am putting my table variable...
March 19, 2012 at 2:39 am
July 20, 2011 at 7:10 am
:):-) I have done the same way you have give. Actually just to enquiry is there any short cut or not.
July 20, 2011 at 6:55 am
Thanks for the response. I am aware of that method but my question is, shall I put TRY-CATCH block inside the CREATE VIEW statement?
July 20, 2011 at 6:09 am
One more thing, this is entirely related to future performance. If you guys fill that there will not be any performance issue, then please let me know.
I think, ...
May 12, 2011 at 5:41 am
Is there any update on it? Or this is an entirely new scenario 😀
May 12, 2011 at 5:37 am