Topics
Started by
Posts
Last post
hi It delete record when a trigger fire to ristrict it. How to write trigger . plz help me . Thanks…
8 replies
Im developing a procedure to copy a client database with tables and data altogether. i bcp everythi…
2 replies
Hi, I want to create 3 new columns from existing columns For example I want to have new columns ba…
1 replies
Ok I have the following data (exhumed out of a production system). CREATE TABLE #TEst ( TESTID INT…
14 replies
SELECT Vw_Final_Inventory_Report_1.*, (select sum(Dqtyin) - sum(Dqtyout) from Tb_Item_Cost_Ledg…
1 replies
If you wrap a cursor in a "Begin Tran" statement and then have a "IF Error=!0 Rollback" statement a…
2 replies
I have a table with a field named "Comment". I archive changes to this table using the xml datatyp…
4 replies
Hi Guys and Gals (my apologese to Flo), I am receiving the following msg: Invalid length parameter…
6 replies
I have a stored procedure that was working fine when the server was in my office. The server has no…
1 replies
I am trying to insert some rows to a table using a select statement, which seems really simple but …
4 replies
I learn from a site to get the row count of table(s) by NOT using count(*) but instead of using " …
19 replies
Hi...I'm a member of a group of developers working with a fairly new company in the Healthcare aren…
3 replies
CREATE TABLE [dbo].[docfol]( [folderid] [int] NOT NULL, [docid] [int] NOT NULL, CONSTRAINT [PK_d…
2 replies
Getting an error I can't figure out : Select value FROM [ssds_core_msphxx.privatebank.com\core].msp…
2 replies
I have a stored proc that accepts input parameters from an asp page. The value entered for an issue…
5 replies
Viewing 15 topics - 4,786 through 4,800 (of 12,230 total)
You must be logged in to create new topics.