How to locate and take substrings with charindex() and substring() functions?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?

2 Answers  


What is the difference between truncate and delete statement?

6 Answers   CarrizalSoft Technologies, CTS,


Explain the use of containers in ssis?

0 Answers  


ow to bring suspect mode datbase online from scratch

0 Answers  


How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

0 Answers  






How do you send email on SQL Server?

0 Answers   MindCracker,


What is a join in sql?

0 Answers  


What are the difference between “where” and “having” clause in sql server?

0 Answers  


In which files does sql server actually store data?

0 Answers  


What is snapshot replication?

0 Answers  


Give me a SQL Query to find out the second largest company?

0 Answers   Ernst Young,


When you should use a low fill factor?

0 Answers  


Categories