Answer Posted / soorai ganesh

If u Use SQLSERVER 2005. This will helpful to you


CREATE RULE myRule AS @strGrade IN('I','II','III','IV')
GO
CREATE TABLE myTable
(
empID INT,
empName VARCHAR(50),
empGrade VARCHAR(3),
empSalary NUMERIC(9,2)
);
GO
sp_bindrule myRule, 'myTable.empGrade';
GO


INSERT INTO myTable VALUES(1,'Ganesh','I',59000) -- Valid
INSERT INTO myTable VALUES(1,'Ganesh','II',89000) -- Valid
INSERT INTO myTable VALUES(1,'Ganesh','III',99000) -- Valid
INSERT INTO myTable VALUES(1,'Ganesh','IV',259000) -- Valid
INSERT INTO myTable VALUES(1,'Ganesh','V',259000) --
Invalid

Explain trigger and trigger types?

916

---

Write an sql query to find first weekday of the month?

867

---

Can we update data in a view?

974

---

Can primary key be a foreign key?

999

---

What is the library index called?

1007

---

Explain magic tables in sql server?

985

---

How to set the current database in ms sql server?

1014

---

What new changes are being made in SQL Server?

1104

---

How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

1003

---

Benefits of Stored Procedures?

921

---

what is raid and what are different types of raid configurations? : Sql server database administration

976

---

What are the different types of columns types constraints in the sql server?

1014

---

what is checksum in sql server.........???

1624

---

What are unicode character string data types in ms sql server?

1150

---

What does null mean?

941

---