This blog is most useful for Software Engineers, Database Administrators, QA and etc.
Mar 13, 2009
Welcome onboard - Microsoft SQL Server: Configuring Linked Server from SQL Server to MySQL
Welcome onboard - Microsoft SQL Server: Configuring Linked Server from SQL Server to MySQL: "ODBC 3.51"
INFI Developer
INFI Developer: "Communication between the MySQL server and the MS SQL Server on TCP port 3306. TCP port 3306 is the default port; you can use a different port if you want to.":Linked servers
Mar 5, 2009
Mar 4, 2009
How to get the name of the day of date
That should be DATENAME(dw,'3 sep 2007')
Labels:
datetime function,
sql,
sql server
Mar 3, 2009
Subscribe to:
Posts (Atom)
But I prefer using fully qulified names DATENAME(weekday,'3 sep 2007')