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

You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

1145

---

What is the use of toad or sqldbx.?

1204

---

Can a unique index be created on a column, which contains null?

969

---

What is the difference between stored procedure and functions?

1201

---

What is store procedure? How do they work?

1071

---

What is service broker?

1063

---

What are clustered and non-clustered index?

1053

---

Explain datetimeoffset data type in sal server 2008?

974

---

What is user-defined functions? What are the types of user-defined functions that can be created?

1085

---

How to truncate the log in sql server 2012? : sql server database administration

1347

---

How to filter out duplications in the returning rows in ms sql server?

1218

---

How to create a dynamic cursor with the dynamic option?

1108

---

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

1059

---

How to get a list of columns in a view using the "sp_help" stored procedure?

1095

---

Explain syntax for dropping triggers?

969

---