RE: Installation problem with SQL 2000 Dev
I had a similar problem and searched many hours for a solution. This link provided a solution which worked for me. http://dbforums.com/t544297.htmlHTHBill Kerr
2004-11-16
ado.net
RE: Query that works different inside a SP
If you aren't interested in the time period in the where clause you can convert your A.Date1 to remove the time. This should then remove the problem of times after midnight not matching the between statement e.g.where cast(convert(varchar(10), a.Date1, 112) as datetime) between @param1 and @param2 This will take the date and time and then replace […]
2004-09-02
RE: Stored Procedures under .net
Hi there...We are using .NET (VB .NET) frontend applications to analyse Data from SQLServer 2000. We use stored procedures where we can.First of all, when using stored procedures through the Command Object and adding Parameters, SQL-Injection is avoided.Secondly, by seperating the business logic and data logic more scalability is acchieved. If I have a reporting tool, […]
2004-08-10
RE: SQL service pack 3 Rollup how to find?
Hi derrick,I am in a process of applying a sql sp3a do you have any bad experience or situations that you had to remove it ?Do you have any kind of documentation done (change management form fillup ,procedural documentation) towards it? Thankschaem
2004-07-16
RE: Return just a sample of the code
true - but - does that not still go out and scan the whole table or should I assume w/TOP the scan will only exe the syntax on the first ten records or 10 percent. Which would work best TOP or ROWCOUNT() thoughts...
2004-07-14
RE: help selecting sums from two similar tables
alzdba, Thanks for the heads up. I've changed the union to a union all. Thanks again!
2003-06-19
RE: Developer tips for team.
Stored procedures, stored procedures, stored procedures. Simply don't let the apps access the server in any other way. Use roles with execute permissions on the stored procs. Always make dbo the owner of the tables and stored procedures. If they have Visual Studio .NET and Visual Source Safe, encourage them to use database projects. This […]
2003-06-16
RE: Procedure cache - recompile problem
Kalen Delaney, author of Inside SQL Server 2000, wrote a series of articles (Dec. 2002, Feb. 2001, & Jan. 2000) in SQL Server Magazine regarding recompilations. You may find useful information in these. The gist of these articles is that certain options are stored as server, database, and session options. A couple (QUOTED_IDENTIFIER and ANSI_NULLS) […]
2003-06-03
1 reads
RE: Debugger Question
Not that I'm aware of. Could do a select at some point and step through that. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-06-03
RE: SQL 6.5 Restore
It seems there's been a bit of confusion at my end-i'm on here on behalf of my boss who told me before, that the original machine is NT4. I have just learned that it is in fact 2000. Apologies for the false information, but thanks all the same for trying to sort it! We checked […]
2003-05-21
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