write down the sql query?
Table Name : emp1
Table Name : emp2
What is the difference between Stored Procedure , Function and Package, 1. how many blocks in Package and what are they.
select top 5 * from emp order by newid() my question is , how this query get executed?5 7389
how can u select the Distinct values in the table, table having 20 columns , i want all columns2 5194
How to select Distinct columns from the table, table having 20 columns and i want all coulmns5 6632
What is The Use Of TIMESTAMP DataType in SQL Server 2005?6 17303
application server is slow what may be the problem
what is the Ticketing tool used in Wipro technologies at Bangalore...???
where the connection string store in the database
whats new about truncate in sql server 2008?
Call by value and call by reference in procedure and function, with NOCOPY.
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
ow to bring suspect mode datbase online from scratch
what exactly sql injuction.how to overcome.....
If a stored procedure is taking a table data type, how it looks?
Comment,Datatypes are unlimited
your distribution database is full what will u do
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
what are the Prerequisites for Replication?
Why do you want to join software field as you have done your BE in Electronics?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?