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 |
What is the size of transaction log file?
What are the steps you can take to avoid “deadlocks”?
Explain about remote stored procedure?
How to truncate the log in sql server 2012? : sql server database administration
How to throw custom exception in Stored Procedure?
Can we join two tables without primary key?
Tell me the difference between clustered and non-clustered index?
What is sql server management studio? : sql server management studio
What is the Difference Between Primary and Foreign Key?
0 Answers Accenture, Deloitte, JPMorgan Chase, Maveric,
how to dispaly a particular row details from a given table
what is the output for this query select * from employee where 1=1;
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
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)