What is the safest way to store credit card information in a sql 2000 database table?
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_22410788.html
The trigger listed below is inserting two rows into the audit table requests_audit. I was under the impression this syntax would insert the specified values for _either_ and insert or and update a...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2326...
I need to use a SQL script (an embedded resource in a ClickOnce deployed .NET 2.0 application) to create a database. The problem I am having is that I need to use the 'FILENAME' option in the scri...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2329...
Hi.
I have a "join" statement that is not working as I believe it should. I want it to return rows where both fields in each table are NULL. Here is the sample code:
select * from [Dispatch...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23630640.html
I have table has 3 fields
id productname uniquecode price
1 Toys AB34 100
2 Gun RT52 150
3 ...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23721777.html
Hi. I'm using T-SQL on MS SQL SERVER 2005.
I have a char(1) field in "MyTable" called "Type" . That field could have "A", "U", or "D" in it.
I want to pass a parameter to a procedure to see...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23745688.html
I'm new to the MSSQL environment (I stem from a unix world). What I need to do is write this big query to pull records for reporting purposes. A few of the columns have clauses on them... For examp...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23752139.html
Hello, I am attempting to create a stored procedure which is not working correctly. What I need it to do is to check if @UserCode is in a table and then check if either one of @RequestDomain, @Req...
http://www.experts-exchange.com/Programming/Languages/SQL_Syntax/Q_23766624.html
I am not sure what Stored Procedures are in SQL other than stored SQL statement which can be called.. I am trying to find out what can be done with them....
Can you for example, use it to autom...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q-2388...
I am using mysql for some years.
recently I try to write some php scripts with mssql;
I found that mssql isn't support 'LIMIT' parse.
For eg,I want to select 20 records begin of the 1000'th reco...
http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_20910603.html
