Topics
Started by
Posts
Last post
I have two tables, tblWasteDischarge & tblManifest, which the identity columns, Disch…
1 replies
Experts, Here is my requirement.I have been trying various things but i am not successfull till thi…
10 replies
In sql2000 set @DataItem = 'line' set @DataElement = 'On' set @sqlstmt = 'declare @cnt int' …
13 replies
Hi, I'm trying to update a table which contain these fields : ItemID, InventoryID, total amounts w…
2 replies
Hi All, Here is my issue. I need to keep an audit trail of changes made to the database (inse…
19 replies
Hi I am starting to build a view in SQL Server 2000. The various fields need to be formatted as bel…
4 replies
How to name a string with the current date??Please help BACKUP DATABASE [CollSoftware2] TO DI…
1 replies
Hi all, Table A with following structure RecID, CustID, CustName, TypeID with the following data 1,…
4 replies
I have my application creating a database on Sql Server 2k. My QA team always reports that the log …
9 replies
Hi all, I am facing an unusual issue here. I have a stored procedure, that return different set of …
2 replies
bit of a quickie here, but is there any way to use variables in select statements to define column …
2 replies
declare @townID varchar(25) set @townID = '''00005''' print @townID if exists (select * from sysobj…
5 replies
Hi, Hope that someone can help me on this one. I have a Local variable containing a tablename and w…
3 replies
I'm running a stored procedure that truncates a table, and then inserts rows from another table wit…
11 replies
Hi All, I am trying to create a stored procedure but I am getting a collation conflict error with t…
6 replies
Viewing 15 topics - 5,941 through 5,955 (of 17,082 total)
You must be logged in to create new topics.