All Questions
4 questions
0
votes
1
answer
94
views
How do I protected my sensitive data (financial) from website/CRM programmers?
As a company owner, I need to protect my sensitive data from my website/CRM programmers. I know I can scramble DB values with a simple script but it needs to be applied manually all the time and when ...
- 123
1
vote
1
answer
55
views
Changing Key (PK, FK) properties in DROP/Add column statements
I want to change a table by adding a column. So far nothing to see here, BUT I would like to make this column part of a composite key, i.e., I now have a layout
table_name( Field_1 datatype PK, ...
- 47
3
votes
1
answer
3k
views
Apparantly errorneous Exceeds 8K row length message
In attempting to alter an SQL Server table adding DATE and FLOAT columns. I get a message:
Warning: The table "CustomerTransactions" has been created, but its maximum row size exceeds the allowed ...
- 133
7
votes
6
answers
68k
views
How To change the column order?
How To change the column order in sql server 2008 R2?
Eg: My table order is Eid------Ename-----Esalary
Know i want this format like Eid---Salary----Ename
Thanks.
user36326