Viewing 15 posts - 8,056 through 8,070 (of 13,469 total)
well, i've got two variations of this...one returns the definition as a single varchar(max), and the other splits the same varchar(max) on CrLf so it's multiple rows.
one purpose is standardization...developers...
February 25, 2011 at 10:28 am
the drop of a trigger would be in the default trace, so you might be able to narrow down if it's a person or a process based on teh hostname,...
February 25, 2011 at 8:58 am
Grant said it all; you'll have to provide more details to get more relevant answers.
the only thing i can offer is it is my experience that for some specific...
February 25, 2011 at 7:42 am
chitturiii (2/25/2011)
Thanks Lowell...I think the query goes on as:
Select top 1 sal from employee where sal in (select top 2 sal from employee order by sal desc)
order by sal
that...
February 25, 2011 at 6:34 am
here's an example command for attaching a database; you'd have to do as suggested and script out the dynamic portions...the database name and the file path.
it all starts with the...
February 25, 2011 at 5:43 am
this is a fairly easy question, and it comes up a lot in homework type situations; so I'll give you a hint and information rather than a full answer:
there's two...
February 25, 2011 at 5:33 am
the BULK INSERT command doesn't use xp_cmdshell it basically has the same functionality as bcp(which does require xp_cmdshell);
here's an example of multiple files via BULK INSERT...
this example assumes I had...
February 24, 2011 at 2:39 pm
William this seems to work for me: maybe you missed the double join?
SELECT
c.COLUMN_NAME,
c.ORDINAL_POSITION,
cls.DATA_TYPE
FROM
INFORMATION_SCHEMA.TABLE_CONSTRAINTS p
INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE c
ON c.TABLE_NAME...
February 24, 2011 at 1:42 pm
The collation of my database is sql_latin1_general_cp850_bin
is a binary collation, so yes, that is case sensitive;
unless you know it's a mistake, the collation must have been put in place for...
February 24, 2011 at 1:11 pm
it depends on the collation of the database you are connecting to.
if you create a database with a case sensitive collation, all the tables and objects are going to require...
February 24, 2011 at 12:35 pm
sql_butterfly (2/24/2011)
February 24, 2011 at 8:40 am
I just checked, and if you restore from a backup, and change the database name to a new database, it does not trigger the create_database event...so my trigger example wouldn't...
February 24, 2011 at 6:04 am
I've done what you are asking with a server wide DDL trigger that looks for the CREATE_DATABASE event;
basically, my example is whenever a database is created, a suite of specific...
February 23, 2011 at 3:18 pm
this is the syntax I typically use;
looks the same as yours too me:(the forum hates{slash n} so you have to html escape it)
CREATE TABLE BULKACT(RAWDATA VARCHAR (50),MoreData varchar(50))
BULK INSERT BULKACT...
February 23, 2011 at 12:57 pm
SKYBVI (2/23/2011)
How can u add the 90 degrees between 3 and 6...
if time is 3:40, the hour hand has moved a lot towards 4.....
Just give it a thought.
Thats...
February 23, 2011 at 10:52 am
Viewing 15 posts - 8,056 through 8,070 (of 13,469 total)