How can I replace a fixed string with carriage returns in a memo field?
May 12, 2011 · I suppose that you're using SQL Server 2000, just because when you say "memo" is the text (or ntxt) datatype, that's right? I mention that because if you have SQL 2005 and above, you can …
Replacing multiple spaces with a single space
May 21, 2008 · Hello, You can replace any character that is following each other. I had some notes on this topic and a function with scripts. But actually they're also using WHILE loop Here is the article, …
How to call oracle function using C#? - social.msdn.microsoft.com
Jan 11, 2011 · SQL> SQL> create or replace function get_emps 2 (p_args in qry_params ) 3 return sys_refcursor 4 as 5 stmt varchar2(32767); 6 rc sys_refcursor; 7 begin 8 stmt :=' select * from emp'; …
Passing multiple parameters to a function - social.msdn.microsoft.com
Aug 7, 2013 · There are a few ways to skin this cat, but I would replace the scalar function with a table function that accepts either a comma separated list of arguments or a table valued parameter.
How to return a table of key/value pairs from a C# CLR function.
Jun 14, 2019 · I am looking for help on how to return a table of key/value pairs from a CLR function in SQL Server. I have this code. It doesn't work ATM. Still reading posts and watching videos, but they …
Double Quotes in a SQL Query.. - social.msdn.microsoft.com
Dec 11, 2008 · i thought the following would work - but nope! sql.replace (" ' ", " " ") <-- ignore the spaces, just so you can see what i mean... Reason for the replace: i want to use a double quote in an …
Access to calculate cumulative sum in Query - DSUM performance very …
Nov 16, 2015 · Can somebody suggest alternative ways to replace the DSUM function to calculate cumulative sum in Query? Thank you very much! You can use a subquery. If you need more help …
An error occurred during local report processing
Nov 15, 2010 · The expression for the SQL is part of the GetSQL function: (simplified) Public Function GenSQL (SSN as String) as String Dim SQL as String SQL="select * from members R, …
String tokenizer in sql server 2005/2008 - social.msdn.microsoft.com
Jun 25, 2009 · I have a table with a column having values like Sam_1_Mike_2 and i was looking for in-built function to string tokenize given the special character. But so far, couldn't find any suitable string …
Split comma separated list without using a function
Apr 16, 2015 · I have a table of records with a column with a list separated by commas. I want to split this list and have a row for each however I don't have access to create functions myself. Is there any …