I am inserting unicode data in SQL server using insert statement as follows, INSERT INTO tablename (col1,col2)values (N'value1,value2) WHERE col1 is of NVARCHAR datatype. I want to run the above statement using a SQL SERVER stored procedure This procedure will take 2 parameters please help me in solving this problem.
2002-03-21
Discussion, comments, and ratings of items posted to SqlServerCentral.com by Don Church
2002-03-21
3 reads
I am using Access Project (.adp) as the frontend to a SQL2000 database. I have a button on a form that uses the SendObject command to email the report. Access always prompts for the output format which is always Rich Text Format. I have been trying with no success to include RTF in the code […]
2002-03-15
5 reads
[1] Database MBC: Transaction Log Backup... Destination: [D:\Mssql7\Backup\MBC_tlog_200203141140.TRN] [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 4213: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot allow BACKUP LOG because file 'MBC_Data' has been subjected to nonlogged updates and cannot be rolled forward. Perform a full database, or differential database, backup. [Microsoft][ODBC SQL Server Driver][SQL Server]Backup or restore operation terminating abnormally. […]
2002-03-14
5 reads
Hi, I am having trouble in connection to a Access 97 database that uses a workgroup file. I supplied the correct username and password but the DTS return an error message saying "Cannot start your application. The workgroup information file is missing or opened exclusively by another user." I then supplied the location of the […]
2002-03-12
2 reads
What would be the restrictions to using "Transactional Replication" as a method of failover?
2002-03-12
1 reads
I am getting an error importing with DTS a Date/time format from access 2000 into a SQL 7 table. The error states "Error at destintion for Row 63 Errors incountered so far in this task: 1 Insert error, column 7 ("Date", DBTYPE_DBTIMESTAMP), status 6 Data overflow Invalid Char value for cast specification. And Row 63??? […]
2002-03-12
2 reads
I am going to upgrade a SQL6.5 server with 4G of Data to SQL7.0 sp3. What would be the best procedure to do it??? One of my friend did a straight 6.5 to 7 upgrade and it stalled halfway through it and damage all the data.
2002-03-10
1 reads
Guys, Am in need of urgent help. I tried saving a DTS package in the 'Repository Packages' section of Data Transformation Services section but somehow that package is not visible in that section (Rep Packages)even when I refresh that section. However, I can view that DTS package in the 'Metadata' package section. But how can […]
2002-03-08
1 reads
Does anyone know where to find source code for the Northwind Updategrams Demo found at: http://home.domaindlx.com/mediapro/newdb/nwlistdetails.htm OR www.xmlpitstop.com/demos/UserGroup/Meeting6/IE4/NWListDetails.htm I find this example very promising and would like to integrate the concepts in my apps! Naturally, any other working examples would be very much appreciated! Thanks!!
2002-03-05
1 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers