doanket
asked on
Create the table SQL server = VB 6.0
I have 1 sort code. It is Procedure creat the IDTEMP Table
DECLARE @Col1 int,
@sql nvarchar(1000)
DECLARE curA CURSOR FOR
SELECT Distinct BangHeSo.TenTruong FROM BangDinhNghia INNER JOIN BangHeSo ON BangDinhNghia.KS_Tuyen_Via _LK_id = BangHeSo.KS_Tuyen_Via_LK_i d INNER JOIN Tuyen_LoKhoan ON BangDinhNghia.Tuyen_Lokhoa n_id = Tuyen_LoKhoan.tuyen_lokhoa n_id INNER JOIN LoKhoan ON Tuyen_LoKhoan.lokhoan_id = LoKhoan.lokhoan_id INNER JOIN Tuyen ON Tuyen_LoKhoan.tuyen_id = Tuyen.tuyen_id INNER JOIN VungKhoangSan ON BangDinhNghia.VungKhoangSa n_id = VungKhoangSan.vungkhoangsa n_id WHERE (VungKhoangSan.tenvungkhoa ngsan ='" & cmbKS & "') AND (BangDinhNghia.TenVia ='" & cmdvia & "') AND (BangHeSo.TenPhuongAn ='" & cmbPA & "')
OPEN curA
FETCH NEXT FROM curA INTO @Col1
WHILE @@FETCH_STATUS=0
BEGIN
if exists (select * from dbo.sysobjects where id = object_id(N'[IDTEMP]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
SELECT @sql = 'ALTER TABLE IDTEMP ADD [' + convert(varchar,@Col1) + '] varchar'
exec sp_executesql @sql
END
ELSE
BEGIN
SELECT @sql = 'CREATE TABLE IDTEMP([' + convert(varchar,@Col1)+ '] varchar)'
exec sp_executesql @sql
END
FETCH NEXT FROM curA INTO @Col1
END
CLOSE curA
DEALLOCATE curA
- I write This code in VB 6.0 then code apper red colors
Help me,Where I must write this code
Thank you.
DECLARE @Col1 int,
@sql nvarchar(1000)
DECLARE curA CURSOR FOR
SELECT Distinct BangHeSo.TenTruong FROM BangDinhNghia INNER JOIN BangHeSo ON BangDinhNghia.KS_Tuyen_Via
OPEN curA
FETCH NEXT FROM curA INTO @Col1
WHILE @@FETCH_STATUS=0
BEGIN
if exists (select * from dbo.sysobjects where id = object_id(N'[IDTEMP]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
SELECT @sql = 'ALTER TABLE IDTEMP ADD [' + convert(varchar,@Col1) + '] varchar'
exec sp_executesql @sql
END
ELSE
BEGIN
SELECT @sql = 'CREATE TABLE IDTEMP([' + convert(varchar,@Col1)+ '] varchar)'
exec sp_executesql @sql
END
FETCH NEXT FROM curA INTO @Col1
END
CLOSE curA
DEALLOCATE curA
- I write This code in VB 6.0 then code apper red colors
Help me,Where I must write this code
Thank you.
Not sure what your asking, but you appear to be saying your trying to write this code in VB6? It is Transact SQL and need to be written in Microsoft SQL Server as a new Stored Procedure.
ASKER
Yes.
But Command
SELECT Distinct BangHeSo.TenTruong FROM BangDinhNghia INNER JOIN BangHeSo ON BangDinhNghia.KS_Tuyen_Via _LK_id = BangHeSo.KS_Tuyen_Via_LK_i d INNER JOIN Tuyen_LoKhoan ON BangDinhNghia.Tuyen_Lokhoa n_id = Tuyen_LoKhoan.tuyen_lokhoa n_id INNER JOIN LoKhoan ON Tuyen_LoKhoan.lokhoan_id = LoKhoan.lokhoan_id INNER JOIN Tuyen ON Tuyen_LoKhoan.tuyen_id = Tuyen.tuyen_id INNER JOIN VungKhoangSan ON BangDinhNghia.VungKhoangSa n_id = VungKhoangSan.vungkhoangsa n_id WHERE (VungKhoangSan.tenvungkhoa ngsan ='" & cmbKS & "') AND (BangDinhNghia.TenVia ='" & cmdvia & "') AND (BangHeSo.TenPhuongAn ='" & cmbPA & "')
in VB 6.0
Can I write Transact SQL in Vb?
Thank you
But Command
SELECT Distinct BangHeSo.TenTruong FROM BangDinhNghia INNER JOIN BangHeSo ON BangDinhNghia.KS_Tuyen_Via
in VB 6.0
Can I write Transact SQL in Vb?
Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.