Answer Posted / jahir

refer below, actually its not primary key, Its Composite Key

CREATE TABLE [LoginHist] (
[UserId] [char] (15) NOT NULL ,
[LogDate] [smalldatetime] NOT NULL ,
[ClientIp] [char] (15) NOT NULL ,
[LoginCount] [int] NULL DEFAULT (0),
CONSTRAINT [PK_LoginHist] PRIMARY KEY CLUSTERED
(
[UserId],
[LogDate],
[ClientIp]
) ON [PRIMARY]
) ON [PRIMARY]

How can you fetch alternate records from a table?

1013

---

What is sql service broker?

1019

---

Explain atomicity?

1123

---

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

1160

---

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

2058

---

Explain logical operators in sql server?

1178

---

What is the difference RDBMS and Graph Database?

1091

---

What is the usage of sign function?

1171

---

Explain the concepts and capabilities of sql server?

1009

---

Explain features of analysis services?

1079

---

What are the extra roles available in msdb? : sql server security

1178

---

in the physical file layout, where should the transaction log be stored in relation to the data file?

1038

---

What is clustered primary key?

1080

---

What is triggers and its types?

1064

---

what is the system function to get the current user's user id? : Sql server database administration

1068

---