Select convert(varchar(10),getdate(),108)

use XDataBase
CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'password'
go

Select case
				when isNull(a.[USER_ID],0)=0 Then char(43)
				when isNull(t.[USER_ID],0)=0 Then char(45)
				else char(160)
		end as ind, count(*)
from T1 t
left outer join T2 a on
				t.ASSIGNMENT_ID = a.ASSIGNMENT_ID
group by ind
order by ind

Select Col1, Col2 from Table1 where Colx = 'A5100650867'

Col1                         Col2
E-mail Address	            xyz@GMAIL.com
Web Site                      www.GOOGLE.com

E-mail Address         Web Site
xyz@GMAIL.com           www.GOOGLE.com

            Dim Path As String = "C:\DBInfo.xml"
            Dim doc As System.Xml.XmlDocument
            Dim nodeList As System.Xml.XmlNodeList

            Dim strConn As String
            Dim objSqlConn As SqlConnection

            doc = New XmlDocument()
            doc.Load(Path)
            node

<connectionStrings>
       <add name="MyDBConnection" connectionString="server=Server1; database=Req1; uid=sa; pwd=;" />
</connectionStrings>