Answer Posted / suraj

Yes, we can.
Eg:
create proc Test
as
select getdate()
GO

-- EXEC Test
-- in the above query getdate() is a system function.

How to create a view with data from multiple tables?

1007

---

Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

2385

---

Does union all remove duplicates?

1057

---

What are the requirements to use odbc connections in php scripts?

1110

---

What is database replication? What are the different types of replication you can set up in sql server?

954

---

How to sort query output in descending order in ms sql server?

941

---

what method you can use to reduce the overhead of Reporting Services data sources?

253

---

Explain Geography datatype in SQL Server

1117

---

Can you explain what is indexed view? How to create it?

890

---

How we create SQL Server 2005 Reporting Services ? Give me Sample

1982

---

List out the difference between union and union all in sql server?

983

---

How many null values we can have in a unique key field in sql server?

944

---

What is the difference between local and global temporary tables?

1133

---

How can we remove orphan records from a table?

977

---

How many clustered indexes there can be on table ?

1021

---