Viewing 15 posts - 241 through 255 (of 270 total)
Thanks for help, however I am a newbie, so is there more info on #1 and #2 in BOL.
I searched UPDLOCK in BOL, nothing came up.
Can you guide me what...
March 28, 2005 at 11:56 am
Awesome, I never expected such a complete answer !
The reason for my asking for this code is because I need to tag a material description.
For example
SKU, Description
1234567, "Blue,Green, Red,Pink"
7895431,...
March 28, 2005 at 11:49 am
UniqueIdentifier
Thats my point, the customer number must be unique, there can be no duplicates, so why is that not a type of " UniqueIdentifier", and use that as primary key....
February 27, 2005 at 11:40 am
Your correct about the triggers, I will try and avoid them, and to do more data checking to the data before it is added to the table.
ie Data upload in datainput...
February 23, 2005 at 5:42 pm
..."One of the main reasons for not putting information in different databases would be data integrity. You can't define foreign key constraints for data in seperate databases."..
Here I would like...
February 23, 2005 at 12:10 am
Thanks Philcart you last comments make best sense !
February 22, 2005 at 10:06 pm
So if I use PRINT in a batch, I can use Ado Connection object to read it via errors property. Is this correct ?
Like
Din Cnn as ado.connection
Set cnn = SQL...
February 22, 2005 at 11:50 am
How would you go about to do a join on Dates fields on differerent tables when there are different formats.
Do you build a conversion table, or reformat dates in a...
February 16, 2005 at 11:30 am
..." built in with sql server"...
Where, could not find info on BOL
February 16, 2005 at 10:43 am
This convert function will remove the time element, ok great.
So I guess when you do JOINS on date feilds that the format must be exactly the same if you wish...
February 15, 2005 at 12:34 pm
Sorry should have done more searching
http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=17&messageid=11088
February 13, 2005 at 6:03 pm
Sorry cant help, but did you know that the developer edition is just $49.95, its the same as Enterprise edition...but you need another edition to distribute the product to users...
February 13, 2005 at 11:51 am
February 12, 2005 at 10:52 pm
I understand CURSORS are not good to use, So I guess WHILE is not either on large tables.
Better to use CREATE TABLE, INSERT, SELECT on large recordsets.
Just wanted to know...
February 10, 2005 at 5:13 pm
Viewing 15 posts - 241 through 255 (of 270 total)