Dec 31, 2018 · Thank you so much for your suggestion. the function you suggested has hardcore the value based on the paramaeters passed .i want to increment +1 whenever i call the function.

May 31, 2016 · The way to convert Agent Tokens to T-SQL is to convert the ESCAPE_SQUOTE macro into T-SQL code. You can use parameters and insert the correct value to the parameter.

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.

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'; …

Mar 25, 2018 · 1. If you want to alter the table in order to replace the "full name" column with three separate columns the first step will be to add these new columns, secondly we will split the data from …

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 …

Jan 15, 2012 · Question 0 Sign in to vote is there any TOOL,function,stored procedure to convert sql code to SQLCMD like i put my code and it convert and print the code in format "SQLCMD" instead i …

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 …

Aug 8, 2011 · hi amin if you want to convert value to words in Sql Server then make a function and call it i give the simple code for converting integer value to word DECLARE @i int, @temp char (1), @s …

Jun 28, 2013 · You have a different thread about dynamic pivot. Dynamic pivot may be called for in the presenation layer - so start to check with what you can do there. If you do a dynamic pivot in SQL …