![]() Why I need this? Some of my queries needs to be modified and I cannot modify them directly in EDIT mode of the table so I have to copy it to notepad+6, do the modifications and paste them back.but after paste (even if I do not modify anything) the query no longer works. I am very sure it's something about COPY-PASTE carriage returns or spaces issue, but I've spent 2 hours and I cannot figure out what can be the problem. ( It throws an error while executing: Incorrect syntax near ',') Here is a brief explanation of the code and the options:-S is used to specify the server against which you need to run the query. Now, I can PASTE this in EDIT mode of any record but the Query will no longer works when it will be called by the system. If I copy paste from VIEW mode (select mode in SQL) it copies like this: SELECT * FROM dbo.SearchPropertiesWithAddress(1132, - NULL, - '', - '32,16', - '', - NULL, - '', - NULL, - NULL, - 3, - NULL, - NULL, - NULL, - NULL, - '') - ORDER BY CAST(PCode As int) You can create shortcuts for frequently used queries in Management Studio, some of the shortcuts are predefined, like pressing 'Ctrl + 1' will execute 'spwho'. If I paste here (or in other notepad, word etc file) the PASTE works nice but if I try in EDIT mode, to paste any Query field content, from one RECORD to another, it puts nothing. I have a very strange copy paste problem: what you see above is taken with copy paste from EDIT mode of one record. This contains a query built in the code which calls some function, something like this: SELECT *įROM dbo.SearchPropertiesWithAddress(1132, - BY CAST(PCode As int) I have a table in SQL Server 2008 and one of the column is called Query with nvarchar(MAX) data type.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |