Answer / Vikram Pandey

"To define the name and server for a new Data Source Name (DSN) in MS SQL Server, you can use the ODBC Data Source Administrator tool. Here's how:nn1. Open Control Panel.n2. Click on Administrative Tools > Data Sources (ODBC).n3. Click on the `System DSN` tab and then click `Add...`.n4. Select `SQL Server` as the data source, click `Finish`, then fill in the server name and name for your new DSN."

What is user-defined functions? What are the types of user-defined functions that can be created?

1 Answers  

---

you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required

3 Answers  

---

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

1 Answers  

---

is there more the two primary key in a single table?

26 Answers   Eforce, Systematix,

---

Where the sql logs gets stored?

1 Answers  

---

What type of locking occurs during the snapshot generation? : sql server replication

1 Answers  

---

Can we call future method from queueable?

1 Answers  

---

Why use update_statistics command in sql server?

1 Answers  

---

What are the types of stored procedures in an sql server?

1 Answers  

---

to explain sql server 2000 architecture & authentication

1 Answers   HCL,

---

Define synonym?

1 Answers  

---

How can I know what locks are running on which resource?

1 Answers  

---