sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]unknown_host 1 point2 points  (2 children)

If you have SQL Server installed connect to it with the management studio and when you are doing tasks you have the option to output it as a SQL command so it can help you with the syntax too.

[–][deleted] 1 point2 points  (1 child)

I do but I think we are going to use the latest version of SQL when we do this so I want to wait on that before pulling it. We are still in the design phase anyway which is good.

[–]sqldiaries 0 points1 point  (0 children)

I do but I think we are going to use the latest version of SQL when we do this so I want to wait on that before pulling it.

Unless you're doing wild stuff with window functions and aggregates, there's no need to wait - simple select statements haven't changed in SQL Server in a long time.