Answer / swapna

USER_ID(). Also check out other system functions like
USER_NAME(), SYSTEM_USER, SESSION_USER, CURRENT_USER, USER,
SUSER_SID(), HOST_NAME().

Answer / hcl

select * from dbo.sysprocesses

Answer / naren

13.select * from sysprocesses
where loginame like '324%'----diply the all ohrid's in the
server

1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?

1 Answers   Techno Solutions,

---

Explain logical operators in sql server?

0 Answers  

---

how to improve the speed of SQL database server and how to avoid dead lock?

1 Answers   TCS,

---

How do you test your database? : sql server database administration

0 Answers  

---

How to create prepared statements using odbc_prepare()?

0 Answers  

---

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

0 Answers  

---

How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?

1 Answers  

---

How the authentication mode can be changed?

0 Answers  

---

What are the different types of joins and what does each do?

2 Answers  

---

What is the difference between function and stored procedure in sql server?

0 Answers  

---

When would you use the stored procedures or functions?

0 Answers  

---

What is the difference between Clustered and Non-Clustered Index?

0 Answers  

---