Topics
Started by
Posts
Last post
We are facing a peculiar problem while updating a table. The update happens thru a stored procedure…
6 replies
Hello, Does anyone have another way of storing the error msgs, and general output from a stored pro…
1 replies
I often have to copy the structure of a table between databases and I currently do so with a select…
1 replies
I am trying to use the replace function on a text datatype but I am getting the error as follows: S…
2 replies
I am writing a script to update a database, with PRINT staements to indicate that each step ha…
2 replies
Could someone please tell me WHY the following T-SQL code does NOT work? ==========================…
6 replies
We have some data source configured with ODBC connection. Is there anyway I can use inside stored p…
4 replies
I want to know if this is possible. Currently, I am able to get the id of a stored procedure…
1 replies
This is very strange. The following statement executes without error: select distinct code from T…
9 replies
Hi, Can u tell me how can i pass a parameter to the view of SQLSERVER 2000 database OR how to creat…
3 replies
Your thoughts on using SELECT "AliasName" = ColName vs. SELECT ColName AS "AliasName". ColName coul…
5 replies
Hi, I need help to remove the time part (hh:mm:ss) from a date column. I'm now using Convert functi…
15 replies
Consider the following example: select a.totalminutes, m.memberid, m.meetingid frommeeti…
5 replies
I have 3 tables. TravelerLot WorkOrder Process My code is currently like this; SELECT WorkOrder…
1 replies
What would work best. You have two tables Customers and Orders. Orders holds the foreign key refer…
8 replies
Viewing 15 topics - 13,906 through 13,920 (of 17,082 total)
You must be logged in to create new topics.