Solved

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

Posted on 2009-07-13
2
177 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 74

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Add different cell to otherwise similiar row 4 45
performance query 4 32
SQL - format decimal in a string 5 39
Check ALL SP in database make sure there are no errors 17 43
I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

856 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