What is the system function to get the current user's user
id?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can I change procedure name in sql server?

529


Tell me about normalization in DBMS.

576


What are information schema views?

540


Explain what are the different index configurations a table can have?

683


Explain time data type in sal server 2008?

542






you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

533


What are subquery and its properties?

567


What are the kinds of subquery?

521


Do you know the cursor optimization tips?

572


What is difference between join and natural join?

471


What is a derived table?

501


How to generate create table script on an existing table in ms sql server?

632


What is a periodical index?

499


What is the difference between a check constraint and a rule?

618


Difference between report and query parameter. Why do we need different type of parameter?

561