Answer Posted / saravanan p

select * from
(select row_number() over(order by empid) rno,* from tbl)
tbl1
where tbl1.rno=n

How fixed length strings are truncated and padded?

988

---

Differentiate between a local and a global temporary table?

965

---

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1895

---

What happens if an integer is too big for int date type?

984

---

what type of index will get created after executing the above statement? : Sql server database administration

978

---

How do I know if localdb is running?

960

---

How can we check the sql server version?

1078

---

How many types of built in functions are there in sql server 2012?

928

---

Does sql server 2016 have ssms?

969

---

Write down the syntax and an example for create, rename and delete index?

992

---

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1142

---

Do you know the cursor types?

1162

---

Why the trigger fires multiple times in single login?

1220

---

What language is sql server written in?

1045

---

What is the use of sql profiler in sql server 2012?

910

---