select * from table where DBDate between '01/28/2005' and '01/29/2005'You just have to remember that '01/28/2005' really means '01/28/2005 00:00:00.000' when compared to a datetime.Greg
2005-01-28
Hi,I am writing a piece of code which will be multi-threading, and may even be running on several machines at once.The code needs to read data out of a database, perform some actions on it and then write the result back to the database. To reduce server round-trips, I am thinking of getting a 'chunk' […]
2005-01-27
2 reads
Hello I m having a table with following structure and data Point_TableBNO int GNO int Point intData BNO GNO Point 1 1 6 1 2 8 1 3 3 1 4 10 2 1 1 2 2 2 2 3 4 2 4 6Now i want to print data like a matrix ie BID/GID 1 2 3 4 1 6 8 3 10 2 1 2 4 6 3 4 is it possible to write a query for SQL SERVER to get this type […]
2005-01-27
Presumably because in a command window, $PATH contains the path to where TCL exists.Try giving the full pathname to the TCL program. Example, assuming it's "C:\Program Files\TCL\TCL.EXE" exec master..xp_cmdshell "C:\Program Files\TCL\TCL.EXE c:\tcl_scripts\finddate.tcl"
2005-01-27
Do:SELECT * FROM INFORMATION_SCHEMA.SCHEMATA WHERE CATALOG_NAME NOT IN ('master', 'model', 'tempdb', 'msdb', 'pubs', 'northwind')sp_MSforeachDB is undocumented, and directly querying the system tables isn't the best solution either.
2005-01-25
Would there be some way to put a COM wrapper around the assembly and use com in your stored procedure?Russ
2005-01-25
Yes there is, but I figured out how to use a trigger to enforce the constraint. In fact there was a perfect example of what I needed in the BOL in the section about triggers.
2005-01-21
Since this v6.5, the first 2 Mb of tempdb by default are on the master device. Based on how large you want to grow it you will have to add another device first (using the 'disk init' SQL command). Next alter the tempdb to expand it's combined data and log onto the new disk device […]
2005-01-20
2005-01-20
See, if this helps: http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
2005-01-20
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers