if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition1 1599
How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)5 6094
How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.8 24532
Difference between sql server 2000 and sql server 2005?11 44201
How to find the date and time of last updated table?3 5883
how to do partition in sqlserver
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
whats the maximum size of view state??
OPTIMIZATION OF SP,CURSOR,TRIGGERS
whats new about truncate in sql server 2008?
Why do you want to join software field as you have done your BE in Electronics?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
role of sql sever 2005 in database rather than any other database
how many no of arguments can be passed in procedures and functions
ow to bring suspect mode datbase online from scratch
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
your distribution database is full what will u do
1 01 101 01010
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?