Answer Posted / ashutosh rai

Declare @id int,@name varchar(100),@class varchar(100)
set @id=1
set @name='Ashutosh'
set @class='MCA'

insert into student_table(id,name,class)
values(@id,@name,@class)

What are the main sources of data?

1040

---

How to receive output values from stored procedures?

1057

---

What is the cpu pressure?

994

---

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

934

---

What is sql server used for?

991

---

What is similarity and difference between truncate and delete in sql?

1032

---

What is data modeling and Reterminal integrity?

1905

---

How will you find out if there are expensive SQL statements running or not?

969

---

How to list all schemas in a database?

1005

---

What happens if null values are involved in boolean operations?

942

---

Why are you getting errors when creating a new odbc dsn?

1169

---

What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

971

---

Explain “row_number()” in sql server with an example?

950

---

How is sql used in sql server?

944

---

What is difference between joins and subqueries?

1053

---