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 |
Explain the steps to create and execute a user-defined function in the sql server?
How to see the event list of an existing trigger using sys.trigger_events?
how to count datewise data in sqlserver
4 Answers CarrizalSoft Technologies, IndusInd Bank,
What are cursors?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
How do I create an extended event in sql server?
Is it possible we can connect our SQL database to GUI application? If it is yes than how tell me the explanation
Explain what is analysis service repository?
select top 5 * from emp order by newid() my question is , how this query get executed?
What would be the Expected Salary For SQL Server Developer for 3 years exp. as per indian market?
How can you tell if a database object is invalid?
Where is localdb stored?
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)