Search results for query: *

what is the benefit of isnull() vs is null ?

thanks and I appreciate the correct answer. Can you help me understand why did isnull() not work in this case?

I have a store procedure that expects a parameter "@Abnormality bit". Based on the value true, false or null, the query returns all rows with true , false or all values respectively. I am using the isnull function to check the value, however I get the following 3 faulty condition. if i use...

Hey thanks again, Is the Datatable returned by GetSchema the same as the following SQL ? select * from sys.sysdatabases

Hi Thanks for the help and I almost got it done. My last question is when I get the list of database from a server, how can I filter out the system database such as master, model, msdb, and tempdb. myconn.ConnectionString = stringBuilder.ConnectionString myconn.Open()...

The classes you mentioned gave me pretty good idea, but the structure of your code seems to have problems. What are all the "Me" referencing? May be I just don't understand it enough. Thanks though. Private Sub GetServerNames() Dim dbProviderFactory As DbProviderFactory =...

I imported System, System.collections.generic, and System.Collections.ObjectModel For the getServerName() the following are not recognized. Me.CanEnumerateDataSources Me.Factory Me.ServerSchemaCOlumnName Me.InstanceschemaColumnName Me.GetServerName For the getDatabaseNames() Me.Connection...

Thanks Hey thanks. Where can I learn about specific classes like this, do you have any good reference site or book that I should look into?

Hi All, I am trying to build a user control that will do exactly what the SQL 2005 Connect to Server interface do, eventually create a connection string and store in a app.config file. It should allow user to select server type, server name, authentication, user name and password. It...