Topics
Started by
Posts
Last post
Hey there. I'm using bulk insert with a format file on SQL Server 2000. All fields in my format fil…
1 replies
I am trying to use the nolock option for an sql statement. but i get the error as Incorrect syntax…
5 replies
I'm trying to drop a constraint on a table so I can then drop a column. The constraint is of type P…
10 replies
Dear friends, I have a table with 100 rows and 5 columns. I want to execute a certain proc which&nb…
3 replies
In the following query for records where G.CharField1 is Null and SUBSTRING(D.VarcharField1, 1, 4)&…
11 replies
Wondering if any TSQL gurus can lend a hand. I have the following select statement which sums…
1 replies
Hi, I have the following Data AddressID, TradeName 2, ABB 2, ACC 2, AEE 3, AAA 3, BBB 4, AAA I woul…
15 replies
Does someone has the query to find out all the RESTRICTED_USER for a given database. …
4 replies
I am building a template to use for stored procedures that includes error handling and rolls back t…
4 replies
Hi, I want to have the primary key column of a table to be of type VARCHAR. Usually, I use a column…
4 replies
Hello, I am trying to obtain the database definition for a SQL Server Database, using the ODBC with…
8 replies
I'm trying to figure out a way to send the results of a query to a txt file. Is this possible? If s…
6 replies
I need to find out the date the first bit of software was installed, the following query select di…
3 replies
I have a table that contains many rows where in order to get the required data you need to run a wh…
5 replies
OK, I'm stuck again. I'm not sure of the difference between an ON clause or WHERE clause or w…
4 replies
Viewing 15 topics - 9,316 through 9,330 (of 17,082 total)
You must be logged in to create new topics.