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(). 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 |
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 |
Write a sql query to get zero records from a table having n number of records?
How to receive returning result from a query?
What is the order in which the SQL query is executed? list them in order.
5 Answers CarrizalSoft Technologies, CTS, Oracle,
What is transaction server auto commit?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
how can you check the level of fragmentation on a table? : Sql server administration
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
Does group by sort data?
How to change location of errorlog in SQL?
How will you optimize a stored procedure optimization?
Write the syntax for stuff function in an sql server?
What is data compression? : sql server database administration
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)