Answer / s. elaiyaraja

Default is the column value used in the sql.

if you set default value in the columns when creating the
table then the insertion part if you are not passing the
value to this column the the default value will set for
this column.

For example varchar columns are defined as null value for
default value.

Answer / kishore

select count(*) NoOfColumns from SYSCOLUMNS
WHERE id= (Select id from SYSOBJECTS where name = 'city')

In this querry may name is Tablename

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

0 Answers  

---

Does sql server 2016 have ssms?

0 Answers  

---

What is a join in sql? What are the types of joins?

0 Answers  

---

What is the xml datatype?

0 Answers  

---

Why union all is faster than union?

0 Answers  

---

---

List the different index configurations possible for a table?

0 Answers  

---

What are pages and extents? : SQL Server Architecture

0 Answers  

---

what is integrated security (SSPI). why we use in the connection string?

2 Answers  

---

You want to implement the one-to-many relationship while designing tables. How would you do it?

0 Answers  

---

Explain transaction server distributed transaction?

0 Answers  

---

How do I view a stored procedure in sql server?

0 Answers  

---

What is the difference between nvl and nvl2?

0 Answers  

---