Search results for query: *

Hi, Can someone explain the difference between using the "FOR" clause versus the "AFTER" clause while defining a trigger for a table? For instance: CREATE TRIGGER sometrig ON sometable FOR DELETE .... vs. CREATE TRIGGER sometrig ON sometable AFTER DELETE .... Thanks, - forevertechie

Although it is a fact as per mr.denny "Regular tables and Temp Tables also have a max row length of 8060 bytes.", my SQL statement (inside a stored procedure) for creating the following table: T.TitleID int, T.Title varchar(100), T.Description varchar(4000), T.ISBN varchar(20)...

Also, the major limitation of the table variable is that the max row size can be 8060 bytes... so obviously, if your query exceeds this limit, SQL Server will error out at the time of creation of the table variable (when you try to create the stored procedure). -forevertechie

I guess you could create a UDF that mimics select convert(char(10),getdate(),101) + ' '+ convert(char(5),getdate(),114) I hope this helps. - forevertechie

I'm currently designing a SQL Server 2000 database for a small DIY application with plans to provide features such as concurrency data management built into it. I'm relatively new to SQL Server 2000 and was wondering which might be the best way to prevent concurrency issues (when the DB scales...

Hi, I'm new to this forum and this is my first post. I have SQL Server 2000 client installed on my work machine (and I do not have access to any SQL instances,neither locally nor on the network) and want to have MSDE 2000 installed on this machine so that I could have a local instance of SQL...

Hi, I'm new to this forum and this is my first post. I have SQL Server 2000 client installed on my work machine (and I do not have access to any SQL instances,neither locally nor on the network) and want to have MSDE 2000 installed on this machine so that I could have a local instance of SQL...