<p>Hi there </p> <div></div> <div>I have a column C1 in Excel which contains data as follows:</div> <div></div> <div>C1</div> <div>------</div> <div>111-222-3333</div> <div>mark@client.com</div> <div>Mark Ben</div> <div>Steve Ryn sryn@client.com<...

<p>Hi there</p> <p>Here is a question related to encrypt the whole SQL Server 2008 database.</p> <p>I am not much into encrypting the SQL Server 2008 database, but I am aware of encrypting and decrypting the data in a table by creating a master key,...

<p>Hi <b>Jacob</b></p> <p>Greetings!!!</p> <p>I have multiple update statements like below in stored procedures.</p> <p>UPDATE T3 SET PID = S2.PID<br />FROM S1, S2<br />WHERE S1.PID = S2.PID<br />AND S2.PID IN ('ABC','RFZ')</p> <p>The stored procedure ...

<p>I have FOR XML issue where the output should be: </p> <div><br /></div> <div><Root><Data EMPNO="7839" ENAME="KING" SAL="5000"><b>10</b></Data></div> <div><br /></div> <div>-- XML Query: I made the query as below but the result...