Answer Posted / naren

select * from table_name where Name like 'A%'
union
select * from table_name where Name like 'B%'
union
select * from table_name where Name like 'C%'

Write a query for primary key constraint with identity key word?

1043

---

What is the tcp/ip port on which sql server runs?

1171

---

What is a functions and types in sql server?

1094

---

How to delete database objects with "drop" statements in ms sql server?

1097

---

How to use old values to define new values in update statements in ms sql server?

1280

---

Do you know what is normalization of database? What are its benefits?

1127

---

What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.

1276

---

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1923

---

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

2353

---

List the data types available in mssql?

1042

---

Explain what are the restrictions that views have to follow? : SQL Server Architecture

1056

---

What is the maximum size of a row in sql server?

974

---

Can group functions be mixed with non-group selection fields in ms sql server?

951

---

Does order by actually change the order of the data in the tables or does it just change the output?

1152

---

Write an sql query for deleting duplicate rows?

1003

---