| Author |
 Topic  |
|
coolerbob
Aged Yak Warrior
United Kingdom
841 Posts |
 Posted - 06/21/2007 : 09:38:35
|
| Maybe add a few bits on recursion? |
 |
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 06/21/2007 : 11:15:37
|
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 |
|
|
|
coolerbob
Aged Yak Warrior
United Kingdom
841 Posts |
|
|
Arijit
Starting Member
25 Posts |
Posted - 07/05/2007 : 01:34:13
|
| Really good one. |
|
|
|
revanth
Starting Member
2 Posts |
Posted - 09/13/2007 : 03:22:45
|
Thankq very much dear.
revanth babu |
|
|
|
ronedin
Starting Member
29 Posts |
Posted - 10/18/2007 : 06:39:20
|
| thanks a lot kristen.. |
|
|
|
modi_sanjay
Starting Member
USA
9 Posts |
Posted - 03/18/2008 : 11:40:18
|
| Thanks |
|
|
|
jann
Starting Member
USA
1 Posts |
Posted - 04/03/2008 : 01:37:24
|
graet job out there..
keep it up
god bless=)
_______________________
jann
<a href="http://SelectWealthSystem.com">http://SelectWealthSystem.com</a>
lili mendoza |
|
|
|
ann06
Posting Yak Master
Lebanon
170 Posts |
Posted - 04/13/2008 : 01:57:20
|
| Nice job man god bless u |
|
|
|
naum2
Starting Member
United Kingdom
1 Posts |
Posted - 05/27/2008 : 11:01:47
|
| hi this is really good stuff |
|
|
|
suman.reddy39
Starting Member
India
34 Posts |
Posted - 06/03/2008 : 05:12:52
|
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 |
|
|
|
Faisal Nasir
Starting Member
Pakistan
4 Posts |
Posted - 06/03/2008 : 05:19:44
|
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
|
|
|
|
Faisal Nasir
Starting Member
Pakistan
4 Posts |
Posted - 06/03/2008 : 05:22:19
|
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
|
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 06/03/2008 : 05:53:08
|
Yes, of course you can.
E 12°55'05.25"
N 56°04'39.16" |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
|
|
duttavr
Starting Member
2 Posts |
|
|
duttavr
Starting Member
2 Posts |
|
|
rao
Starting Member
India
2 Posts |
Posted - 07/31/2009 : 05:15:59
|
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 |
|
|
|
robvolk
Most Valuable Yak
USA
15557 Posts |
Posted - 07/31/2009 : 07:08:52
|
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. |
|
|
|
Topic |
|
SQL Server Frequently Asked Questions FAQ
Topic Locked
