Hello everyone, How do I group a set of tables or label them together? In our project,each user has two separate tables allocated for them. I need to group all users tables separately. How do I accomplish this? Thanks. ...
I want to create a rotating logic in sql like consider there are 3 numbers 1,2,3 then first week 1,2 will be selected next 3,1 next 2,3 and so on..... if there are 4 numbers 1,2,3,4 then 1,2 next 3,4 next 1,2 so on... Like that i want to generate the numbers in sql server.Please help me. ...
Hi, how I can do this: a=a+1 in sql server query? Thanks! ...
How do I get the number of rows affected by a BULK INSERT on SQL Server (2008 if that matters)? ...
Hi all, I want to check if there are any records in a table for a certain entry. I used COUNT(*) to check the number of records and got it to work. However, when the number of records for an entry is very high, my page loads slowly. I guess COUNT(*) is causing the problem, but how do I check if the records exist without using it? I onl...
Hi, how can I retrieve a string (like 'select 1') from a record and pass it to sp_executesql to make it eval it? Thanks ...
Jeff recently asked this question and got some great answers. Jeff's problem revolved around finding the users that have had (n) consecutive days where they have logged into a system. Using a database table structure as follows: Id UserId CreationDate ------ ------ ------------ 750997 12 2009-07-07 18:42:20.723 750998...
Our MS Access application with linked tables to SQL Server 2005 is slow when using Windows Authentication from Windows XP clients. We've been running it successfully using SQL Server authentication, but now we want to move to Windows Authentication for better security control. Setup: Database server: Windows 2003 Server, SQL Server...
I'm looking for an efficient SQL Server function (in my case 2005) to convert a unix time value into a SQL Server datetime, using local time (particularly taking account of summertime adjustments - i.e not just adding 01/01/1970 in seconds) ...
Which method provides the best performance when removing the time portion from a datetime field in SQL Server? a) select DATEADD(dd, DATEDIFF(dd, 0, getdate()), 0) or b) select cast(convert(char(11), getdate(), 113) as datetime) The second method does send a few more bytes either way but that might not be as important as the speed ...
i want to ensure that all stored procedures are still syntatically valid. (This can happen if someone renames/deletes a table/column). Right now my solution to check the syntax of all stored procedures is to go into Enterprise Manager, select the first stored procedure in the list, and use the procedure: Enter Alt+C Escape Escape Down...
I need to build an SQL statement to delete from certain table the records that match another select statement. In Teradata we use delete from table1 where (col1, col2) in ( select col1,col2 from table2 ) While in SQL Server it's not allowed to have more than 1 column in the WHERE..IN clause. I thought I can use the WITH clause...
Hi guys, simple problem, but perhaps no simple solution, at least I can't think of one of the top of my head but then I'm not the best at finding the best solutions. I have a stored proc, this stored proc does (in a basic form) a select on a table, envision this: SELECT * FROM myTable okay, simple enough, except the table name it ne...
given this table definition create table herb.app (appId int identity primary key , application varchar(15) unique , customerName varchar(35),LoanProtectionInsurance bit , State varchar(3),Address varchar(50),LoanAmt money ,addedBy varchar(7) not null,AddedDt smalldatetime default getdate()) I believe changes will be minimal, usu...
In SQL Server 2005 (not 7.0), is there any reason to use NVARCHAR(255) instead of 256 or some other number? Is there any optimal size, and is there any reason to use powers of two? (I will be storing Unicode data, so I have to use NVARCHAR) ...
I am trying to use the MS SQL Server 2005 Import/Export tool to export a table so I can import it into another database for archival. One of the columns is text so if I export as comma-delimited, when I try to import it into the archive table, it doesn't work correctly for rows with commas in that field. What options should I choose to e...
Let's have: $DB an SQL Server database $DBSP1 an SQL Server database containing stored procedures referencing $DB $DBSP2 is exactly like $DBSP1 $SP is a stored procedure Running $SP on $DBSP1 from C# code takes around 1.5s. Running $SP on $DBSP2 from C# code takes around 0.5s. The C# code is very simple and use SqlClient with defau...
Hi all, I've been connecting to an oracle 10g server using ms sql servers linked server feature and for some reason i am unable to use the with clause. Does this clause only work in in the pl/sql console or is there something i can do to make it work with linked servers as well? The error i am getting is Msg 7357, Level 16, State 2, ...
I'm trying to add a Foreign Key to a table, but database, Sql Server 2005, does not like it. It says that columns do not match an existing primary key or unique constraint. How can I find the columns in question so I can delete/change them and add the foreign key? ...
Hi , I need to store XML data to database(MS SQL Server). The data type defined in the column is text. I need to know the the equalent datatype for text. I have tried with adLongVarChar but it does not works. Also I tried with adLongVarWChar(nText). But both are not working. Need help. Thanks. ...