Viewing 15 posts - 3,271 through 3,285 (of 6,216 total)
Look at the charindex function, you can use it to determine the position of the @, then use the left function to pull off the characters before it.
Andy
September 12, 2002 at 4:53 am
Dont think it will work directly. Probably better off rolling your own replication code if you need this.
Andy
September 12, 2002 at 4:52 am
No idea. Looks like you're running into a few compatibility issues. Tried a search on MSDN or google to see if you can maybe find a list? Would be interesting...
September 11, 2002 at 8:18 pm
Close, but I think you are doing more work than you need. Then again, I read C# about as well as I read Klingon. Here is similar code for VB6.
dim...
September 11, 2002 at 8:13 pm
Here is another way:
SELECT a.*
FROM OPENROWSET('SQLOLEDB','yourserver;'sa';'sapassword',
'exec Northwind.dbo.salesbycategory ''beverages''') AS a
GO
Andy
September 11, 2002 at 8:09 pm
If its a single value you'd normally design the proc to return an output parameter. I think you can do a hack using openrowset if you want to treat it...
September 11, 2002 at 3:35 pm
One option is to put triggers on all the tables. Several tools available that will do it for you, not that hard to roll your own if it needs to...
September 11, 2002 at 3:34 pm
September 11, 2002 at 1:32 pm
Have you considered using an identity col, or using a uniqueidentifier?
Andy
September 11, 2002 at 1:30 pm
Is there a foreign key on the table? Email me the entire trace if you have time (as text), I'll look some more.
Andy
September 11, 2002 at 10:57 am
Thats a good question! Dont know that you can. I can see where having the option in the wizard would be nice, though I prefer to use separate files for...
September 11, 2002 at 5:19 am
September 11, 2002 at 3:27 am
Please dont cross post. See this thread:
Andy
September 11, 2002 at 3:24 am
How big is the file you're trying to open? Maybe SQL cant allocate enough memory? How about compiling an exe and running from a job? Or just instantiating the dll...
September 11, 2002 at 3:23 am
Viewing 15 posts - 3,271 through 3,285 (of 6,216 total)