Sign Up Login


  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is the system function to get the current user's user
id?

Question Posted / swapna

Answers were Sorted based on User's Feedback



What is the system function to get the current user's user id?..

Answer / swapna

USER_ID(). Also check out other system functions like
USER_NAME(), SYSTEM_USER, SESSION_USER, CURRENT_USER, USER,
SUSER_SID(), HOST_NAME().

Is This Answer Correct ?    6 Yes 0 No

What is the system function to get the current user's user id?..

Answer / hcl

select * from dbo.sysprocesses

Is This Answer Correct ?    0 Yes 0 No

What is the system function to get the current user's user id?..

Answer / naren

13.select * from sysprocesses
where loginame like '324%'----diply the all ohrid's in the
server

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More SQL Server Interview Questions

Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz

3 Answers  

What is a trigger? Why we need it?

0 Answers   Accenture,

In which year relase the 7.0& 2000 & 2005?

1 Answers  

What do you understand by intent locks?

0 Answers  

What is bcp? When does it use?

0 Answers  




How data can be copied from one table to another table?

0 Answers  

What is advantage data architect?

0 Answers  

What are the differences between DDL, DML and DCL in SQL?

0 Answers   ABB, Aspire, Infogain,

What does sql server mean?

0 Answers  

How is table type constraint applied to a table?

0 Answers  

Can I delete event logs?

0 Answers  

What is a schema in ms sql server 2005?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories