Skip to content
IT Nursery
  • Home
  • Programming
    • Mac / IOS
    • Android
    • Web Applications
    • PHP
    • Java
    • C
    • C++
  • DataBase
    • MySQL
  • CMS
    • WordPress
  • System and Network
    • Serverfault

functions

Finding five-minute interval prior to current time

by IT Nursery

I want to find the five minute interval just before the current time. So if the current time is 8:43 I want to … Read more

Tags functions, MySQL, timestamp

Function/procedure to use dblink to fetch remote data and insert to multiple local tables

by IT Nursery

Am trying to fetch data from remote db and insert into three local tables. Currently I have a query which is successfully getting … Read more

Tags functions, postgresql, stored-procedures

Is a query with UNIX_TIMESTAMP using indexes in mysql?

by IT Nursery

If I use .. WHERE UNIX_TIMESTAMP(`some_timestamp`)>NOW() in a SELECT, does this query still make use on an index, set on some_timestamp ? 1 … Read more

Tags functions, index, MySQL, optimization

Pass Parameters to trigger function to execute dynamic SQL

by IT Nursery

I have this code which was solved by Erwin: Execute dynamic INSERT ON CONFLICT DO UPDATE in plpgsql function Now I want the … Read more

Tags dynamic-sql, functions, insert, plpgsql, trigger

SQL Function, get value to send to CLR

by IT Nursery

I have a CLR to use the powershell to have access to the RichTextBox Object from .net. On the SQL Function I have … Read more

Tags functions, sql-clr, sql-server

How Can the Same Query in Two Nearly Identical Instances Generate Two Different Execution Plans?

by IT Nursery

Server A and Server B have identical hardware and instance configurations (A is Production, B is QA). B’s DBs were restored from A’s … Read more

Tags cross-apply, execution-plan, functions, sql-server-2008-r2, subquery

Untyped functions that return tables

by IT Nursery

I would like to write a PostgreSQL stored function that essentially behaves like the stored procedures I know and love from MSSQL and … Read more

Tags datatypes, functions, plpgsql, postgresql

Why would call to scalar function inside a Table Value Function be slower than outside the TVF?

by IT Nursery

I am writing a Table Value Function, calling the function takes 10x as long as directly running the code. I traced this to … Read more

Tags functions, performance, sql-server, sql-server-2008-r2

SQL Server: Cannot resolve collation conflict between “Latin1_General_CI_AS” and “[garbage]”

by IT Nursery

So I’m writing a large UDF in T-SQL to be used in reporting. The UDF contains quite a few common table expressions. At … Read more

Tags collation, functions, sql-server, sql-server-2012

PostgreSQL error: remote query result rowtype does not match the specified FROM clause rowtype, on remote function call

by IT Nursery

This is my remote function: CREATE OR REPLACE FUNCTION public._test1() RETURNS record LANGUAGE plpgsql AS $function$ DECLARE rec record; BEGIN select 1,2 into … Read more

Tags dblink, functions, postgresql, postgresql-9.6, remote
Older posts
Page1 Page2 … Page279 Next →

Recent Posts

  • Advice for improving internal dashboard [closed]
  • grep : ‘+’ special character
  • File location for Syslogs in Centos machine
  • How to collect users’ task completion times?
  • “service {FOO} start” vs. “/etc/init.d/{FOO} start”? [closed]
IT Nursery
Creative Commons License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.

Important Link

  • About
  • Privacy Policy
  • Contact

IT Nursery

The Goal of ITNursery Engaging the world to foster innovation through aggregate information. Our Question Answer post, blog information, products and tools help developers and technologists in life and at work.

copyright © 2023 All Right Reserved | IT NurSery