Viewing 15 posts - 331 through 345 (of 498 total)
I don't think you will be able to do that. However you could create a function in Access that duplicates the functionality.
Why not create a View with the date fields...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 16, 2003 at 7:55 pm
I'd probably be even more lazy(?). Since I use Visual Studio for all my dev work I would simply create a project with all the files. Then have Visual Studio...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 16, 2003 at 7:49 pm
lambje,
What "Gary" are you refering to? 🙂
I was responding to Gary Billins question on Excel files only. For text files I would use BCP as stated above. But for...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 16, 2003 at 7:40 pm
I've always just used a macro in Visual Studio for this. I don't know of any tools that will do this for you though. Plus I probably wouldn't like their...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 16, 2003 at 7:29 pm
As Allen stated you need to use the square brackets and you should be OK. The only place I have found where this doesn't work is when you are using...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 16, 2003 at 7:25 pm
I think what I would do is create a temp table and do an insert of the table name and date.
IE:
DECLARE @SQL nvarchar(4000)
...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 16, 2003 at 7:19 pm
Buddy,
Since you don't have "BEGIN" and "END" on your error block he will never get to the second query! 🙂
mcmcom Give this a try....
CREATE PROCEDURE...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 16, 2003 at 6:59 pm
Noise words are stored in a text file.
FROM BOL: SQL Server includes a standard list of noise words in the directory \Mssql\Ftdata\Sqlserver\Config
If you are having troubles with the queries...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 16, 2003 at 6:48 pm
Also,
You will want to use Snapshot replication for Views, SP's, and Functions(SQL 2K only) as you can simply update the snapshot and replicate it out.
Gary Johnson
Microsoft Natural Language Group
DBA, Sr....
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 16, 2003 at 6:39 pm
I don't know of anyway to do that. Why do you need it to be separated?
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 16, 2003 at 6:37 pm
If you open Enterprise manager on the machine that gives you the error and then go to the Replication Monitor and check the refresh rate settings you will find that...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 16, 2003 at 6:27 pm
Give this a try...
IF NOT EXISTS (SELECT srvname FROM master.dbo.sysservers WHERE srvname = <ServerName>)
EXEC sp_addlinkedserver <ServerName>
GO
--now do the mapping from local machine to Servers remote...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 16, 2003 at 6:22 pm
canguru,
In SQL Server the ONLY way you can guarantee that the ordering of your resultset is correct is to put an ORDER BY clause on your select statement. There are...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 15, 2003 at 11:44 am
Gary,
If you want to create/get data from Excel use OPENDATASOURCE. It is by far the easier way to go. The only problems I have had is that I have to...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 15, 2003 at 11:38 am
Personally I would use BCP to pull the data in and then push it back out.
Something along the lines of...
SELECT @SQL = 'bcp...
Gary Johnson
Microsoft Natural Language Group
DBA, Sr. DB Engineer
This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.
October 15, 2003 at 11:33 am
Viewing 15 posts - 331 through 345 (of 498 total)