Viewing 15 posts - 1 through 15 (of 139 total)
Hi Lowell,
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
Hi,
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
Hi Nakul,
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
Hi,
Any solution for my problem?
Regards,
Arup
March 27, 2012 at 10:03 pm
anthony.green (3/19/2012)
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
Hi,
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
Hi Anthony,
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.
declare...
March 19, 2012 at 3:04 am
Hi Anthony,
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
Hi Ninja,
:):-) I have done the same way you have give. Actually just to enquiry is there any short cut or not.
Thnaks ton,
Arup
July 20, 2011 at 6:55 am
Hi Sartori,
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?
Regards,
Arup
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
Hi
Is there any update on it? Or this is an entirely new scenario
May 12, 2011 at 5:37 am
Viewing 15 posts - 1 through 15 (of 139 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy