Topics
Started by
Posts
Last post
In a database .mdb access 2002, 3 tables Tab_A, Tab_B and Tab_C linked to SQL Server 2000 the 3 tab…
7 replies
Hi, I'm storing information for realestate and my table structure is like this: tblProperty propert…
9 replies
I have a web application with serveral users who could be updating the same table at the same time.…
1 replies
Consider a stored procedure with optional parameters that is involved in a select. We often end up…
19 replies
I have a table which contains a visible field which can either hold 'y' or 'n'. What i want a query…
1 replies
Hi, if exists (select * from sysobjects where type = 'V' and name = 'SerialControlView') Begin…
2 replies
I have a Product table. A user is complaining that the records entered in the last hour has disapp…
3 replies
Can yo do union of the output of stored procedures (their output is of matching type). Something li…
1 replies
I have a table with the below data(orderNotes). ORDERID, NOTEID, TYPE_CD, NOTES OrderIDNOTEID Ty…
20 replies
Hi! I've got a stored proc that calls xp_cmdshell to start OSQL and log a database error in a trans…
3 replies
Can a table with a trigger be updated from a stored proc without firing the trigger? Thanks
17 replies
Is there anyone knows how to create a function which returns a random positive integer number withi…
3 replies
I am tasked with building a report in Crystal Report V7 in which the vendor number is the main fact…
4 replies
Hi! I have a view defined in MANAGE database as: CREATE VIEW dbo.sysdatabasesview AS SELECT …
3 replies
Hi, I need some help with replication. I am new to DBA position in my company.We have replication b…
3 replies
Viewing 15 topics - 14,491 through 14,505 (of 17,082 total)
You must be logged in to create new topics.