SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL Server Frequently Asked Questions FAQ
 New Topic  Topic Locked
 Printer Friendly
Previous Page | Next Page
Author Previous Topic Topic Next Topic
Page: of 5

coolerbob
Aged Yak Warrior

United Kingdom
841 Posts

Posted - 06/21/2007 :  09:38:35  Show Profile
Maybe add a few bits on recursion?
Go to Top of Page

Kristen
Test

United Kingdom
22415 Posts

Posted - 06/21/2007 :  11:15:37  Show Profile
I have to say I don't see that come up often, but if you point me to worthy threads on any subject I'll consider them

Kristen
Go to Top of Page

coolerbob
Aged Yak Warrior

United Kingdom
841 Posts

Posted - 06/21/2007 :  11:41:00  Show Profile
It's a bit of a wide subject with many different implementations - depending on the need. But one I thought might be worth a mention:

http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=2828
Go to Top of Page

Arijit
Starting Member

25 Posts

Posted - 07/05/2007 :  01:34:13  Show Profile
Really good one.
Go to Top of Page

revanth
Starting Member

2 Posts

Posted - 09/13/2007 :  03:22:45  Show Profile
Thankq very much dear.

revanth babu
Go to Top of Page

ronedin
Starting Member

29 Posts

Posted - 10/18/2007 :  06:39:20  Show Profile
thanks a lot kristen..
Go to Top of Page

modi_sanjay
Starting Member

USA
9 Posts

Posted - 03/18/2008 :  11:40:18  Show Profile
Thanks
Go to Top of Page

jann
Starting Member

USA
1 Posts

Posted - 04/03/2008 :  01:37:24  Show Profile
graet job out there..
keep it up
god bless=)


_______________________
jann
<a href="http://SelectWealthSystem.com">http://SelectWealthSystem.com</a>

lili mendoza
Go to Top of Page

ann06
Posting Yak Master

Lebanon
171 Posts

Posted - 04/13/2008 :  01:57:20  Show Profile  Click to see ann06's MSN Messenger address
Nice job man god bless u
Go to Top of Page

naum2
Starting Member

United Kingdom
1 Posts

Posted - 05/27/2008 :  11:01:47  Show Profile  Visit naum2's Homepage
hi this is really good stuff
Go to Top of Page

suman.reddy39
Starting Member

India
34 Posts

Posted - 06/03/2008 :  05:12:52  Show Profile
hi every buddy
actually im new to sql server,
when im trying to create new database im getting this error can you help me

an exception occurred while executing a transact-SQL statement or batch.(microsoft.sqlserver.express.connectioninfo)
could not obtain exclusive lock on database'model'.retry the operation later.CREATED DATABASE Failed.some files names listed colud not be created.check related errors.(microsoft sql server,error:1807)

thanks in advance.

SumanReddy.k
Go to Top of Page

Faisal Nasir
Starting Member

Pakistan
4 Posts

Posted - 06/03/2008 :  05:19:44  Show Profile
Can We use two insert statements in one stored procedures with respect to two different tables
Example;
REATE PROCEDURE INSERTS

@ItemName as varchar(50)
@WName as varchar(50)

AS

insert into Items ( ItemName ) values(@ItemName)
insert into WareHouse (WareName ) values (@WName )
GO
Go to Top of Page

Faisal Nasir
Starting Member

Pakistan
4 Posts

Posted - 06/03/2008 :  05:22:19  Show Profile
Can We use two insert statements in one stored procedures with respect to two different tables
Example;
REATE PROCEDURE INSERTS

@ItemName as varchar(50)
@WName as varchar(50)

AS

insert into Items ( ItemName ) values(@ItemName)
insert into WareHouse (WareName ) values (@WName )
GO
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30277 Posts

Posted - 06/03/2008 :  05:53:08  Show Profile  Visit SwePeso's Homepage
Yes, of course you can.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30277 Posts

Posted - 08/20/2008 :  08:47:10  Show Profile  Visit SwePeso's Homepage
Good to know url
http://www.databaseanswers.org/data_models/index.htm



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

darkdusky
Aged Yak Warrior

591 Posts

Posted - 10/31/2008 :  10:12:57  Show Profile
Reporting Services Scripter:
This is an excellent tool to backup and migrate reporting services reports / datasources / subscriptions/ models ..... etc.
http://www.sqldbatips.com/showarticle.asp?ID=62
Go to Top of Page

duttavr
Starting Member

2 Posts

Posted - 11/06/2008 :  23:42:07  Show Profile
SQL Server 2008 New Features at Microsoft .NET Support
http://msdotnetsupport.blogspot.com/2008/11/sql-server-2008-new-features.html
Go to Top of Page

duttavr
Starting Member

2 Posts

Posted - 11/06/2008 :  23:44:35  Show Profile
50 New Features of SQL Server 2008 at Microsoft .NET Support
http://msdotnetsupport.blogspot.com/2008/11/sql-server-2008-new-features.html
Go to Top of Page

rao
Starting Member

India
2 Posts

Posted - 07/31/2009 :  05:15:59  Show Profile
i wanna list all columns of a table with a distinct things in a particular column,

If not understood my qsn, plz follow here:

One distinct column(no redundant)and all the remaining columns.

Plz help me
Go to Top of Page

robvolk
Most Valuable Yak

USA
15678 Posts

Posted - 07/31/2009 :  07:08:52  Show Profile  Visit robvolk's Homepage
quote:
Originally posted by rao

i wanna list all columns of a table with a distinct things in a particular column,

If not understood my qsn, plz follow here:

One distinct column(no redundant)and all the remaining columns.

Plz help me

Please create a new topic for your request.
Go to Top of Page
Page: of 5 Previous Topic Topic Next Topic  
Previous Page | Next Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000