Welcome
SQLAdvice.com is an online community for SQL Experts, Users, and anyone interested in learning more about SQL and databases. In addition to our Forums and Blogs, be sure to check out the mailing lists, which presently require a separate login.
-
Contents Drawing simple, complex, and any queries you need Adjusting queries to your needs Making maximum use of query results Summary Creating queries and managing query results have been greatly improved and visualized thanks to contemporary GUIs of...
-
I have written several articles based on my experience and the tips of my colleagues. Read the first article on how to create any queries effortlessly and visually here . Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live...
-
Hi everyone! Yes, I have started blogging again. I'm over on pentonizer.com now. Please join me there. Share this post: email it! | bookmark it! | digg it! | reddit! | kick it! | live it! Sponsor...
-
If you need to know the version you are currently running of SQL Server you can easily get it by running the following query. SELECT ' SQL Server ' + CONVERT ( varchar ( 100 ),SERVERPROPERTY( ' productversion ' )) + ' - ' + CONVERT ( varchar ( 100 ),SERVERPROPERTY(...
-
I have noticed that at times I will have a stored procedure start to take an unusual amount of time to complete. In trying to debug this I grab the SQL that is being called from the application and paste it into SQL Server Management Studio only to have...