i have following UDF in SQL-Server 2005. It\'s joining a Table and concatenates all rows with a separator to one scalar value. Because i need it for other tables too, i wondered how to make it dynamic
I have 2 table-valued function that are very similar, the only difference is that I need one additional Max() call on the second one.I want to consolidate these into one but I can\'t quite figure out
All, This is a follow up for my question here. My setup: Visual Studio 10 Language C# Excel 2007+ W开发者_运维百科indows XP+
I am trying to port some sql from MySQL to SQLite, however we use mysql\'s md5() function, which doesn\'t exist in sqlite.
I found a very strange bug in MySQL that i\'ve reported here: Bug #60166 Can anyone confirm to me that this is a bug, and not an unde开发者_如何学JAVArstanding problem of how work MySQL? (Valeriy K
It looks like select * in a UDF is dangerous.Consider this script: create table TestTable (col1 int, col2 varchar(1))
I just simply want to create a function name with a stri开发者_开发百科ng value. Something like this:
How to create mysql user defined function with PHP, is that straight away passing whole create mysql UDF code in mysql_query function ?
I have a 5 year data set partitioned into quarterly tables. I also have a master view that joins them all together. When a user needs more than one quarter of data they often use the master view inste
I am re-wr开发者_运维百科iting some code to make functional changes and I am stuck at a situation where either I will need to overload a function to accommodate two or three types of parameters (but p
加载中,请稍侯......