|
|
backup database 'dbname' to disk='C:\...'
Sabari MD
Application Developer
Veloxit Info Solutions
|
|
|
|
|
That is Simple
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
-- backup a database
ALTER PROCEDURE [dbo].[sp_BackupDatabase]
@databasename varchar(32),
@path varchar(256),
@filename varchar(64)
AS
set nocount on
declare @sql varchar(4000)
select @sql = 'BACKUP DATABASE ' + ltrim(rtrim( @databasename ))
select @sql = @sql + ' TO DISK = ''' + ltrim(rtrim(@path)) + ltrim(rtrim(@filename)) + ''' '
select @sql = @sql + ' WITH INIT'
--print @sql
execute ( @sql )
select 'Database successfully backed up!' [Result]
Welcome
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.somee.com
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
Hi Friends,
Im new in this and hope to get some advice.
I have to make a application to give advice to the students wich study direction they can choose.
They have to get a questionlist that they can awnser. The awnsers can be yes or no, or more then that, with 3 or more choices. The user can only select one awnser. So i have to use radiobuttonlists.
Now how can i implement this ? how can i make dynamically radionbuttonlists? what's the easist way to get this work?
Thanks
|
|
|
|
|
Hi
Are you looking to build the radio buttons in Javascript, or through an AJAX update panel ?
|
|
|
|
|
All you need is to load your data in some data wrapper answer by answer and then bind it to radio button list control by assigning it to its datasource property and call databind upon control.
|
|
|
|
|
if you want to make radio button dynamically , make html radio buttons
Sabari MD
Application Developer
Veloxit Info Solutions
|
|
|
|
|
How do I add a custom function to the built-in function list in InfoPath.
I have some custom functions that gather Active Directory information I would like to auto populate into InfoPath form fields that I want to include in the built-in function list drop down so a non-programmer form designer can apply them to fields on their forms.
I know how to do this programmatically so please don't tell me to add event logic to the form because there are many different organizations designing forms that need this functionality. I need to present these functions to people as they design their forms so they can apply them to textbox fields.
For example I would like a textbox field to populate with AD information, say telephone number or location, just like they would apply the userName function to get the name of the user logged into the workstation filling out the form in an application.
|
|
|
|
|
Hi,
I a parent page i have two frame, each having diffrent source pages.
How can i reload a page from another page?
eg: page Frame.aspx having two frames, onec src is home.aspx, second is user.aspx. When a button click event occur in home.aspx, i need to reload the user.aspx without changing position and without reloading Frame.aspx
Thankyou
YPKI
|
|
|
|
|
Didn't you try Master Pages instead of html frames ?
Education is not a way to escape poverty — it is a way of fighting it.
|
|
|
|
|
plz anyone send updating gridview in simple steps.its source should b taken from more than one table and having no datakey
|
|
|
|
|
Any specific questions ? If you google or bing it you will get a lot examples
Education is not a way to escape poverty — it is a way of fighting it.
|
|
|
|
|
Surely your book has examples.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Before you post you must first Google.
see below how its done.
http://www.dotnetfunda.com/articles/article71.aspx[^]
We will forgive you for now.Because you are 5 months old in CP
Vuyiswa Maseko,
Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.somee.com
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
How can i pass parameter to crystal report so it display the parameter recod and not all the record in teh table. I'm using a wizerd to make the report
|
|
|
|
|
GlobalUni wrote: How can i pass parameter to crystal report
Have a look here[^]. This would surely give you an answer.
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
I don't use google what search engenise u have other than that
|
|
|
|
|
GlobalUni wrote: I don't use google what search engenise u have other than that
MSN Search
Ask.com
GoodSearch
SearchMe
Quaero
Ask.com
Live Search
ChaCha Beta
Guruji.com Beta
wikiseek
Sproose
Wikia Search
Blackle.com
Powerset
Viewzi
Cuil
Boogami
LeapFish Beta
VADLO
Sperse! Search
Duck Duck Go
Searchme
Bing
Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
|
I was just joking about not using google. in was making fun of that guy that sugested me the google link
|
|
|
|
|
|
how to know current date and time.(i.e) date and time may vary across countries.how sql server will find the correct date and time.
|
|
|
|
|
Post your question in right database forum.It'll be easy to get the answer fast
|
|
|
|
|
There was no reply.Thats why i posted here to get answer if anybody knows who is in online.
|
|
|
|
|
getdate() is in sql
sabarimd
|
|
|
|