I purchased a database of ZIP code and their coordinates, etc. I know how to create a custom MySQL function (http://www.bytemycode.com/snippets/snippet/489/) but am not familiar enough with SQ...
Hello All,
i have simple search page. when a user types a word or a group of words, it searches my DB and returns the results to a GridView. works fine but i am seeing that the more i am se...
I recently needed to restore a few records in a SQL Server database from a backup file that I loaded onto another development server.
I have done this before with a MySQL server using php...
Hello experts,
How do I go about obtaining the specific values (or parts) from smalldatetime. More specifically I am trying to obtain the following:
value for the hour (1-12)
value for...
Hi Experts,
I tested MS DPM 2007 and as part of the installation it installed SQL 2005 to hold its database.
I decided not to use DPM 2007 and uninstalled it. I then decided to test Back...
i am trying to create a master server using the wizard and using sql.
when i tried to create using sql i am getting this error
USE msdb
GO
sp_msx_enlist @msx_server_name = 'serverName', @...
I'm looking for a TSQL function that takes a string and spits out a number. For example, TEXT_FUNCTION('Smith') = X, where X is a numeric value. X can be some kind of ANSI conversion, Unicod...
I have 2 tables in my database, QA_Assessors [ Assessor_ID (pk), Name, Group, Email] and QA_Consultants [Consultant_ID (pk), Name, Group, Email].
I want to get the data from these tables an...
I am learning to use the @@Identity feature. The code snippet I have attached belongs to a transaction. When I run it I get an error because of my attempt to reference the @FormGroup_ID. Co...
Hi All,
I have a table Table1 with column Col1 ntext. I found some records corrupted in that table; which disallow me to drop those rows from Table1. To resolve the problem, I create anothe...
I am running two SP's on a SQL 2005 Server. Tables the data is being copied from = MDist and the Table being inserted into are Distributions, Errors, Nodes, Packages and Status all within one ...
In SQL Server 2000, I could use DTS to move a table to another database.
In SQL Server 2005, I cant' find how to do this?
How can i search the data from a databse by using the primary key.I need a sql code for it.
I am making a webssite in asp.net with c#
I am hoping there is an easy way to do this the following: I would to run the following query and put the results to the @body of a SQL email.
Select * from table1 order by PKID desc
Thi...
I have a .NET 2.0 C# application that displays a datagrid. One of the columns is a date field. The application is working fine. I just installed it on a workstation in the Pacific time zone...
Can someone please help me with the code of the following? I am trying to get an if statement for SQL to do this:
- A field called @MemberID is provided.
- It searches a table called Memb...
Hello,
I installed SQL Server 2005 Express.
Later installed SQL Server 2005 Professional. SP 1 & SP 2
(I'm using vista)
I can find: SQL Server Management Studio Express
However I can...
Hi All,
I have a problem with a query that I just can't seem to get my head around.
I have one audit table which records when users login to a web platform, I would like to be able to ha...
I am using a view in SQL 2005 and trying to seperate a date range into 2 parts.
Want to take 7-15-08 to 8-16-08
column from-end = 7-31-08
column total days = ?
column to-from = 8-1-...
I have two databases with 2 tables that are of the same makeup. I would like to draw data from both tables with a combined result. Here's how the tables are structured:
Database1.Table1
...
I am trying to learn more about using the right outer join statement.
Below is the problem to be solved along with the Correct outer join that
solves the problem.
Return the StudentID, F...
Dear Experts
Dear Experts
i use the sql server 2005 and the northwind database
what is the optimal chnage on the northwind databas , that acheive the following
1- i want to add a "...
I am having a tough time with a ms-sql 2005 query that uses an IN clause. I have a real estate database, and I want to find all homes that are in a certain high school area. I have a table of ...
Hi Experts,
I want to convert a date instance to hour's granularity
E.g. 2008-09-05 15:39:38.670 to 2008-09-05 15:00:00.000
select CONVERT(VarChar(50), GETDATE(), xx)
is good way to do...
I got some type of error message that would not allow my SQL svr databases to open any tables on my development machine. After about 2 days I started getting an error while even trying to con...
