Topics
Started by
Posts
Last post
I read a book that said if you are not going to use the cursor anymore you don't have a specify clo…
1 replies
I like to see the columns listed when you do an insert select. Example: Insert into #temp1 (column1…
2 replies
I am trying to match two tables - 1 with a field that has 8 char and the other has 8 char but will …
3 replies
Hi, I have a table where each record contains the following info: masterid,GeoState,GeoCity. Exampl…
6 replies
hi, running sql server 2000, i have a rather long .sql script that executes a number of cursors for…
1 replies
When inserting a row, which usage is better for a primary key, Identity (with @@Identity) or Uniqu…
3 replies
VB6 using ADO. I have 2 recordsets that have the same structure, Does anyone know how to add 2 reco…
2 replies
Hi all, I would like to make the SQL-SELECT command when I can use <table> as Variable sord o…
1 replies
Can one SP call another and get a Recordset back for further processing? My customer needs to run …
15 replies
I'm looking for a quick way to get a column's values into a delimited varchar string. If stored pr…
2 replies
Is it possible in SQL Server 2000 to have a table in one database that is shared so it is visible i…
4 replies
Hi, Have any idea about this following : I. How to create correct KEY and INDEX ? Example : TA…
3 replies
Good afternoon, I seem to be having a date problem day today. Ok here goes, How can I stop SQL Serv…
1 replies
I have a query that works on its own, however when I put it into xp_sendmail it fails. It appears t…
1 replies
Good morning, I am currently experiencing problems with SQL. I am inputting a date into the databa…
1 replies
Viewing 15 topics - 3,766 through 3,780 (of 4,455 total)
You must be logged in to create new topics.