|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
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
|
|
|
|
|
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
|
|
|
|
|
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" 
|
|
|
|
|
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
|
|
|
|
|
Hi!
Connect to your DB at Server and execute the script.
"Save water,It's precious"
|
|
|
|
|
Thanks 4 ur answer.My problem got solved
kissy
|
|
|
|
|
You are Welcome!
"Save water,It's precious"
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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 ..
|
|
|
|
|
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.
|
|
|
|
|
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]
|
|
|
|
|
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!
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.
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
Hi,
Check If following statement works for you.
SELECT CASE WHEN BITCOL = 1 THEN 'CHECKED' ELSE 'UNCHECKED' END
FROM TABLENAME
Regards,
Sulaman
|
|
|
|
|
Could anyone out there assist me with the data-replication problem that i have here.
i have a database which is in a different continent and like 5 clients have to replicate data to it from different countries.
My problem is that i need to allow the subscribers to be able to be able to publish to the main server but it is giving me problems that are related to IP
Anyone with a tutorial that could help?
|
|
|
|
|
I am currently optimising an internal intranet site, and I have spotted a possible gain - moving the abbreviation of a text field from the RowDataBound event of a GridView into the SQL stored proc that retrieves the data.
My question is - can anyone suggest the best way to choose an appropriate abbreviation point so that the ellipsis is added only after a break in the text?
i.e.
This is a...
rather than
This is a te...
As I am looking for performance gains, I'll put up with ugly abbreviation if I have to, but it would be nice if there were a [relatively] quick, simple solution to keep it looking pretty...
|
|
|
|
|
|
Thanks for the suggestion - I'll give it a go.
I guess there's no definitive answer to whether it's faster more efficient to do the abbreviation on the SQL server as opposed to the web-server, what with hardware variables and the like?
My thinking was along the lines of avoiding looping algorithms - the c# code is currently doing a split, then adding words back until a limit is reached - in favour of a more set-based operation...
Maybe I should just grasp the nettle, and use a fixed length abbreviation...
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
