Answer / Gajendera Singh

The syntax for using SQL_VARIANT_PROPERTY in T-SQL (Transact-SQL) varies depending on the specific database version and the property you want to retrieve or set. However, a general example might look like this: SELECT sql_variant_property(column_name, 'BaseType') FROM table_name; To set a property, you can use an UPDATE statement: UPDATE table_name SET column_name = SQL_VARIANT_PROPERTY(column_name, 'UserDefinedType', @userDefinedType) WHERE condition

Why do we use sql constraints?

1 Answers  

---

can i use global variables in stored procedure or function

1 Answers   L&T,

---

What is view explain with example?

1 Answers  

---

Why stored procedure is faster than query?

1 Answers  

---

How many levels can subqueries be nested in a FROM clause?

7 Answers  

---

what are the demerits of sql?

1 Answers  

---

What is query execution plan in sql?

1 Answers  

---

what are the authentication modes in sql server? : Sql dba

1 Answers  

---

Is sql microsoft?

1 Answers  

---

if we give update table_name set column_name= default. what will happen? its given in pl sql block.what will hapen?

5 Answers   iFlex,

---

What are sql data types?

1 Answers  

---

How does left join work in sql?

1 Answers  

---