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 |
How to list all tables having unique constraints in any of the columns in a database.
What is database dimension? : sql server analysis services, ssas
wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is these mean and wt actions it's perform
How will you make an attribute not process? : sql server analysis services, ssas
Define cross join in sql server joins?
How many columns can exist together per table?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
What types of integrity are enforced by a foreign-key constraint
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
How many types of indexes are there in SQL Server?
6 Answers CarrizalSoft Technologies, United Healthcare,
How many primary keys are possible in a table?
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)