Topics
Started by
Posts
Last post
Table Name = Available Loads Columns = Company# (PK), Agency Code, Load Number (PK), Origin City, O…
7 replies
( you could read this but skip to the third reply on this to see how to improve datetime queries...…
17 replies
Hi, how would one go about adding a sequence number to a view? i.e., achieve the same effect as usi…
5 replies
I want to delete say 500 select rows in a table. There is a unique column called "pacode". I woul…
2 replies
I have a SQL Server 2000 database with a linked server to an access 2002 database. The query uses …
5 replies
One of the common things I need my stored procedures to do is apply parameters in certain cases but…
14 replies
I'm trying to bcp a query to a comma delimited text file. I can't seem to get the -t field term opt…
7 replies
Greetings, I'm getting an error stating that I can't drop a column because it is currently replicat…
3 replies
Can anyone please tell me where I can learn how to use the new feature of sql2000 using Xml ,somewh…
5 replies
I have a requirement for passing a comma-separated list of ID values into a stored procedure (SP) t…
5 replies
Hi! I'm new in this group and I have a problem to use the comand, 'use <databasename>' inside…
4 replies
Does anyone know of a neat way to split a delimoted string into variables in T-SQL, a bit like VB S…
6 replies
I have created this stored procedure: create procedure dibtrantest @des varchar(10) as begin tran…
4 replies
How can I modify "Select * from TableName" to display line numbers in front of each row. For exampl…
3 replies
I may not be looking at this the right way. I am using ADO to execute an SQL stored procedure. I a…
7 replies
Viewing 15 topics - 15,976 through 15,990 (of 17,082 total)
You must be logged in to create new topics.