Topics
Started by
Posts
Last post
Hi I am trying to write a piece of SQL that will go through each database and return the tables wit…
2 replies
Greetings All, To begin with, I don't have a lot of experience using Stored Proceedures. I am tryin…
2 replies
I would like to create a field/expression that would calculate the sum of a couple other fields? Is…
1 replies
I'm fairly new to stored procedures, so please bare with me. I need some help with the following st…
2 replies
Hi folks I want to write generic code which will drop a given column from a given table. However I …
1 replies
Hi, We are writting a scientific application based on SQL2k. Number of fields in it will be numeric…
5 replies
Hello, In a very typical scenario I was looking to create a SQL that traverses a hierarchical struc…
3 replies
I have linked to a SQL Server which is running as a multiple instance on a single computer. The se…
4 replies
I just like to make things complicated for myself. Actually my select has 15 fields and I need to…
1 replies
Hi, I'm trying to join data from two tables. I have an order table and an orderline table. I tried …
1 replies
Hello, I have a T-SQL query that returns a couple of columns of data. It looks like the following.…
2 replies
Hi All, I have a column with smalldatetime data type. I need to create 2 columns which will have da…
3 replies
In a select statment, which causes more overhead, using a sub-select in the where clause or using H…
2 replies
I am fairly new to the SQL 2000 environment and i am having a difficult time trying to convert a CH…
2 replies
I have a conceptual problem with stored procedure and transaction. To summarize, I have stored proc…
2 replies
Viewing 15 topics - 16,261 through 16,275 (of 17,082 total)
You must be logged in to create new topics.