Viewing 15 posts - 5,536 through 5,550 (of 7,636 total)
There are lots of ways to do this, what will you be using it for?
September 15, 2008 at 1:50 pm
Ninja's_RGR'us (9/13/2008)
Some of us have lifes outside of SQL Jeff, maybe he went to bed :hehe:.
Heh. Highly overrated if you ask me. 🙂
September 13, 2008 at 6:49 pm
At the NASDAQ, one of the larger stock exchanges in the US, only 3 of 20 developers have expertise in T-SQL. As they are building a new application, they hope...
September 13, 2008 at 3:43 pm
garethmann101 (9/12/2008)
Or simply the names of each table in the database so that you can connect to each one?
SELECT * From INFORMATION_SCHEMA.TABLES
Try it!
September 13, 2008 at 3:12 pm
rian67 (9/12/2008)
So, you DBA's can actually write .NET assemblies to do conflict resolution of Replication Merged Data.
Yes, I can, and so can many of the other DBA's here. More...
September 13, 2008 at 7:31 am
Check out the DATEPART and DATENAME functions.
September 12, 2008 at 3:53 pm
Instead of RETAINDAYS, try EXPIREDATE=dateadd(hh, 25, getdate()).
September 12, 2008 at 3:51 pm
You can also do this with XML: Select all of the columns into an XML column/variable then extract the element(column) names of all of the matching elements(columns).
And of course this...
September 12, 2008 at 11:10 am
Can you explain how Page File increases can be affecting your CPU performance? And how you figured this out?
September 12, 2008 at 9:16 am
I notice that you do not have any exception handling. However, BOL has this to say about the GetEncoding method which you are using:
Note
Some unsupported code pages...
September 12, 2008 at 8:22 am
Like this:
INSERT Into {target_table} ( ..target_columns.. )
SELECT Distinct ..source_columns..
From {source_table}
September 11, 2008 at 11:20 am
Jacob Pressures (9/11/2008)
But why has this been so hard? I thought connecting to different DBMS was supposed to be quite seamless.
Generally connecting can be, however implementing good security is another...
September 11, 2008 at 9:26 am
These are not scripts.
I am done here, this one is all yours Gus. 🙂
September 11, 2008 at 8:42 am
Yes, just apply the same technique that I did in my first reply.
September 11, 2008 at 7:59 am
Please post the CLR code.
September 10, 2008 at 8:28 pm
Viewing 15 posts - 5,536 through 5,550 (of 7,636 total)