Solved

I want a field to show system user. what type of field should I create?

Posted on 2009-07-13
2
176 Views
Last Modified: 2012-05-07
what type of field can be used for system user?
is that a varchar2 field?
0
Comment
Question by:ba_trainer
2 Comments
 
LVL 73

Accepted Solution

by:
sdstuber earned 500 total points
ID: 24840326
yes  varchar2(30)

or if you want something more generic...

user_users.username%type;
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 24840329
By default it would be stored in SQL Server as sysname type.

You can store it in either varchar / nvarchar data type
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How to use left join to take all data from master table? 11 60
Sql Stored Procedure field variable 17 30
Help Required 3 95
SQL Query assistance 16 23
As they say in love and is true in SQL: you can sum some Data some of the time, but you can't always aggregate all Data all the time! Introduction: By the end of this Article it is my intention to bring the meaning and value of the above quote to…
'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question