Database

USE {enter your desired database name here};

DECLARE     @NameOfTable     VarChar(128);
SET     @NameOfTable = '{enter your desired table name here}';

DECLARE @SQLStatement VarChar(8000);

SET @SQLStatement =  'SELECT ''' + @NameOfTable + ''' AS TableName';

PRINT @SQLStatement;

EXEC(@SQLStatement);

WITH TableColumns_CTE
AS
(
    SELECT   T.name     AS  TableName
            ,C.name     AS  ColumnName
            ,ROW_NUMBER() OVER (PARTITION BY T.name ORDER BY T.name, C.name) Seq
    FROM    sys.tables T
    INNER JOIN sys.columns C
       ON   T.object_id = C.object_id
      AND   T.name = @NameOfTable
)

SELECT   @SQLStatement = @SQLStatement + ', ' + ColumnName
FROM    TableColumns_CTE;

SELECT   @SQLStatement = @SQLStatement + ' FROM ' + @NameOfTable + ';';

PRINT @SQLStatement;

EXEC(@SQLStatement);

zead wrote:

Is it possible to secure sql database using user name password, not the mixed mode user name password, (user name password ) on database it self to prevent it when restore on other sql engine(instance).

zead wrote:

the second questions is how to hide columns on sql server database engines, when open the database can't see the tables and columns until i enter the database user name password

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]

CREATE TABLE [cpqaAnswers].[cpqa].[cpqa_OT_tblRegister](
	[id][int],
		[school][nvarchar](15),
			[name][nvarchar](38),
				[Subject][nvarchar](45),
					[results][int],
						[studentID][int]
						)

BULK INSERT [cpqaAnswers].[cpqa].[cpqa_OT_tblRegister]
	FROM 'C:\Users\OT\registerOT(td)_.txt'

SELECT * FROM [cpqaAnswers].[cpqa].[cpqa_OT_tblRegister]
	WHERE [results] = 72
		ORDER BY [id]
			FOR XML PATH('Schools'), ELEMENTS, ROOT('Register')

<Register>
  <Schools>
    <id>5</id>
    <school>Cambridge</school>
    <name>john</name>
    <Subject>English</Subject>
    <results>72</results>
    <studentID>2</studentID>
  </Schools>
</Register>

<Register>
<Schools>
  <School>
    <Name>Oxford</Name>
    <Students>
       <Student>
          <Name>tom</Name>
          <Subjects>
             <Subject>
                <Name>Maths</Name>
                <grde>98</grde>
             </Subject>
             <Subject>
              <Name>English</Name>
              <grde>87</grde>
             </Subject>
            <Subject>
              <Name>Chemistry</Name>
              <grde>63</grde>
            </Subject>
         </Subjects>
      </Student>
   </Students>
 </School>
 <School>
    <Name>Cambridge</Name>
    <Students>
       <Student>
          <Name>john</Name>
          <Subjects>
             <Subject>
                <Name>Maths</Name>
                <grde>50</grde>
             </Subject>
             <Subject>
              <Name>English</Name>
              <grde>72</grde>
             </Subject>
            <Subject>
              <Name>Chemistry</Name>
              <grde>32</grde>
            </Subject>
         </Subjects>
      </Student>
   </Students>
 </School>
</Schools>
</Register>

character_set_client	utf8
character_set_connection	utf8
character_set_database	utf8
character_set_filesystem	binary
character_set_results	utf8
character_set_server	utf8
character_set_system	utf8
character_sets_dir	C:\Program Files (x86)\Parallels\Plesk\Databases\MySQL51\share\charsets\
collation_connection	utf8_general_ci
collation_database	utf8_unicode_ci
collation_server	utf8_unicode_ci
completion_type	0
concurrent_insert	1
connect_timeout	10

<add name="SQLdb" connectionString="Server=xx.xx.xx.xx;uid=admin;pwd=xxxxxxx;database=xxxxx;Charset=utf8;" providerName="MySql.Data.MySqlClient"/>

Member 7702110 wrote:

Because different ecommerce sites are using this kind of database and working fine with huge different types of products.

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]