Forum Replies Created
Viewing 15 posts - 301 through 315 (of 322 total)
-
RE: Difference between char,varchar,nvarchar, nchar,varchar2
see SQL BOL.
Kishore.P
-
RE: Insert 8 million records from text file to a table
use BCP command.
For more information see SQL BOL.
Kishore
-
RE: VB6 App using RDO to link to sequel 2005
Instead of using RDO's use ADO's.
-
RE: C# problem
It gives an error, see below line.
Error 1 'byte' does not contain a definition for 'maxvalue'
-
RE: Multiple Repeated Insertions
Hi
You can do the following way,
> Create a primary key on ReferenceNo column or ReferenceNo column is an Identity.
> All the operation can be handled in stored procedure.
Hopes to...
-
RE: Transposing columns
Can u try it,
create
view vwTranspose
as
select
ID
,
Amount_Type
,
Amount_Description =
-
RE: Add column with default value
Can u try it for the following way:
Ex:
create
table t
(
id int not
-
RE: Database shrinking problem
Using Import / Export, you can transfer all the data into new Database. This method may solve your problem.
Just Try it.
-
RE: Import Excel Spreadsheet (Residing in Internet) Data into SQL Server Database Table
you can develop your own application in the following way:
Method: 1
-> Develop an application using C#.NET, VB.NET, VB 6.0
-> Design the GUI as per your requirements and download the file...
-
RE: Dynamic SQL
Can u try the following way:
create
procedure spGetRows
(
@TopRows int)
as
begin
set
-
RE: Applying SP4 on a running database?
Better to do this in offline mode.
-
RE: How To Modify the Existing Column
USE sp_rename built in function.
Ex:
USE AdventureWorks;GOEXEC sp_rename 'Sales.SalesTerritory.TerritoryID', 'TerrID', 'COLUMN';GO
-
RE: SQL server CRASH, cant reconnect ODMC time out ..
Just try the following command and check output:
DBCC CHECKDB([<dbname>])
and also check the rest of parameters in SQL BOL.
Viewing 15 posts - 301 through 315 (of 322 total)