How to genrate automaticlly empid like gt001

4 Answers  

---

Is port 1433 secure?

0 Answers  

---

what purpose does the model database serve? : Sql server database administration

0 Answers  

---

application server is slow what may be the problem

0 Answers   Microsoft,

---

How you would rewrite the sql query to return the customerid sorted numerically?

0 Answers  

---

What are date and time data types in ms sql server?

0 Answers  

---

Can you tell me some of the common replication dmv's and their use? : sql server replication

0 Answers  

---

What are the differences between char and nchar in ms sql server?

0 Answers  

---

write sql program to get the detail of student in a class?

2 Answers  

---

i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L

8 Answers  

---

Psudo colums

1 Answers   HP,

---

create table with fields ID, reserved_by,res_date res_date is datefield like 2010-03-09 00:00:00.000 from 2005 to 2006 any date assume based on res_date need to slect table and display based on month (full jan details in database irrespective of date and year

3 Answers  

---