Export (0) Print
Expand All
ABS
ALL
AND
ANY
AVG
bit
COS
COT
DAY
EXP
GO
IN
LEN
LOG
MAX
MIN
NOT
OR
PI
SET
SIN
STR
SUM
TAN
USE
VAR
Expand Minimize

CURRENT_USER

SQL Server 2000

Returns the current user. This function is equivalent to USER_NAME().

Syntax

CURRENT_USER

Return Types

sysname

Examples
A. Use CURRENT_USER to return the current username

This example declares a variable as char, assigns the current value of CURRENT_USER to it, and then returns the variable with a text description.

SELECT 'The current user is: '+ convert(char(30), CURRENT_USER)

Here is the result set:

--------------------------------------------------- 
The current user is: dbo                            

(1 row(s) affected)
B. Use CURRENT_USER as a DEFAULT constraint

This example creates a table that uses CURRENT_USER as a DEFAULT constraint for the order_person column on a sales row.

USE pubs
IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
      WHERE TABLE_NAME = 'orders2')
   DROP TABLE orders2
GO
SET NOCOUNT ON
CREATE TABLE orders2
(
 order_id int IDENTITY(1000, 1) NOT NULL,
 cust_id  int NOT NULL,
 order_date datetime NOT NULL DEFAULT GETDATE(),
 order_amt money NOT NULL,
 order_person char(30) NOT NULL DEFAULT CURRENT_USER
)
GO
INSERT orders2 (cust_id, order_amt)
VALUES (5105, 577.95)
GO
SET NOCOUNT OFF

This query selects all information from the orders2 table.

SELECT * 
FROM orders2

Here is the result set:

order_id    cust_id     order_date             order_amt    order_person                   
----------- ----------- ------------------- ------------- -------------- 
1000        5105        Mar 4 1998 10:13AM      577.95           dbo                            

(1 row(s) affected)

See Also

ALTER TABLE

CREATE TABLE

System Functions

Show:
© 2014 Microsoft