Topics
Started by
Posts
Last post
We are running SQL Server 2000, SP3, Standard Edition. From Enterprise Manager, when I right mouse …
4 replies
I would be grateful if someone would please explain what the following code actually means. I'm a s…
5 replies
The SQL Server services start-up account belongs to the local administrators group. For Sarba…
7 replies
Hi, I need to know if a file on the network exist with t-sql. Is that possible? Example: IF (file o…
2 replies
I have built the following view... CREATE VIEW V_BUDGET_INSERTION WITH SCHEMABINDING AS SELECT DIST…
2 replies
I am looking to write a single query to update 1 field from all upper case to Mixed case text. …
2 replies
We have a table with an Identity field. Using t-sql we INSERT a record. I have seen many programmer…
2 replies
Hi Gurus, Platform : Sql server 2000 sp3 on Win 2000 server. I am using bulk insert command with a …
2 replies
I have two tables : Table A : RegDate 2005/1/15 2005/1/16 2005/1/18 2005/1/20 Table B : RegDate 200…
9 replies
It seems that you just can't assign a variable to a dynamic query result: DECLARE @userID as nvarc…
1 replies
I'm looking for any tips or advice on improving the efficiency of this code. The optimizer is…
5 replies
I'm encountering a problem in a procedure and I've narrowed it down to the following which I can du…
6 replies
I am just playing around with joins and max and mins. This is not for a project just a chance to im…
8 replies
(SQL SERVER 7.0) I have an "OpeningDate" field in a table that's set up as a varchar, but the data …
13 replies
Hello, I'm trying to create my first UDF. I just copied an example from the books online and tried …
21 replies
Viewing 15 topics - 10,936 through 10,950 (of 17,082 total)
You must be logged in to create new topics.