Microsoft SQL Server | Forum profile

Your not in the right forum, your in the wrong website. This sounds like a Office issue at least. Read this: http://office.microsoft.com/en-us/a...0950951033.aspx

Not to worry. Done it by using HAVING. Thanks anyway.

Quote: Originally Posted by markoc are you trying to do something like: Code: CREATE TABLE dbo.tblComment ( Id int IDENTITY(20001,1) NOT NULL, KeyId int NULL, Line_No int NULL, Comment nvarchar(8000) NULL ) GO ALTER TABLE dbo.tblComment ADD CONSTRAINT PK_tblComment_ID PRIMARY KEY (ID) GO -- ################################## CREATE PROCEDURE Comment_Add ( @KeyID int, @Comment nvarchar(8000), @NewId int OUTPUT ) AS BEGIN DECLARE @LineNo int IF...

Hi all, I am new on the forum so hello! I am needing to do a data migration from an Access database to Mssql. I really havent found much info on the forums. Would you know how to do this? Thanks for helping.

Hi, and welcome to the forums. What version of MS SQLServer are you running?

Should be fairly easy and straight forward using linked tables. Depending on what version you have (of the admin tool I think) there may even be a data import tool that will just suck the schema and data straight out of your access table into mssql.

I need to remove all double quotes from 1 field in my database. but it has over 200,000 records and 660 of them have double quotes atleast once or twce in the field. Is there an easy code to use to replace all double quotes with a space?

This link says that we have a Replace function for sql server 2000. http://www.mssqltips.com/tip.asp?tip=1026 So try something like this Code: Update tblTableName Set FieldName=Replace(FieldName, '""',' ') I havent tested it, so please test it once for 1 record before.

are you trying to do something like: Code: CREATE TABLE dbo.tblComment ( Id int IDENTITY(20001,1) NOT NULL, KeyId int NULL, Line_No int NULL, Comment nvarchar(8000) NULL ) GO ALTER TABLE dbo.tblComment ADD CONSTRAINT PK_tblComment_ID PRIMARY KEY (ID) GO -- ################################## CREATE PROCEDURE Comment_Add ( @KeyID int, @Comment nvarchar(8000), @NewId int OUTPUT ) AS BEGIN DECLARE @LineNo int IF ( EXISTS( SELECT @LineNo = Line_No...

Hello, I tried to run the ASP script with the same script for both Access and SQL Server. Access database works fine. SQL server database don't work and shows the syntax error. I think DateSerial causes this error. How do I change the query and make it work? student_dob >=#" & DateSerial(yr(3), mo(3), 3) & "# Thanks very much!