How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

0 Answers  

---

How to replace given values with null using nullif()?

0 Answers  

---

Does a full backup include transaction log?

0 Answers  

---

What are the restrictions while creating batches in sql server?

0 Answers  

---

wat is the main diff between sql server 2000and sql server 2005

6 Answers   Jade Software,

---

---

What are the approximate numeric data types?

0 Answers  

---

Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.

2 Answers   Techno Solutions,

---

What are the advantages of sql stored procedure?

0 Answers  

---

What is transactional replication?

0 Answers  

---

What is a unique index?

0 Answers  

---

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

0 Answers  

---

what is the difference between delete,drop and truncate

2 Answers   Honeywell, Zomato,

---