Search results for query: *

In neither case does this page display correctly: the "hello world" is supposed to display after whatver is dynamically loaded in the div tag as it precedes the paragraph tag containing the "hello world" text. I don't remember having this problem before with dhtml. How is it done correctly...

I need to know how to mathematically operate on the datetime SQL data-type. Here's some psudo-code to describe my problem IF now is later than (login time + 20 minutes) THEN [tab]... END

I'm not too familiar with SQL Server security, so I'll need a walkthrough. I have set up windows authentication, not mixed mode.

I have one of those "attachable" database files. I need to port this over to the server without "attatching" it.

I want the two divs in red to be side-by-side, not the latter div under the former. <div> [tab]<div>huge block of text with paragraphs</div> [tab]<div>another huge block of text with paragraphs</div> </div>

I've a fieldset that I do NOT want spanning across the freaking page, or any fieldset, so: fieldset { [tab]display: inline; } Now my table within the fieldset looks like crap because it's also inline. How about it doesn't do that. So how?

Apparently it is totally legal to do this: CREATE TABLE [Apples] ( [id] int NOT NULL IDENTITY PRIMARY KEY, [yumminess] int NOT NULL ) CREATE TABLE [Oranges] ( [id] int NOT NULL IDENTITY PRIMARY KEY, [yumminess] int NOT NULL ) CREATE TABLE [EatenFruits_LOG] ( [fruit] int NOT NULL, [when]...

Imagine I have 2 bytes that mean nothing when separated, but must be, because these bytes are in a file in binary format. When I read the file, these 2 bytes must actually be an integer16, but this is just a simple example, there are times when I'll need 4 bytes to be an integer32. How do I do this?

I found a nice article that takes advantage of SQL Server 2005's CLR integration @ http://davidhayden.com/blog/dave/archive/2006/04/18/2917.aspx The code is pretty simple, although I've never gotten around to understanding regular expressions. public partial class UserDefinedFunctions {...

Other than locking the alteration of tables referenced in a view created with schemabinding, why else is it used?

If in a trigger I've updated a table that has an update trigger, will it be triggered? Or if in an Update trigger, it updated the same table, would it be some recursive infinate loop?

And why is it that in MS SQL Server Management Studio Express, I have an option to add a trigger to a view? I though views were for selecting, and that triggers were not.

I need a trigger to prevent deletion of any rows on all tables except for those I specify.

CREATE TABLE [UsersRoles_MAP] ( [tab][user_id] int NOT NULL FOREIGN KEY REFERENCES [Users]([id]), [tab][role_id] int NOT NULL FOREIGN KEY REFERENCES [Roles]([id]), [tab]CONSTRAINT UNIQUE ([user_id], [role_id]) ) What is the syntax to make sure a combination of role_id and user_id is unique? I...

I don't know how SQL Server does its magic on the inside. I was wondering how much a difference these queries would make: SELECT * FROM ( [tab]SELECT * [tab]FROM [SomeTable] ) and: SELECT * FROM [SomeTable] Does it optimize the query in some way that it knows what you're trying to do?

Already existing, we have Max, Min, Avg, Sum, and whatever else there is. I was thinking Median and Mean would be a nice extension. Can anyone think of others that could be useful?

In MySql, there is a function called Password() which hashes a string. Is there an equivalent in MS SQL? Example of its hypothetical usage: DECLARE @is_valid_login bit; IF EXISTS ( SELECT [id] FROM [Users] WHERE [username] = @username AND Password([password]) = @password ) SET...

Any suggestions for books or software? Any free online resources aimed at tests specifically for an MCAD, MCSD?

I am just curious of those who have obtained certifications. How did you come to gain the knowledge that enabled your passing the test, was it experience or a planned assimilation of knowledge? What questions were asked more than those you've studied? I am personally going for a MCSD, but I...

What makes 2005 that much better than 2000? So far, I've only used it for it's integration ability with visual studio 2005. I find every MS 2005 line of products to be excruciatingly slow, slow, very slow. What's so cool about 2005 that I should know about?