Re: Query to find records - Database Discussion Boards

First Prev Next

Re: Remote connection to sql server

Bert delaVega8-Feb-08 7:36

Bert delaVega

8-Feb-08 7:36

I'm not going to backtrack through the thread, but here's some hints:

- 1433 is the tcp/ip sql port. Try and Telnet to the port on the machine with the sql server (telnet <ip> 1433. If it connects, that's not the problem.

- Enable remote access, which depends on your network configuration. If the sql db and web server are the same machine, that's not the problem.

- If you're using Sql 2005 Express, then I think you can't connect remotely (not sure since I don't use it).

- Check your connection string, user, password, default db, etc.

- Try using SQL Manager from another machine. If you can connect and view tables, then it's a configuration problem in your connection.

- If your connection settings are in a web.config, make sure you're really picking up the config file you should be.

- Check the firewall. The port should be open (1433) but also make sure it routes to the sql server.

Usually when I run into problems, one of the above will fix it. Yours may be different. Hope this helps!

Re: Remote connection to sql server

eyeseetee10-Feb-08 22:03

eyeseetee

10-Feb-08 22:03

Hey

I have tried all of those
Nothing is working still
the sql server and web server are on two seperate machines
does this make a difference to how i would connect?

cheers for the pointers

store/retreive images to/from sql database

Paulraj G6-Feb-08 23:48

Paulraj G

6-Feb-08 23:48

hi...

am using vc++(mfc) and sql 2005.
how can i store images to sql database?
how can i retreive image from sql database?

please help me. am trying this for last few days...

but still i didn't get...

thank you...

paulraj

Re: store/retreive images to/from sql database

sirisha guttikonda7-Feb-08 0:25

sirisha guttikonda

7-Feb-08 0:25

hi,

covert the inage in to binary format and save it.

siri

Re: store/retreive images to/from sql database

Paulraj G7-Feb-08 1:01

Paulraj G

7-Feb-08 1:01

hi...

i tried for that way.

but but still am not get output.

can you pls send me the sample code?

it will be very helpfull for me...

paulraj

Query to find records

sirisha guttikonda6-Feb-08 22:25

sirisha guttikonda

6-Feb-08 22:25

hi all

i need some help in this query i.e

i want to retrieve 5 to 10 records from a table.i don't have identity column in my table

for this how can write a query???
can u plz help me..

Thank you

siri

Re: Query to find records

Vimalsoft(Pty) Ltd6-Feb-08 22:31

Vimalsoft(Pty) Ltd

6-Feb-08 22:31

hi

Please Explain in Detail , or Show us what did you do before you decided to post. We can Help you if you explain in Detail

Thanks

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za

Re: Query to find records

sirisha guttikonda6-Feb-08 22:38

sirisha guttikonda

6-Feb-08 22:38

hi
Currenctly iam displaying top 5 records(latest entered) from a table.
now i want to display next five records.

this is what i want to do

thank you.

siri

Re: Query to find records

Vimalsoft(Pty) Ltd7-Feb-08 2:06

Vimalsoft(Pty) Ltd

7-Feb-08 2:06

What you are Requesting is SQl Paging, try this

<br />
select top 10 * employees<br />
from employees<br />
where NOT employee_id IN (select top 10 employee_id from employee)<br />

And look at this http://www.petefreitag.com/item/59.cfm[^]

or
http://www.sqlteam.com/article/whats-after-top[^]

And as you can see the above Example and links, requires you to have a Primary key for your table

Thanks

Hope it helps

Data export problem

Kissy166-Feb-08 19:27

Kissy16

6-Feb-08 19:27

Here i am exporting my database tables and views onto the serer.
The problem i am getting is while export tables and views,they are automatically selected and exporting is complted.But on the server these tables and views are copied under Tables.
So wherever i am using view,it is showing blank data.
How to export tables and views so that they will store differntly on the same database like normal database we see.By generating script we can do that.I dont know how to generate it?
Hive me some idea to fulfill my task.
Plz understand my problem and give me an idea.
Thanks in advance.

kissy

Re: Data export problem

^That's Aragon6-Feb-08 19:55

^That's Aragon

6-Feb-08 19:55

Hi!

I cant understand your problem exatly. But if you want to generate a script
then try this. It is for SQL.

<br />
1) Right Click the table/dataBase/View under Object Explorer<br />
2) Select the option "Script Table/DataBase/View as " and choose CREATE TO

This will generate appropriate Script.

I hope this will help you.
Regards.

"Save water,It's precious" Smile | :)

Re: Data export problem

Kissy166-Feb-08 20:01

Kissy16

6-Feb-08 20:01

Thaks for ur response.
I cant udnerstand how to run script?I have generated before export,but i dont know how to use it.
Otherwise in the object brower,It is give like
Script Object to New window.,to file,to clipboard etc.
Here how i have to use??
Plz dont irritate and give me solution/idea/example.
please..

kissy

Re: Data export problem

^That's Aragon6-Feb-08 20:10

^That's Aragon

6-Feb-08 20:10

Hi!

Connect to your DB at Server and execute the script.

"Save water,It's precious" Smile | :)

Re: Data export problem

Kissy166-Feb-08 21:01

Kissy16

6-Feb-08 21:01

Thanks 4 ur answer.My problem got solved

kissy

Re: Data export problem

^That's Aragon6-Feb-08 21:24

^That's Aragon

6-Feb-08 21:24

You are Welcome! Smile | :)

"Save water,It's precious" Smile | :)

Want to Disable Print Statement in Stored Procedures in SQL2005

salman kazi6-Feb-08 19:23

salman kazi

6-Feb-08 19:23

Hi Its Salman I want to disable the Print Statement in all the stored procedure i have in SQL 2005 Database. so can anyone give me idea that how i can do this.
thanks in Advance
I am new in this Field so please guide me

Regards,
Salman

Re: Want to Disable Print Statement in Stored Procedures in SQL2005

pmarfleet6-Feb-08 21:48

pmarfleet

6-Feb-08 21:48

m_salman wrote:
I want to disable the Print Statement in all the stored procedure

Err...comment them out?

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Re: Want to Disable Print Statement in Stored Procedures in SQL2005

salman kazi6-Feb-08 22:35

salman kazi

6-Feb-08 22:35

there are some 2000+ stored procedures so i cant do that manually as even in some stored procedures they have been written more then once

for example:

Print @strSQL + @strSQL2

this kind of statement is present in almost all the Stored procedures so i want to disable them.

Thanks
Regards,
Salman

DTS Package

dnsl6-Feb-08 19:04

dnsl

6-Feb-08 19:04

i am using a DTSPackage named "DTPkg" ... this DTS Package i am invoking from my VB.NET Windows Application... In the DTS Package what i am trying to do is that ia am populating the text file with the records that are selected from SQL Server Table .... i am using Dynamic Property for Global variable ... the name of the Global variable is CSN ... the text file should be created whose name shud be the value containing in the CSN variable ... in the destination text file we need to give the file name no ? how we can do that ? anybody know how to do this ? PLz help
Any help Appreciated ..

Re: DTS Package

GuyThiebaut6-Feb-08 23:12

GuyThiebaut

6-Feb-08 23:12

I wrote a web page a while back on using DTS packages with Microsoft Access.
The page describes outputting data to a text file.
I think it should cover most of what you need to know.

Clickety here

You always pass failure on the way to success.

Does anyone know if I can use the system views such as master..sysprocesses within a view bound to the base table?

Ravi kumar G6-Feb-08 5:28

Ravi kumar G

6-Feb-08 5:28

VIEW Schemabinding
Does anyone know if I can use the system views such as master..sysprocesses within a view bound to the base table?

Ravikumar
[Coimbatore]

Re: Does anyone know if I can use the system views such as master..sysprocesses within a view bound to the base table?

Adeel Chaudhry22-Apr-08 2:05

Adeel Chaudhry

22-Apr-08 2:05

Views can be used in views, but then they may not be update-able i.e. the views using other views may only be read-only!

Give it a try! Smile | :)

Regards,

Adeel

Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.

How to check a condition using sql

Exelioindia6-Feb-08 4:04

Exelioindia

6-Feb-08 4:04

hi
Any one please suggest me how to write a sql query based on the following, in my table i am having a bit column, when the column value is true then it should retun me a string as checke else unchecked if false.

please suggest me

thanks in advance

Know is Drop, Unknown is Ocean

Re: How to check a condition using sql

J4amieC6-Feb-08 4:34

J4amieC

6-Feb-08 4:34

SELECT 
 CASE myBitField 
  WHEN 1 THEN 'Checked'
  ELSE 'Unchecked
 END AS IReallyShouldNotDoThisToBitFields
FROM PerfectlyWellFormedTable

Seriously, If the table has a bit field then return as-is. Do any logic where logic should be, not in the database. You're just upping the IO from your server to your client.

Returning a bit field sends 1 bit of data, returning the string "checked" and "unchecked" is significantly greater.

Re: How to check a condition using sql

Sallu17497-Feb-08 17:42

Sallu1749

7-Feb-08 17:42

Hi,
Check If following statement works for you.

SELECT CASE WHEN BITCOL = 1 THEN 'CHECKED' ELSE 'UNCHECKED' END
FROM TABLENAME

Regards,
Sulaman

Last Visit: 31-Dec-99 18:00 Last Update: 14-May-24 22:54

Refresh

ᐊ Prev 1...1263 1264 1265 126612671268 1269 1270 1271 1272 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.