在SQL中创建函数 [英] Create Function in SQL

问题描述

我对SQL中的函数不熟悉.我想通过使用SQL中的函数从表中获取所有列名.

我的示例查询用于从表(Bill_Transaction)获取所有列名，如下所示:

Hi,

I''m not familiar with Functions in SQL. I want to get all the column name from table by using Functions in SQL.

My sample query which use to get all column name from table(Bill_Transaction) show as below:

Select A.name From dbo.syscolumns As A
Inner Join dbo.sysobjects As B ON A.ID=B.ID
Where B.name = N'BillTransaction'

表Bill_Transaction中的列是ID，TransactionNo，BillNo，Amount，Date

如何在SQL中创建不包含列名ID的函数.希望能尽快得到大家的帮助.


预先谢谢您.

The columns in the Table Bill_Transaction are ID, TransactionNo,BillNo,Amount,Date

How to create Functions in SQL which exclude the column name ID. I hope that can get help from all of you as soon as possible.


Thank you in advance.

推荐答案

您的查询看起来像这样:

Your query would look something like this:

SELECT
     A.name
FROM
    dbo.syscolumns AS A INNER JOIN dbo.sysobjects AS B ON
        A.ID = B.ID
WHERE
     B.name = N'BillTransaction' AND A.Name NOT IN ('ID')

在这里查看如何在SQL中创建函数.

http://msdn.microsoft.com/en-us/library/ms186755 (v = sql.105).aspx [

Look here on how to create functions in SQL.

http://msdn.microsoft.com/en-us/library/ms186755(v=sql.105).aspx[^]

创建函数确实非常简单，请阅读以下文章，您一定会熟悉SQL函数.

MSDN:创建功能 [ http://msdn.microsoft.com/en-us/library/aa258899 (v = sql.80).aspx [ SQL函数 [ google [

Creating function is really very easy, have a look on following articles and you will surely get familiar with SQL Functions.

MSDN: CREATE FUNCTION[^]
http://msdn.microsoft.com/en-us/library/aa258899(v=sql.80).aspx[^]

W3School: SQL Functions[^]

Get more similar threads on google[^]

这篇关于在SQL中创建函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！