Search results for query: *

Thanks Jel. I think that will be the reason. It does work when I give the method a different name. I've found some extra info as well: http://www.msdner.com/dev-archive/161/153-1016-1615497.shtm Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog

Hi all, I'm practicing with the C# 3.0 Language Enhancements and get stuck with the following issue on method extensions. The goal is to write an Equals method for the datetime type which accepts an additional parameter indicating until which level the comparison must be done (Year / Month /...

Hi all, I'm currently creating an XSD to validate my xml file. I wonder wheter it is possible to force a set of attributes depending on the value of a different attribute? For example I have the following XML structure: <charColumn columnName="" maxLength="" allowDbNull="" /> <numberColumn...

Normally the above code will not compile since the TextReader class has no WriteLine method. You should change your code like this by using StreamWriter and TextWriter: string drive = "c"; TextWriter tw = new StreamWriter(String.Format(@"{0}:\boot.ini.zives", drive)); tw.WriteLine("test")...

Last friday I passed the 70-536 and give it **. If you study with the MS PRESS book, it should be relative easy. Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog

Hi, If you want to have intellisense, you need to make sure that the xml document is generated for the class library. You can set this via Project Properties in the Build Tab (XML Documentation file). If you then rebuild your project and update the reference, it should work. NOTE: the...

I passed the 70-300 a while ago and give it a *** exam Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog

Hi all, For one of my project I needed a function that returns a table based on some parameters. In SQL Server this is pretty easy but in Oracle it took me quit some time. Therefor I've posted a sample on how to do it on my blog...

It should be something like this: (not tested since no SQL at the moment) SELECT T1.CUSTNMBR, T1.CHEKNMBR, T1.RMDTYPAL, T1.DOCDATE, T2.APPTOAMT FROM ( SELECT RM20101.CUSTNMBR, RM20101.CHEKNMBR, RM20101.RMDTYPAL, RM20101.DOCDATE...

This should get you started: It shows you how to create a new database with SQL Server Management Studio. http://msdn2.microsoft.com/en-us/library/ms186312.aspx If you have installed an express edition without the management studio, you first need to install it...

Hi, You can set this in the Database\Options\Document menu. In the Table tab you can set how the datatype needs to be shown. Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog

Hi, It is not possible to join the result of a stored procedure with a table. You can do 2 things: - Create a function in case of a stored procedure. A function can be used as a normal table. - Include the extra join in the stored procedure Greetz, Geert Geert Verhoeven Consultant @...

Hi, I have created my database diagram with Visio. Each time I want to export a report from the database via the Report Wizard, I need to specify the fields I want to include. Is there a possibility to create a personal template to be used to export the database diagram? The version I'm using...

Hi, You can use the following function: create function dbo.ConvertToDatetime (@inputString nchar(14)) returns datetime as begin declare @hourString varchar(8) set @hourString = substring(@inputString, 9, 2) + ':' + substring(@inputString, 11, 2) + ':' + right(@inputString, 2) return...

Hi, I think that you can best ask this question to someone at Microsoft. It is strange that someone is selling its license. I'm not even sure if it is allowed. Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog

Indeed, it is as paul thomas said, it is best to shedule it not to far in the future. The problem with these exams is that you need to know some stuff like the sysprep which not everyone use on a daily basis depending on your job contents. Take a look at this list...

Take a look at the link I provided. Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog

Hi, For business, the Report Model is interesting. This gives the possibility to let your business create reports based on models that have been set up by developers. This way, the business doesn't have to know the db structure. The improvements of SSIS (former DTS) are also great. The engine...

70-441: ** Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog

Borislav Borissov, I subscribed to this thread since I was interested in the solution. In SQL 2005 you have the ROW_NUMBER function but this doesn't exists in SQL 2000. Would you also create an extra table if you have a table with for example 10.000.000 rows in it? What if this table contains...