i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?

5 Answers   Aptech,

---

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

0 Answers  

---

How to set the current database in ms sql server?

0 Answers  

---

List the data types available in mssql?

0 Answers  

---

What are the two virtual tables SQL Server maintains for triggers?

3 Answers  

---

---

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

0 Answers  

---

What do you understand by a view?

0 Answers  

---

What is the difference between a Application Server and a Database

3 Answers   Oracle,

---

What is the difference between substr and charindex in the sql server?

0 Answers  

---

What is a view and what are its advantages?

0 Answers  

---

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

0 Answers  

---

when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql

1 Answers  

---