Look at Table-valued functions in SQL Server 2005
Table-valued functions are used to return TABLE datatype.
Search Results
Search found 9082 results on 364 pages for 'c functions'.
Page 7/364 | < Previous Page | 3 4 5 6 7 8 9 10 11 12 13 14 | Next Page >
-
-
Visualizing Complex Functions
A program to produce beautiful and informative images of complex functions.Read the article
-
Lua - Reflection - Get list of functions/fields on an object?
- by luanoob
I'm new to Lua and dealing with Lua as a scripting language in an alpha release of a program. The developer is unresponsive and I need to get a list of functions provided by some C++ objects which are accessible from the Lua code. Is there any easy way to see what fields and functions these objects expose?Read the article
-
Function like C# properties?
- by alan2here
I was directed here from SO as a better stack exchange site for this question. I've been thinking about the neatness and expression of C# properties over functions, although they only currently work where no parameters are used, and wondered. Is is possible, and if so why not, to have a stand alone function like C# property. For example: public…Read the article
-
Calling Web Service Functions Asynchronously from a Web Page
- by SGWellens
Over on the Asp.Net forums where I moderate, a user had a problem calling a Web Service from a web page asynchronously. I tried his code on my machine and was able to reproduce the problem. I was able to solve his problem, but only after taking the long scenic route through some of the more perplexing nuances of Web Services and Proxies. Here is…Read the article
-
organization of DLL linked functions
- by m25
So this is a code organization question. I got my basic code working but when I expand it will be terrible. I have a DLL that I don't have a .lib for. Therefore I have to use the whole loadLibrary()/getprocaddress() combo. it works great. But this DLL that i'm referencing at 100+ functions. my current process is (1) typedef a type for the…Read the article
-
String manipulation functions in SQL Server 2000 / 2005
- by Vipin
SQL Server provides a range of string manipulation functions. I was aware of most of those in back of the mind, but when I needed to use one, I had to dig it out either from SQL server help file or from google. So, I thought I will list some of the functions which performs some common operations in SQL server. Hope it will be helpful…Read the article
-
T-SQL Equivalents for Microsoft Access VBA Functions
If you need to migrate your Access application to SQL Server, don't count on The SQL Server Upsize Wizard in Microsoft Access to automatically convert your VBA functions. If you want to push the complex query processing done by your Access queries to the back end, you'll have to rewrite them in T-SQL.Read the article
-
Survey: Do you write custom SQL CLR procedures/functions/etc
- by James Luetkehoelter
I'm quite curious because despite the great capabilities of writing CLR-based stored procedures to off-load those nasty operations TSQL isn't that great at (like iteration, or complex math), I'm continuing to see a wealth of SQL 2008 databases with complex stored procedures and functions which would make great candidates. The in-house…Read the article
-
Survey: Do you write custom SQL CLR procedures/functions/etc
- by James Luetkehoelter
I'm quite curious because despite the great capabilities of writing CLR-based stored procedures to off-load those nasty operations TSQL isn't that great at (like iteration, or complex math), I'm continuing to see a wealth of SQL 2008 databases with complex stored procedures and functions which would make great candidates. The in-house…Read the article
-
Using virtual functions
- by Tucker Morgan
I am starting to use virtual functions, and i am programming a simple text game, my question is this, if i have a virtual function called spec_abil with in a Super class called rpg_class. If you allow the player to class what class they want to play, say a mage class, a archer class, and a warrior class, which all have their own…Read the article
-
SQL Server Ranking Functions
A new article from Wayne Sheffield that examines the ranking functions in SQL Server. Learn how you can use ROW_NUMBER(), NTILE(), RANK(), and DENSE_RANK() in your applications. Join SQL Backup’s 35,000+ customers to compress and strengthen your backups "SQL Backup will be a REAL boost to any DBA lucky enough …Read the article
-
how to develop a common pool of functions?
- by user975234
I need to develop an application which runs on the web as well as on mobile platform. I want to make something like a directory where i hold my common functions in respect to web and mobile platform. This is the diagram which describes what i exactly want: I just want to know how do i implement this thing? If you can help me…Read the article
-
Stairway to PowerPivot and DAX - Level 2: The DAX COUNTROWS() and FILTER() Functions
Bill Pearson, business intelligence architect and author, exposes the DAX COUNTROWS() and FILTER() functions, while generally exploring, comparing and contrasting the nature and operation of calculated columns and calculated measures, in the second Level of our Stairway to PowerPivot and DAX series. 12…Read the article
-
Entity framework support for table valued functions and thus full text
- by simonsabin
One of my most popular posts with over 10, 000 hits is how to enable full text when using LINQ to SQL http://sqlblogcasts.com/blogs/simons/archive/2008/12/18/LINQ-to-SQL---Enabling-Fulltext-searching.aspx , core to this is the use of a table valued function. I’m therefore interested to see that Entity Framework will…Read the article
-
Handy Generic JQuery Functions
- by Steve Wilkes
I was a bit of a late-comer to the JQuery party, but now I've been using it for a while it's given me a host of options for adding extra flair to the client side of my applications. Here's a few generic JQuery functions I've written which can be used to add some neat little features to a page. Just call any of them…Read the article
-
jQuery in Action 2nd edition: Queuing functions for execution
This article is taken from the book jQuery in Action, second edition. This segment shows how you can create your own queue to queue up any functions that you'd like to have executed in serial order. An understanding of jQuery animation is assumed. Presented By: NEC Ads by PheedoRead the article
-
How are undocumented functions discovered?
- by Paska
Hi all, I've always wondered how do you find undocumented / private API ? Example the Apple undocumented / private API, Play Station, Windows Phone 7, Win32 Kernel, Windows API, hidden callback, etc... What tools do hackers use to find out about private and undocumented functions? Where can I read about…Read the article
-
The PoSh DBA: Grown-Up PowerShell Functions
Laerte Junior goes step-by-step through the process of tidying up and making more reusable an untidy collection of PowerShell routines, showing how pipelines and advanced functions can make PowerShell more effective in helping to automate many of the working DBA's chores. What are your…Read the article
-
DAX Statistical Functions
Following on from his first four articles on using Data Analysis Expressions (DAX) with tabular databases, Robert Sheldon dives into some of the DAX statistical functions available, demonstrating which are the most useful and examples of how they work. The seven tools in the SQL DBA…Read the article
-
Map multiple functions over a single data item
- by Linus Norton
I'm in the process of learning Scala and I came across a scenario today where I need to map multiple functions over a single piece of data and wondered if there was a formal name for this. It sort of feels like the inverse of map. I'm not sure this is the correct way of expressing it, but this is…Read the article
-
How to encapsulate the helper functions(commonly used apis) in a OOP language like java?
- by user198729
These functions may be hard to fit into a specific class, what's the best practice to deal with them?Read the article
-
Handy SQL Server Functions Series (HSSFS) Part 2.0 - Prelude to Parsing Patterns Properly
- by Most Valuable Yak (Rob Volk)
In Part 1 of the series I wrote about 2 lesser-known and somewhat undocumented functions. In this part, I'm going to cover some familiar string functions like Substring(), Parsename(), Patindex(), and Charindex() and delve into their strengths and weaknesses. I'm also splitting this part up into…Read the article
-
How to restrict an access to some of the functions at third level in Classes (OOPs)
- by Shantanu Gupta
I have created a class say A which has some functions defined as protected. Now Class B inherits A and class C inherits B. Class A has private default constructor and protected parameterized constructor. I want Class B to be able to access all the protected functions defined in Class A but…Read the article
-
Problem with using the XPATH functions
- by Alex
I've got a problem with using the XPATH functions. When I try to call some functions like lower-case or upper-case etc,they are not executed and I can't figure the problem out. I included the namespace xmlns:fn="http://www.w3.org/2005/xpath-functions" at the top of my XSL stylesheet and use…Read the article
