Browse by Tags
All Tags »
SQL Server (
RSS)
Sorry, but there are no more tags available to filter with.
I recently got this error when applying a data fix. The error was for an insert that contains a select, I used the values keyword like: insert into <table> (<fields>) values (1, 2, (select ...), 4) The article referenced below indicates doing...
It seems like this is a very popular message with SQL Server 2005 Express (if you google it, you'll find a lot of resources), and is often a hard one to figure out. However, there are some ways that you can get to the bottom of it. For instance, whenever...
I'm running XP, VS 2005, and have SQL Server 2005 installed, specifically SQL Server Express database in a test project that I am using. I keep running into the problem where I get build errors because it can't copy the database over. I delete...
I was having problems with querying null parameters, mainly because of the syntax. For instance, I have a query: select * from MyTable where NullParameter = @Param and OtherParameter = @OtherParam But I didn't get any results. When I attempted this...
I didn't realize how difficult it can be to query on dates. Because a date consists of a date and a time, when you want to see if a date is the current date, using the getdate() mechanism, it won't match because the time isn't exact. How can...
I was trying to bulk insert some data, and I found a page that had this (don't have the link anymore), which I used it to get it to work: BULK INSERT tblYLT FROM 'C:\YLT.txt' WITH (DATAFILETYPE = 'char', FIELDTERMINATOR = '\t'...
If you need to perform statements at the database level for a SQL Server 2005 Express database, what do you do? With an attached database, you can reference it by name, but Express databases aren't necessarily attached, so in a detached state, how...
If any of you have ever gotten an error stating that: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow...
I didn't realize that it was completed, but I found a link off of a forum site for an update to SQL Server Express, that looks really cool: http://msdn.microsoft.com/vstudio/express/sql/download/ It allows express users to make use of Reporting Services...
I was trying to install the SQL Server client tools through running the Native Client installation option off the splash screen on the install program, but it wasn't working. After doing a little digging around, in the SQL Server x86 folder, there is...
