2019-07-09 (first published: 2019-05-01)
772 reads
dynamic
DynamicDateRangeGenerator
Generates # of dates in before/after current year.
No more hardcoded date ranges.
2016-08-08 (first published: 2016-07-28)
588 reads
2012-11-21 (first published: 2012-10-02)
1,431 reads
Automatic Generation of Insert, Update and Delete stored procedures
This script automatically generates stored procedures for insert, update and delete operations on the given table
2009-08-12 (first published: 2009-07-23)
2,097 reads
2008-11-25 (first published: 2008-10-20)
1,304 reads
NewID() in Order By
I have seen examples where NewId() is used in the order by. For example: Select TOP 10 * From Authors ORDER BY NEWID()What does NewID() in the order by clause is responsible for? Thanks in Advance.
2004-11-03
9 reads
RE: Tips for optimizing performance?? - VB/SQL Server
I know nothing about Access, but here are some good tips:http://www.sql-server-performance.com/visual_basic_performance.aspI also suggest reading Andy Warrens Introduction to ADO articles on this site.
2004-01-07
RE: Changing Authentication Modes in SQL Server 2000
Changing to Windows Authentication Only mode won't affect the databases. For instance, when you set up a SQL Server out of the box with Windows Authentication, master, model, msdb, Northwind, pubs, and tempdb are all owned by sa. The db_owner is internal to SQL Server.... it's a mapping between sysxlogins and sysdatabases. So long as […]
2003-07-16
RE: How to convert Character to date
If you want to convert a dd/mm/yyyy string to a datetime value use something like: select convert(datetime, '27/02/2003', 103) or select convert(datetime, BillingDate, 103) The "103" tells the CONVERT function that the string is dd/mm/yyyy format.
2003-07-04
RE: HOw to install sql server 2000 in laptop
quote: Thanks all for valuable suggestion,Actually i want to install sql server 2000 first,than my database and after that my application which is a exe file.All this i want from CD to my laptop in a single click.I want all this for demo purpose. If this is for a demo, you shouldn't need a full […]
2003-06-27
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers