pivot information: code

Showing posts with label code. Show all posts

Friday, March 30, 2012

Please Help Just Upsized Access To Sql And Now Code Doesnt Work

here is the code i was using from a command button which basically used the first and last name fields to make a primary key called chart number. now it doesnt work and i belive it is in the dim rs as dao.recordset statement because this data now resides on an sql server. here is the code snippet.

Public Function chartlookup()
Dim db As DAO.Database <--believe to be the problem
Dim rs As DAO.Recordset <-- belive to be the problem
Dim SQL As String
Dim NewNum As Integer
Dim NeWChartNum As String

SQL = "Select max(Cint(Right([chartnumber],6))) As RecNum From tblpatientinfo WHERE UCase(Left([chartnumber],5)) = '" & UCase(Left([Forms]![fpatient]![lname], 3)) & UCase(Left([Forms]![fpatient]![fname], 2)) & "'"

Set db = CurrentDb() <-- -problem
Set rs = db.OpenRecordset(SQL) <--problem

If IsNull([Forms]![fpatient]![chartnumber]) = False Then GoTo 400

If rs.EOF = False Then
If IsNull(rs!RecNum) = False Then
NewNum = rs!RecNum + 1
Else
NewNum = 1
End If
End If
'If NewNum = 1 Then

[Forms]![fpatient]![chartnumber] = UCase(Left([Forms]![fpatient]![lname], 3)) & UCase(Left([Forms]![fpatient]![fname], 2)) & Format(NewNum, "000000")
'End If

400 End Function

basically if you typw in john smith this code would put smijo00001 into chartnumber field now i get a run-time error 91.What error are you receiving?

Also be advised that UCase is not supported in MS SQL, you should use UPPER, nor is Cint.

You have a few access specific casts there that are going to cause trouble for you.|||Change you dao to ado - using recordset and/or connection objects.|||Originally posted by Teddy
What error are you receiving?

Also be advised that UCase is not supported in MS SQL, you should use UPPER, nor is Cint.

You have a few access specific casts there that are going to cause trouble for you.

im receiving a run-time error 91 in the set rs= db.recordset(sql) statement but i know it coming from previous dim db as dao.database and dim rs as dao.recordset. i dont know how to convert this vb code to work with sql. maybe dim rs as sql.recordset and dim db as sql.database . please forgive my ignorance but i am new to sql and i dont know the syntax for sql. by the way thank you for the advice with ucase and cint not working . i tried a previous suggestion and turned dim rs as ado.recordset but the only option i get is adobe.recordset am i missing a reference .|||You need to use the ms ado 2.x library reference. Using adodb.recordset and adodb.connection - however, in your case you only need adodb.recordset.|||Hey
Who one saying that ODBC Connections not possible by DAO?

[QUOTE][SIZE=1]Originally posted by opcbriley
here is the code i was using from a command button which basically used the first and last name fields to make a primary key called chart number. now it doesnt work and i belive it is in the dim rs as dao.recordset statement because this data now resides on an sql server. here is the code snippet.

Public Function chartlookup()
Dim wrkODBC As Workspace
Dim conPubs As Connection
Dim rs As DAO.Recordset <-- belive to be the problem
Dim SQL As String
Dim NewNum As Integer
Dim NeWChartNum As String

SQL = "Select max(Cint(Right([chartnumber],6))) As RecNum From tblpatientinfo WHERE UCase(Left([chartnumber],5)) = '" & UCase(Left([Forms]![fpatient]![lname], 3)) & UCase(Left([Forms]![fpatient]![fname], 2)) & "'"

Set wrkODBC = CreateWorkspace("NewODBCWorkspace", "admin", "", dbUseODBC)
Set conPubs = wrkODBC.OpenConnection("costing", dbDriverNoPrompt)
.........

You may also open connection by using this code
remaining code will remain same
plz use it n reply me
thx|||You can use odbc - but don't - you are much better off using oledb (or use tds in .net). Better performance, resource usage and flexibility/functionality.|||yeah i know that OLEDB performance much better that dao but person asked abt DAO libraray n no one was there to reply by DAO libraray so I hv ginven reply by DAO library|||i appreciate all your help i was able to switch to ado connection i finally learned the syntax last night after about hour of reading. that code is working perfect now.

now on to find all my other problems that i have to change to be compatible with sql. i sure hope sql is worth all this trouble.

Wednesday, March 28, 2012

Please help debug.

Hi,
What's wrong with the following code? Please help. I am using MS SQL
2000.
create table one (
a float NOT NULL,
b varchar (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
)
alter table one
alter column a {drop} NOT NULL
alter column b {drop} NOT NULL
;
Thanks,
Mike
Please do not multi post.
Syntax usage is incorrect. Please use the below code to modify NOT NULL to
NULL
alter table one alter column a Float NULL
alter table one alter column b Varchar(50) NULL
Thanks
Hari
"Michael" wrote:

> Hi,
> What's wrong with the following code? Please help. I am using MS SQL
> 2000.
> create table one (
> a float NOT NULL,
> b varchar (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
> )
> alter table one
> alter column a {drop} NOT NULL
> alter column b {drop} NOT NULL
> ;
> Thanks,
> Mike
>

Please help debug.

Hi,
What's wrong with the following code? Please help. I am using MS SQL
2000.
create table one (
a float NOT NULL,
b varchar (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
)
alter table one
alter column a {drop} NOT NULL
alter column b {drop} NOT NULL
;
Thanks,
MikePlease do not multi post.
Syntax usage is incorrect. Please use the below code to modify NOT NULL to
NULL
alter table one alter column a Float NULL
alter table one alter column b Varchar(50) NULL
Thanks
Hari
"Michael" wrote:
> Hi,
> What's wrong with the following code? Please help. I am using MS SQL
> 2000.
> create table one (
> a float NOT NULL,
> b varchar (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
> )
> alter table one
> alter column a {drop} NOT NULL
> alter column b {drop} NOT NULL
> ;
> Thanks,
> Mike
>

Please help debug.

Hi,
What's wrong with the following code? Please help. I am using MS SQL
2000.
create table one (
a float NOT NULL,
b varchar (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
)
alter table one
alter column a {drop} NOT NULL
alter column b {drop} NOT NULL
;
Thanks,
MikePlease do not multi post.
Syntax usage is incorrect. Please use the below code to modify NOT NULL to
NULL
alter table one alter column a Float NULL
alter table one alter column b Varchar(50) NULL
Thanks
Hari
"Michael" wrote:

> Hi,
> What's wrong with the following code? Please help. I am using MS SQL
> 2000.
> create table one (
> a float NOT NULL,
> b varchar (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
> )
> alter table one
> alter column a {drop} NOT NULL
> alter column b {drop} NOT NULL
> ;
> Thanks,
> Mike
>

Monday, March 26, 2012

Please help - setting order of select in a self-referencing table

Hello,
I have a table of product categories that looks like this (air code, so
could be some typos, but it's basically right)...
create table producttypes (
ptype int not null identity(1,1) primary key,
typename varchar(50) not null default '',
ParentCat int references producttypes(ptype)
)
This allows categories to contain subcategories and so on.
In order to allow me to see the hierarchy, I am using the following
code, modified from some found in "Inside SQL Server 7.0" by Kalen
Delaney.
-- SQL starts
declare @.level int, @.current int
create table #stack (depthlevel int, ptype int)
create table #orgchart (seqno int identity, orglevel int not null, ptype int
not null)
set rowcount 1
select @.level=1, @.current=ptype from producttypes where ptype=parentcat
set rowcount 0
insert into #stack (depthlevel, ptype) values (@.level, @.current)
while (@.level>0)
begin
if exists (select * from #stack where depthlevel=@.level)
begin
set rowcount 1
select @.current=ptype from #stack where depthlevel=@.level
set rowcount 0
insert into #orgchart (orglevel, ptype) select @.level, @.current
delete from #stack where depthlevel=@.level and ptype=@.current
insert into #stack select @.level+1, ptype from producttypes where parentcat=
@.current and parentcat<>ptype
if @.@.ROWCOUNT > 0 select @.level=@.level+1
end
else
select @.level=@.level-1
end
select o.orglevel, e.ptype, e.parentcat, e.typename from #orgchart as o
join producttypes as e on e.ptype=o.ptype order by o.seqno
drop table #stack, #orgchart
-- SQL ends
This produces a set of results that gives me all the categories. I can
use the orglevel field to tell what level I'm at, so if it changes, I
can see if I've gone up or down the hierarchy.
Now, the problem is that I can't work out how to set the order of
categories. For example, if the above SQL produces...
1 16 16 Products
2 17 16 Outdoor Toys
3 1 17 Trampolines
3 2 17 Slides
3 3 17 Swings
3 4 17 Accessories
3 5 17 Climbing Frames
3 7 17 Bicycles
you can see that the categories on level 3 are not in any obvious order.
I would like to have them in alphabetical order.
Any ideas how I would modify the above SQL to do this? TIA
Alan Silver
(anything added below this line is nothing to do with me)Try
select o.orglevel, e.ptype, e.parentcat, e.typename from #orgchart as o
join producttypes as e on e.ptype=o.ptype order by o.seqno, e.typename
The results should be sorted first by the orglevel, and results within the
same orglevel will be sorted alphabetically. The syntax reads like "order
results first by o.seqno, then by e.typename"
"Alan Silver" wrote:

> Hello,
> I have a table of product categories that looks like this (air code, so
> could be some typos, but it's basically right)...
> create table producttypes (
> ptype int not null identity(1,1) primary key,
> typename varchar(50) not null default '',
> ParentCat int references producttypes(ptype)
> )
> This allows categories to contain subcategories and so on.
> In order to allow me to see the hierarchy, I am using the following
> code, modified from some found in "Inside SQL Server 7.0" by Kalen
> Delaney.
> -- SQL starts
> declare @.level int, @.current int
> create table #stack (depthlevel int, ptype int)
> create table #orgchart (seqno int identity, orglevel int not null, ptype i
nt not null)
> set rowcount 1
> select @.level=1, @.current=ptype from producttypes where ptype=parentcat
> set rowcount 0
> insert into #stack (depthlevel, ptype) values (@.level, @.current)
> while (@.level>0)
> begin
> if exists (select * from #stack where depthlevel=@.level)
> begin
> set rowcount 1
> select @.current=ptype from #stack where depthlevel=@.level
> set rowcount 0
> insert into #orgchart (orglevel, ptype) select @.level, @.current
> delete from #stack where depthlevel=@.level and ptype=@.current
> insert into #stack select @.level+1, ptype from producttypes where par
entcat=@.current and parentcat<>ptype
> if @.@.ROWCOUNT > 0 select @.level=@.level+1
> end
> else
> select @.level=@.level-1
> end
> select o.orglevel, e.ptype, e.parentcat, e.typename from #orgchart as o
> join producttypes as e on e.ptype=o.ptype order by o.seqno
> drop table #stack, #orgchart
> -- SQL ends
>
> This produces a set of results that gives me all the categories. I can
> use the orglevel field to tell what level I'm at, so if it changes, I
> can see if I've gone up or down the hierarchy.
> Now, the problem is that I can't work out how to set the order of
> categories. For example, if the above SQL produces...
> 1 16 16 Products
> 2 17 16 Outdoor Toys
> 3 1 17 Trampolines
> 3 2 17 Slides
> 3 3 17 Swings
> 3 4 17 Accessories
> 3 5 17 Climbing Frames
> 3 7 17 Bicycles
> you can see that the categories on level 3 are not in any obvious order.
> I would like to have them in alphabetical order.
> Any ideas how I would modify the above SQL to do this? TIA
> --
> Alan Silver
> (anything added below this line is nothing to do with me)
>|||>Try
>select o.orglevel, e.ptype, e.parentcat, e.typename from #orgchart as o
>join producttypes as e on e.ptype=o.ptype order by o.seqno, e.typename
>The results should be sorted first by the orglevel, and results within the
>same orglevel will be sorted alphabetically. The syntax reads like "order
>results first by o.seqno, then by e.typename"
Mark,
Thanks for the reply, but if you look carefully, it's not that simple.
Your suggestion will list all level 2 categories together, followed by
all level 3 and so on. This will not give the correct hierarchy as there
may be several level 2 categories each with subcategories (ie level 3).
If this isn't clear, look at the longer category listing shown later on.
This is a more complete list than the abbreviated one I showed before.
Note that the ordering is done on seqno, which is the order in which the
categories were put into the orgchart table. The ordering is not done on
the level at all.
I think I need to modify the way the categories are pulled out of the
producttypes table when they are inserted into the stack table. Trouble
is, I can't see how to control the ordering as they are being pulled one
at a time.
Thanks for the reply. Any further help would be appreciated.
Longer category listing follows...
level typename
1 Products
2 Outdoor Toys
3 Trampolines
3 Slides
3 Swings
3 Accessories
3 Climbing Frames
3 Bicycles
2 Indoor Toys
3 Snooker Tables
3 Boy's Toys
4 Hard Puzzles
3 Girl's Toys
4 Easy Puzzles
3 Board Games
3 Pets
4 Ferrets
4 Dogs
4 Cats
>"Alan Silver" wrote:
>
Alan Silver
(anything added below this line is nothing to do with me)sql

Please Help

i'd like to get info on storing photos to Sql Server 2000 using VB 6.0. i searched many vb sites, but all have code samples in vb.Net.

can any 1 give code samples if possible?

one more thing..

my application uses mssql server running in an IBM server machine ,i hav plans to give one machine as a back up server. i wud like to have the data updated on both machines simultaneously..
i.e,
either the data must go to both the Machines (SErver & Back Up Server) or it should not go to both.

how can i implement this?

i do welcome your views/ideas in this context.

thanks in advanceSure.

Don't.

Store the filepaths of the images.|||I'd have to agree with Brett about storing only the path to a file but if you really must store the image in a DB try this...

Include a reference to "Microsoft ActiveX Data Objects 2.5 Library" (or later)

Using the Northwind DB as an example, open your connection and add the following

Dim rs as New ADODB.Recordset
Dim sql as String
Dim mStream as Stream

sql = "SELECT EmployeeID, Photo FROM Employees Where EmployeeID=1"
rs.Open sql, adoConn, adOpenKeyset, adLockPessimistic

' Load the image into the DB field

Set mStream = New ADODB.Stream
mStream.Type = adTypeBinary
mStream.Open
mStream.LoadFromFile "c:\MyNewPhoto.jpg" ' <-******* Your filename here
rs.Fields("Photo").Value = mStream.Read

rs.Close
Set rs = Nothing

That replaces the existing image with a new one. To dump the existing image to a file you can use...

Dim rs as New ADODB.Recordset
Dim sql as String
Dim mStream as Stream

sql = "SELECT * FROM Employees Where EmployeeID=1"
rs.Open sql, adoConn, adOpenKeyset, adLockPessimistic

Set mStream = New ADODB.Stream
mStream.Type = adTypeBinary
mStream.Open
mStream.Write rs.Fields("Photo").Value
mStream.SaveToFile "c:\MyImage.jpg", adSaveCreateOverWrite ' <-******* Your filename here

rs.Close
Set rs = Nothing

The major problem I've found with storing images in the DB is ease of editing. A file can be loaded into Paint or whatever but a DB image must first be dumped to disk and then sent back after editing.|||thank you very much...

Wednesday, March 21, 2012

Please can someone recommend?

Hi,

I was wondering if anyone could recommend some freeware code or a 3rd Party tool for identifying and logging SQL Server blocking and its cause.

Mny thanks.

Col.

Performance Monitor, SQL Profiler, and Management Studio all report blocking information and they're free with SQL Server.

Microsoft has a KB article that describes how blocking can be monitored in SQL Server 2005 and 2000.
http://support.microsoft.com/kb/271509

You may also want to check out Spotlight on SQL Server by Quest.
http://www.quest.com/spotlight-on-sql-server-enterprise/

I think this Idera product does too, but I've never used it.
http://www.idera.com/Products/SQLdm/Features.aspx

HTH...

Joe|||

Thanks Joe, I have been loocking at the quest stuff. It would appear that PA may be better suited for historical blocking analysis,

http://www.quest.com/Quest-Performance-Analysis-for-SQL-Server/

|||I believe they have a trial version available for download. If so, do that and play around around with it to see if it's providing the information you need. Typically someone from the company will contact you after the download and you can ask them all kinds of questions about it.

HTH...

Joe

Please can someone point out whats wrong with my code

Hi,

I have code on a page to update one table and insert info into another, but I cant make it work. I am new to coding and i think there are many mistakes. Please can someone pick out a few that need to be changed for the page to work.

Code:

private bool ExecuteUpdate(int quantity)
{
SqlConnection con = new SqlConnection();
con.ConnectionString = "ConnectionString";

con.Open();

SqlCommand command = new SqlCommand();
command.Connection = con;
TextBox TextBox1 = (TextBox)FormView1.FindControl("TextBox1");
Label labname = (Label)FormView1.FindControl("Label3");
Label labid = (Label)FormView1.FindControl("Label13");

command.CommandText = "UPDATE Items SET Quantityavailable WHERE productID='@.productID' = " + TextBox1.Text +

command.ExecuteNonQuery();
return true;
con.Close();
}

private bool ExecuteInsert(String quantity)
{
SqlConnection con = new SqlConnection();
con.ConnectionString = "ConnectionString";

con.Open();

command.CommandText = "INSERT Transactions SET Usersname = @.UserName" +
"; INSERT Transactions SET Itemid WHERE productID='@.productID' = @.productID; INSERT Transactions SET itemname = @.Itemsname" +
"; INSERT Transactions SET Date WHERE productID='@.productID' = " + DateTime.Now.ToString() +
"; INSERT Transactions SET Qty WHERE productID='@.productID' = " + TextBox1.Text;
command.Parameters.Add("@.UserName", System.Web.HttpContext.Current.User.Identity.Name);
command.Parameters.Add("@.Itemsname", labname.Text);
command.Parameters.Add("@.productID", labid.Text);
command.ExecuteNonQuery();
return true;
con.Close();
}

protected void Button2_Click(object sender, EventArgs e)
{
TextBox TextBox1 = FormView1.FindControl("TextBox1") as TextBox;
ExecuteUpdate(Int32.Parse(TextBox1.Text) );
ExecuteInsert(Int32.Parse);
}

Current error message is:

The best overloaded method match for 'detailproview.ExecuteInsert(string)' has some invalid arguments

Line 74: ExecuteInsert(Int32.Parse);

Thanks if someone can help!

Jon

Hi,

The best way for you to see why it is not working is to debug your code and check the values in the object using Immediate window or pointing the mounse on the objects after value is assigned.

Maybe you are not getting the id that you are using in the WHERE lause of your update statement. Make sure you are getting valid id and that it exists in database.

Finally you are calling return true before closing the connection, first close the connection than return a value.

|||

Int32.Parse is a method and you need to pass in an argument to it, the one string which you want to conevrt to an int, like you are doing it here:

ExecuteUpdate(Int32.Parse(TextBox1.Text) );

Hope this helps,

Vivek

|||

Hi,

Thanks both great to help me iron out bugs.

I will put up a new post with the latest set of error messages!

Cheers

Jon

please .....i need help

hi ...
how could i create report with vc++ using crystal report ?and how to use crystal report view class?? is there any tutorial or sample code avaliable somewhere .
thanks alot for interest in my query .See if you find tutorials here
support.businessobjects.com

Tuesday, March 20, 2012

placing table on the memory

Hello there
I have reference localAreaCode table with 3000 records , i need to check on
existing phone table that the area code exist on LocalAreaCode table.
So far the query worked very slow.
Is there a way to place the LocalAreaCode table at the memory, to inprove
perfomance?Hi Roy,
In SQL Server 2000 you can use:
1) DBCC PINTABLE
2) sp_tableoption
See Books Online for more info about this.
I'm pretty sure that DBCC PINTABLE does nothing in SQL Server 2005 and
for sp_tableoption the choice to pin a table in memory is no longer
there. The rationale is that using these options can cause bad things
to happen. For example, in SQL Server 2005 Books Online we have the
following in the DBCC PINTABLE entry:
==============================
This functionality was introduced for performance in SQL Server version
6.5. DBCC PINTABLE has highly unwanted side-effects. These include the
potential to damage the buffer pool. DBCC PINTABLE is not required and
has been removed to prevent additional problems. The syntax for this
command still works but does not affect the server.
==============================
Sorry I can't be of more help|||Maybe we should first take look at the query. Please post it.
Also check the execution plan to see whether indexes are used properly. The
table is indexed, isn't it?
ML
http://milambda.blogspot.com/|||You could do this in 2000, using sp_tableoption. This was misused, though so
I believe that removed
it in 2005. If the table is accessed frequently enough, it will be cache in
memory, especially with
only 3000 rows. Still, you want to make sure that queries against it are eff
icient (create
supporting indexes etc).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Roy Goldhammer" <roy@.hotmail.com> wrote in message news:uetz2fwfGHA.4276@.TK2MSFTNGP03.phx.
gbl...
> Hello there
> I have reference localAreaCode table with 3000 records , i need to check o
n existing phone table
> that the area code exist on LocalAreaCode table.
> So far the query worked very slow.
> Is there a way to place the LocalAreaCode table at the memory, to inprove
perfomance?
>|||With only 3000 rows this should never be slow, so I suspect problems
with the table design or the query. You need to post the table
design, all keys and indexes, and the query that is slow.
Roy Harvey
Beacon Falls, CT
On Wed, 24 May 2006 10:58:04 +0300, "Roy Goldhammer" <roy@.hotmail.com>
wrote:

>Hello there
>I have reference localAreaCode table with 3000 records , i need to check on
>existing phone table that the area code exist on LocalAreaCode table.
>So far the query worked very slow.
>Is there a way to place the LocalAreaCode table at the memory, to inprove
>perfomance?
>

Friday, March 9, 2012

PL/SQL to TSQL

I need a tool to convert (at least 50%) my source code of 200+ stored procedures from PL/SQL to TSQL.
Could any one help me?
ThanksHi Carlos,

Check out our website http://www.dbbest.com

PL/SQL for searching

hi all..

i'm a beginner in using oracle9i form for web dev and ..i have problem to create searching button (pl/sql code) where the record that i tried to find using the text item..can somebody help me

example:
textitem10 is value that will be keyin in the form
----
declare
textitem10 number(2);

begin
select empno,ename,edept from emp
into :textitem1,
:textitem2,
:textitem3
where empno = 'textitem10'
end;
execute_query;

but my coding is doesn't work..
found error "FRM-40735: WHEN-BUTTON-PRESSED trigger araised unhandled exception ORA-01403"..any body know help me..pleaze
thanks
flyguysOriginally posted by flyguys
hi all..

i'm a beginner in using oracle9i form for web dev and ..i have problem to create searching button (pl/sql code) where the record that i tried to find using the text item..can somebody help me

example:
textitem10 is value that will be keyin in the form
----
declare
textitem10 number(2);

begin
select empno,ename,edept from emp
into :textitem1,
:textitem2,
:textitem3
where empno = 'textitem10'
end;
execute_query;

but my coding is doesn't work..
found error "FRM-40735: WHEN-BUTTON-PRESSED trigger araised unhandled exception ORA-01403"..any body know help me..pleaze
thanks
flyguys
ORA-01403 means "No data found" - i.e. the select returned no rows.

This is probably because you should have written it like this:

select empno,ename,edept from emp
into :textitem1, :textitem2, :textitem3
where empno = :textitem10;

As written, it was looking for an emp record with an empno value of 'textitem10', which of course does not exist.

PL/SQL code to load data from a flat file into a MS-SQL Server table

Hi everybody,
I am very new to MS-SQL Server and I need the PL/SQL code to load data
from a flat file into a MS-SQL Server table. I would appreciate your
kind help ASAP. Thanks in advance.> I am very new to MS-SQL Server and I need the PL/SQL code to load data
> from a flat file into a MS-SQL Server table.
PL/SQL is the term used for Oracle SQL language extensions. Transact-SQL
(often abbreviated T-SQL) is used in Microsoft/Sybase SQL Server.
You can use BULK INSERT to import data directly from a text file. See the
Books Online for usage details.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Ratan" <ratan.nitrkl@.gmail.com> wrote in message
news:1194866854.016582.213720@.e34g2000pro.googlegroups.com...
> Hi everybody,
> I am very new to MS-SQL Server and I need the PL/SQL code to load data
> from a flat file into a MS-SQL Server table. I would appreciate your
> kind help ASAP. Thanks in advance.
>|||Thank you so much Dan. Could you please suggest me some good books?
On Nov 12, 5:30 pm, "Dan Guzman" <guzma...@.nospam-
online.sbcglobal.net> wrote:
> > I am very new to MS-SQL Server and I need the PL/SQL code to load data
> > from a flat file into a MS-SQL Server table.
> PL/SQL is the term used for Oracle SQL language extensions. Transact-SQL
> (often abbreviated T-SQL) is used in Microsoft/Sybase SQL Server.
> You can use BULK INSERT to import data directly from a text file. See the
> Books Online for usage details.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Ratan" <ratan.nit...@.gmail.com> wrote in message
> news:1194866854.016582.213720@.e34g2000pro.googlegroups.com...
>
> > Hi everybody,
> > I am very new to MS-SQL Server and I need the PL/SQL code to load data
> > from a flat file into a MS-SQL Server table. I would appreciate your
> > kind help ASAP. Thanks in advance.- Hide quoted text -
> - Show quoted text -|||> Thank you so much Dan. Could you please suggest me some good books?
I suggest Inside Microsoft SQL Server 2005: T-SQL Querying
(http://www.amazon.com/Inside-Microsoft-SQL-Server-2005/dp/0735623139).
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Ratan" <ratan.nitrkl@.gmail.com> wrote in message
news:1194874763.657788.164240@.o80g2000hse.googlegroups.com...
> Thank you so much Dan. Could you please suggest me some good books?
>
> On Nov 12, 5:30 pm, "Dan Guzman" <guzma...@.nospam-
> online.sbcglobal.net> wrote:
>> > I am very new to MS-SQL Server and I need the PL/SQL code to load data
>> > from a flat file into a MS-SQL Server table.
>> PL/SQL is the term used for Oracle SQL language extensions. Transact-SQL
>> (often abbreviated T-SQL) is used in Microsoft/Sybase SQL Server.
>> You can use BULK INSERT to import data directly from a text file. See
>> the
>> Books Online for usage details.
>> --
>> Hope this helps.
>> Dan Guzman
>> SQL Server MVP
>> "Ratan" <ratan.nit...@.gmail.com> wrote in message
>> news:1194866854.016582.213720@.e34g2000pro.googlegroups.com...
>>
>> > Hi everybody,
>> > I am very new to MS-SQL Server and I need the PL/SQL code to load data
>> > from a flat file into a MS-SQL Server table. I would appreciate your
>> > kind help ASAP. Thanks in advance.- Hide quoted text -
>> - Show quoted text -
>|||Thank you so much.
On Nov 13, 9:36 am, "Dan Guzman" <guzma...@.nospam-
online.sbcglobal.net> wrote:
> > Thank you so much Dan. Could you please suggest me some good books?
> I suggest Inside Microsoft SQL Server 2005: T-SQL Querying
> (http://www.amazon.com/Inside-Microsoft-SQL-Server-2005/dp/0735623139).
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Ratan" <ratan.nit...@.gmail.com> wrote in message
> news:1194874763.657788.164240@.o80g2000hse.googlegroups.com...
>
> > Thank you so much Dan. Could you please suggest me some good books?
> > On Nov 12, 5:30 pm, "Dan Guzman" <guzma...@.nospam-
> > online.sbcglobal.net> wrote:
> >> > I am very new to MS-SQL Server and I need the PL/SQL code to load data
> >> > from a flat file into a MS-SQL Server table.
> >> PL/SQL is the term used for Oracle SQL language extensions. Transact-SQL
> >> (often abbreviated T-SQL) is used in Microsoft/Sybase SQL Server.
> >> You can use BULK INSERT to import data directly from a text file. See
> >> the
> >> Books Online for usage details.
> >> --
> >> Hope this helps.
> >> Dan Guzman
> >> SQL Server MVP
> >> "Ratan" <ratan.nit...@.gmail.com> wrote in message
> >>news:1194866854.016582.213720@.e34g2000pro.googlegroups.com...
> >> > Hi everybody,
> >> > I am very new to MS-SQL Server and I need the PL/SQL code to load data
> >> > from a flat file into a MS-SQL Server table. I would appreciate your
> >> > kind help ASAP. Thanks in advance.- Hide quoted text -
> >> - Show quoted text -- Hide quoted text -
> - Show quoted text -

Friday, March 30, 2012

Please Help Just Upsized Access To Sql And Now Code Doesnt Work

Wednesday, March 28, 2012

Please help debug.

Please help debug.

Please help debug.

Monday, March 26, 2012

Please help - setting order of select in a self-referencing table

Please Help

Wednesday, March 21, 2012

Please can someone recommend?

Please can someone point out whats wrong with my code

please .....i need help

Tuesday, March 20, 2012

placing table on the memory

Friday, March 9, 2012

PL/SQL to TSQL

PL/SQL for searching

PL/SQL code to load data from a flat file into a MS-SQL Server table

PL/SQL code to load data from a flat file into a MS-SQL Server table

PL/SQL code to load data from a flat file into a MS-SQL Server table

pivot information

Blog Archive

About Me