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 doing log shipping due to some reasons it is failing. How you will proceed from there

2016

---

Using the customer, and order table in northwind database, please write a query to produce xml?

1005

---

What are the different types of sql server replication? : sql server replication

1154

---

Is null vs coalesce?

815

---

What are the advantages of using third-party tools?

916

---

What are a scheduled jobs or what is a scheduled tasks?

847

---

What is data modification?

895

---

What is autocommit mode in sql server?

1075

---

Explain a join?

1002

---

What are sql dirty pages?

968

---

What is the datatype of rowid?

875

---

What is the command dbcc checkdb used for?

962

---

What is acid db?

838

---

How to use transact-sql statements to access the database engine?

996

---

Do you know what guidelines should be followed to help minimize deadlocks?

920

---