What is the system function to get the current user's user
id?
Answers were Sorted based on User's Feedback
Answer / swapna
USER_ID(). other system functions like USER_NAME(),
SYSTEM_USER, SESSION_USER, CURRENT_USER, USER, SUSER_SID(),
HOST_NAME().
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / tejas
USER_ID no USER_NAME user name gives us the user name not the USER_ID
| Is This Answer Correct ? | 0 Yes | 0 No |
How to loop through the result set with @@fetch_status?
What are the steps you will take to improve the performance of a poor performing query?
How to retrieve error messages using mssql_get_last_message()?
what is a traditional network library for sql servers? : Sql server database administration
What is a livelock?
Explain what are the database objects? : SQL Server Architecture
How do you identify a foreign key?
How can you check the level of fragmentation on a table?
What are the factors you will check for the performane optimization for a database query?
7 Answers CarrizalSoft Technologies, DELL, SoftSol,
What do you understand by mirroring?
What is the dbcc command and why is it used?
How to reaname table name without using sp_Rename in sql server..?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)