Welcome to
Sign in
|
Help
in
Intrebari generale (forum)
Romanian Section (group)
(Entire Site)
Search
Home
Blogs
External Feeds
Forums
Photos
Downloads
About Us
»
Romanian Section
»
Intrebari
»
Intrebari generale
»
Creare tabela din procedura ??
Creare tabela din procedura ??
Last post 10-19-2009, 8:14 PM by
rsocol
. 2 replies.
Sort Posts:
Oldest to newest
Newest to oldest
Previous
Next
10-19-2009, 9:24 AM
7696
werty80
Joined on 11-06-2007
db_owner
Creare tabela din procedura ??
Reply
Quote
Se poate crea o tabela cu ajutorul unei proceduri stocate
Ex. create procedure xxx
(
@numetabela varchar(30)
)
as
set nocount on;
create table @numetabela
(
camp1 varchar(50) primary key,
camp2 varchar(50)
)
Report abuse
10-19-2009, 10:12 AM
7699
in reply to
7696
katalyn
Joined on 09-20-2006
Bucureşti
sysadmin
Re: Creare tabela din procedura ??
Reply
Quote
Da, se poate.
create procedure dbo.CreareTabela
as begin
CREATE TABLE dbo.Test (
a int
)
end
Cătălin D.
Report abuse
10-19-2009, 8:14 PM
7704
in reply to
7696
rsocol
Joined on 10-03-2006
Bucuresti
sysadmin
Re: Creare tabela din procedura ??
Reply
Quote
Da, se poate, dar nu este bine. Vezi:
Common Cases when to (Not) Use Dynamic SQL
Răzvan
Report abuse