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 condition
1 3617How 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 10934How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.
8 32848Difference between sql server 2000 and sql server 2005?
Aditi Tech, eInfochips, GE, HCL, IBM, Masim Infotech, NIIT, Satyam, Systems Domain,
11 53147
What happens if strings are casted into wrong code pages in ms sql server?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
What is normalization and its types?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
Explain the third normal form(3nf)?
Explain system views?
What are indexes in sql?
Explain candidate key, alternate key, and composite key?
What are different types of table joins?
What is the difference between system objects and user objects?
What are the authentication modes in sql server? How can it be changed?
What are the advantages dts has over bcp?
What are the steps you will take to improve the performance of a poor performing query?
What is the maximum length of an alert name?
Differentiate sql server reporting services vs. Crystal reports?