Topics
Started by
Posts
Last post
create table t1 (ID int, comments varchar(1000)) insert into t1 select 1, '1234_I wish someone who …
2 replies
We have table SHSVCHST with fields: SH_Cust_Alpha, SH_Serial_No, SH_Invoice_Date, SH_Meter. I want …
2 replies
Can someone please show me the syntax for cursor for update? I would like to use the cursor to upd…
5 replies
i use a case statement with calculations for one of the columns in the 'select' clause and i want t…
3 replies
If I insert an empty string into a datetime field it becomes '1/1/1990' --the "lower limit" for a s…
3 replies
HELP...I have a dynamic insert statment that on occasions may have data that includs things like ti…
9 replies
Greetings, Does anyone know how to connect SQL Server to a DBase (.dbf) file and update it using ro…
1 replies
I have 2 tables with a one-to-many join. I would like to update a column in one table with the numb…
3 replies
Hi Can anyone tell me the TSQL statements to place the result set of a query into a .csv file. I th…
2 replies
Please help, my random assignment script gives me not so random assignments! Am I using my cursor …
2 replies
I have several SQL scripts that update the stored procedures required by my application. Because th…
4 replies
Hi! I have a table named BLOCKS_HISTORY, that holds two similar fields: who_waitresource and block_…
4 replies
This is a nice SP; however, the data appears to be from 1990. There have been a lot of zip code up…
2 replies
For simplicity sake, say I have a table that contains 2 fields....FirstName and LastName. I would…
18 replies
this one has me puzzled, so I'll ask the experts. Kinda hard to explain: I'm calling an SP that c…
3 replies
Viewing 15 topics - 14,881 through 14,895 (of 17,082 total)
You must be logged in to create new topics.