A good way to encrypt database fields? - Django
Hi folks, I've been asked to encrypt various db fields within the db. Problem is that these fields need be decrypted after being read. I'm using Django and SQL Server 2005. Any good ideas? ...
sql-server
Problem to debug stored procedure
There is a SP which gets over 96 items as parameters. I want to debug this sp, how can I do it? It says: Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0." System.Data.Common.DbException {System.Data.SqlClient.SqlException} Please tell me a way t...
variable decimal places in sql
How do you make it so that all calculations in the DB compute to a pre-specified # of decimal places? Say I have three tables with the following fields Table1 A int B decimal(18, 3) Table2 A int B decimal (18, 2) C decimal (18, 3) Table3 A int Precision int Now I need to change it so that all my calculations are based on w...
SQL Server 2000 control process priority
I'm wondering if it is possible to control the execution priority of SQL Server processes. Suppose you have a db with some large tables, with many users executing queries, and you have to create an index on one large table. The indexing process may run with low priority and cpu usage, while interactive users may have higher priority and...
How can I find all columns that are filled with 100% nulls in my SQL Server database schema?
Is there a SQL way to find out which columns in my schema are completely full of null values? There are some fields in a couple of tables that I know are not used by the application and will be dropped, but I wanted to see if there was an automated way/script to find this out across the whole database to find candidates for code review/...
What is the advantage of having multiple File groups for a database ?
I am having a relatively small database today, and I am expecting that my db size will grow drastically in coming months. What are the precautions I should take to get better performance when the db size grows larger? In this case, will splitting the primary file group of my database in to multiple secondary solves my problem? Please a...
SQL Server and threads
Does a JOIN query under SQL Server always spawn an new thread? In general how does SQL Server control thread spawning? Thanks, -peter ...
return records in sql server which has data in a particular format
Hi Guys, I have a SQL database table column which has data in this format "0000-00-0000" for ex: "1234-98-2010" For it has data in other formats as well. I need to pick out all the records where the format is "0000-00-0000" irrespective of the data. Its the format which i am after Please, can some one advise me on how i can pick th...
update sql column with same data but with a little modifications to it
I have a sql DB table columns which carries data in "0000-00-0000" format. For ex: "8753-11-2010" Now i need to change this value from "8753-11-2010" to "008753-0011-2010" i.e. i need to pad "00" in front of "8753" and "11" i mean the first two strings u can call it. please advise how i can achieve this in sql server 2005. I need to ...
no time display on grid view page
Hello, I am using SQL SERVER 2005, C# .NET. I want to diplay date only on my grid view page, currently it showing including time also. I am restoring date in table with file upload button click function. In my table i took Load date column data type is DateTime. Exaple in table column showing like 10/19/2010 12:00:00 AM On my grid vi...
Can't find microsoft.sqlserver.batchparser.dll
I wrote an asp.net web app which uses SMO against SQL Server 2008 to be able to run some DB scripts. It references these assemblies (in the C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies folder): Microsoft.SqlServer.ConnectionInfo Microsoft.SqlServer.Management.Sdk.Sfc Microsoft.SqlServer.Smo The microsoft.sqlserver.batchpar...
Aggregate bitwise-OR in a subquery
Given the following table: CREATE TABLE BitValues ( n int ) Is it possible to compute the bitwise-OR of n for all rows within a subquery? For example, if BitValues contains these 4 rows: +---+ | n | +---+ | 1 | | 2 | | 4 | | 3 | +---+ I would expect the subquery to return 7. Is there a way to do this inline, without creating a UDF...
how to find contactid in sql server ?
RCustomerId GiftRegistryId ContactId DateActive DateExpire ----------- -------------- --------- ---------- ---------- 62 66 225 NULL 2010-10-11 62 66 228 2010-10-13 NULL 62 67 229 NULL 2010-10-20 62 ...
SQL Server (2005) Query Help
My query is based on the following example I have table say 'Table1'. Table1 has one row and one column. The name of the column is 'Column1'. 'Column1' is a text column (NVARCHAR). I have a comma separated keywords like 'key1,key2..keyn'. I want to search these keywords individually in the column1. So in the where clause the query sh...
Problems with merge replication
Hi, We are developing a multi-user desktop application with users located in different countries. The platform is - .net 3.5, SQL Server 2008, WinForms. Now, my client has used the help of a DBA who has implemented merge replication. To facilitate replication, we made all our primary keys as GUID. Now, we are facing these issues with re...
Can a view return multiple result sets?
I would like to have a view that I could run return multiple result sets. Is this possible? If a view can not do this, then is there another object with High Visibility/Transparency within SQL Server that can achieve this? (I like using a view because I can easily see it and run it under the Views folder). A stored procedure is not rea...
Can I call a Web Service from SQL Server 2005?
I want to call a web service from my SQL code, but it cannot be using CLR code. Can this even be done? ...
passing parameter from access into sql-server
REPHRASING QUESTION: i apologize for being unclear. i have a textbox and a button a form. when the button is clicked it runs this saved access query: select * from sqlservertable where field=form!textbox.value i have an access front end and sql server back end. this query is not working. it doesnt like me passing this parameter form...
Generating select statement with joins from table information.
Hello, I've got a bunch of classes that describe database schema: Table,Field,ForeignKey. Tables have ForeignKeys list and Fields list. Now I would like to generate SELECT statement with all the joins that are described in ForeignKey instances. The question is: is order of tables relevant for the query time? Another words - do I have ...
C# LINQ: How to stack LINQ queries correctly
I have a form that allows the user to perform a myriad of searches. The table(s) that need to be joined differ depending on the search criteria entered. (My example below is very simplistic because both tables use the same sub-tables to join on, but the actual problem is not as simple.) I've been using a technique I call LINQ stacking...