------------------------- -- *** Windows Logins *** -- ********************** -- This code assumes that JoeAppdev and JaneAppdev already exist as a Windows login -- Add a Windows login to SQL Server -- Note that the brackets are required for a Windows login CREATE LOGIN [APPDEV\JaneAppDev] FROM WINDOWS; GO USE GO CREATE WITH DEFAULT_SCHEMA = Production GO -- Or, rename the user in the database DROP GO CREATE GO -- Alter the login to add a default schema ALTER WITH DEFAULT_SCHEMA = Production GO --...

• Share This Post:
• 
• 
• 

Set up sample encryption database USE -- Set up three logins CREATE LOGIN User1 WITH password = '3f@$fWDY3QvP&K0' GO CREATE GO USE CREATE CREATE TABLE Customer ( CustId int, Name nvarchar(30), City varchar(20), CreditCardType varbinary(1000), CreditCardNumber varbinary(1000), Notes varbinary(4000)) GO -- Grant access to user GRANT -- ***************************... -- DATABASE MASTER KEY -- ***************************...

• Share This Post:
• 
• 
• 

USE Northwind; GO -- Execute these statements in Connection1: BEGIN TRAN UPDATE dbo.Categories SET CategoryName = 'Drinks' WHERE CategoryID = 1; -- Open a new connection and execute this statement SELECT CategoryName from dbo.Categories WHERE CategoryID = 1; -- Create a table to demonstrate compile errors CREATE (ID INT PRIMARY KEY, ColValue CHAR(4)); GO -- Create the batch INSERT INTO dbo.CompileErrors VALUES (1, 'aaaa'); INSERT INTO dbo.CompileErrors VALUES (2, 'bbbb'); INSERT INTO dbo.CompileErrors...

• Share This Post:
• 
• 
• 

USE Northwind; ---------------------------... -- Scalar Functions ---------------------------... CREATE RETURNS int BEGIN DECLARE @Total AS int; SELECT @Total = SUM(Quantity) FROM dbo.[Order Details]; RETURN @Total; END GO SELECT dbo.fnProductsSold(); GO SELECT dbo.fnProductsSold() AS TotalSold FROM Products; -- Scalar function with parameter CREATE (@ProductID int = null) RETURNS int WITH RETURNS NULL ON NULL INPUT AS BEGIN DECLARE @total int; SELECT @Total = SUM(Quantity)...

• Share This Post:
• 
• 
• 

My desktop computer crashed and died today, and I though, “oh well what the hey“. Now I have to clearn my house and see if I still have my hubby. However it started out with a weird frustrations combined with mild hard palpitations, and then I blamed everyone that I communicated last night. Some of them could hack my computer. Hence I was wrong again(?). I wired in front panel buttons (Power, restart, an IDE LED, and a Power LED). I took these front panel buttons and LEDs from an old computer. Needless...

• Share This Post:
• 
• 
• 

This was a question in one of my interview with American Express, and this was how I understand the question: that I In VB.NET, I found there are a lots methods passing object parameter by value. For example, Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click It's impossible in vb6.In vb6, the object is always passed by reference. How come we can pass object byval in .NET? An object in both VB6 & VB.NET is a Reference Type! ByVal &...

• Share This Post:
• 
• 
• 

Posted on Friday, June 02, 2006 7:29 PM --> I created http://maisworkandfriends.com on Themes (skin & css files) in ASP.NET 2.0. Still trying to decide when it's best to use skin files over css files. Already figured out that an object property should not belong to both. Tested some, and haven't been able to receive consistent results. Is it because... Caching - How does the ASP.NET Developer server work? When using multiple CSS / skin file- Are they always applied in the same sequence Who knows????...

• Share This Post:
• 
• 
• 

404 Error -- File Not Found The page you are looking for (http://vijay.8k.com/index.... is not here. Possible Reasons: You may have spelled the URL incorrectly. This site may have been removed due to a violation of the FreeServers "Acceptable Use Policy". This site may have been moved to a different server...

• Share This Post:
• 
• 
• 

I went fishing /ComputerConference CA/my first sport car/KeyWest2001/ Winter in Rochester! More pictures in pictures gallaries section...

• Share This Post:
• 
• 
• 

Many psychics’ stopped me in the malls, restaurant, drug stores, bookstores, department stores...etc, and told me about my past love life, and future career, family love life. All of them made me believed that some evils have came into my life from the past has had harm my life for a long time. I needed them to unharm all my bad luck so this will help me be lucky again :) The first few times, I believed in some of them, because they with children, or older folks. For examples: “You are thinking of...

• Share This Post:
• 
• 
• 

Developers will create Windows Forms applications much like they do Visual Basic-based forms today (although with Windows Forms, they get the same level of productivity in all of the languages in Visual Studio, not just Visual Basic). In the following image, you can see that a design surface is used to visually lay out the form with rich controls. To edit source code, developers simply double-click a control and the source editor will appear, enabling quick access to the full event model for the...

• Share This Post:
• 
• 
• 

Sometimes your mind is clear and sharp, but every once in a while, you get lost in a dream world and can't seem to find your way back to reality. Don't pressure yourself to step down to reality at this time. Instead, you should take this time to dream...

• Share This Post:
• 
• 
• 

I attended the first SharePoint (Session #1 - Level 100 - June 3rd, 2006) at Devry University in Miramar, Room #240, from 2:00 pm to 5:00 pm this weekend. I am very impress with the SharePoint class today, and from Duray Akar's lecture and I have learned more about: 1. List items in calendar 2. Automatically convert Office documents in SharePoint repository, such as World and Excel to Adobe ® allow distribution of read-only, non-editable copies 3. Establish a referential integrity relationship between...

• Share This Post:
• 
• 
• 

But instead me and my computer right now...

• Share This Post:
• 
• 
• 

I attended my 1st Code Camp– 2006 South Florida Code Camp, Feb 2, 2006. Not only did I learn a lot, I had a great time. I learned which of the presentations I should goto...( I have seen David Silverlight, Alex Funhouse, and Russ Fustino’s presentations many times during the year). I think that I should attend new presenters that I have never seen before, and I did. I also learned from every session I attended, and from the many conversations I had with other speakers and attendees. I could easily...

• Share This Post:
• 
• 
• 

For those of you keeping up with my Geekette maisblogette, I am between jobs again. No, I didn't get fired; I completed working for SunCruzCasino, Inc. So what does a geekette do with the time off liked this? Well, among other things (yeah yeah...geeky things), I decided to catch up on some entertainment. I started with Showtime than HBO. I have been interested in the show for some times. Nevertheless, I head on down to the local video rental store (which is not so local, if you take my meaning)...

• Share This Post:
• 
• 
•