Viewing 3 posts - 1 through 3 (of 3 total)
Declare @TableNameParameter Nvarchar(200)='Address'
Declare @FieldNameParameterTable Table
(
FieldsName Nvarchar(200)
)
Insert into @FieldNameParameterTable(FieldsName) values ('AddressLine1'),('AddressLine2')
DECLARE @TempDatabases Table
(
id int primary key identity(1,1),
databaseId int,
DatabaseName nvarchar(100),
RowNumber int
)
Insert into @TempDatabases(databaseId,DatabaseName,RowNumber)
Select database_id,Name,ROW_NUMBER()over(order by database_id)
FROM SYS.databases
WHERE name NOT IN...
November 25, 2013 at 12:33 am
Declare @TableNameParameter Nvarchar(200)='DimGeography'
Declare @FieldNameParameterTable Table
(
FieldsName Nvarchar(200)
)
Insert into @FieldNameParameterTable(FieldsName) values ('City'),('StateProvinceCode')
DECLARE @TempDatabases Table
(
id int primary key identity(1,1),
databaseId int,
DatabaseName nvarchar(100),
RowNumber int
)
Insert into @TempDatabases(databaseId,DatabaseName,RowNumber)
Select database_id,Name,ROW_NUMBER()over(order by database_id)
FROM SYS.databases
WHERE name NOT IN...
November 25, 2013 at 12:08 am
Yes ,I'm Sorry ,Forget Collate
Declare @TableNameParameter Nvarchar(200)='UserInfo'
Declare @FieldNameParameterTable Table
(
FieldsName Nvarchar(200)
)
Insert into @FieldNameParameterTable(FieldsName) values ('UserName'),('Password')
DECLARE @TempDatabases Table
(
id int primary key identity(1,1),
databaseId int,
DatabaseName nvarchar(100),
RowNumber int
)
Insert into @TempDatabases(databaseId,DatabaseName,RowNumber)
Select database_id,Name,ROW_NUMBER()over(order by database_id)
FROM...
November 24, 2013 at 11:22 pm
Viewing 3 posts - 1 through 3 (of 3 total)