Hi How do I add an autonumber on the fly to a view? I know it can be added to the table used in the view. Can't do that. Thanks
Quick question: How important is to have short names for tables, fields or other objects in general? Does it have an impact on performance? For...
Hi Madhivanan, Thanks for the link. Very helpful. bolo
Thanks ranjitjain, Ho do I write my UPDATE statement? A loop should be generated and each time @str = '', right?
Hi I have one table(Table1) that looks like this: --------------------------------------------- ID(int), Comment(varchar(250)) 1, abc 2, efg 3, wer...
First of all I want to thank you for your feedback. “some processing†is something that has to be developed and will change from time to time....
Hi there, Here is my table: ---------------------------------------------------- CREATE TABLE [dbo].[MyTable] ( [ColumnA] [int] NOT NULL ,...
Separate names with a comma.
