sam (10/22/2008)

---

I have a general database design question.

Our company has multiple hosted web applications. Each of those applications currently use a single sign solution that reads from...

i think the query would be

select * from not_equal where (name <> 'name1' and age >= 25)

nairsanthu1977 (10/22/2008)

---

Dear All,

I have downloaded MDF of my database from live server to local server.

Now I want to create a database in loocal server pointing to this MDF file.

How can...

Well i use this query. this returns the tablename.columnaname and the value in which the value it finds:

i...

give me some time please

Arul Manoj (10/22/2008)

---

Hi,

I have the below table structure:

RowNumber UserId UserNmae Date

1 ...

Use this

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/07/07/procedure-cache-tuning-sizing-from-1gbyte-to-768kbytes-increase-the-size-of-usable-data-cache.aspx

dastagirid (10/22/2008)

---

hello,

In my query are:

1) select * from orders where ordered BETWEEN 100000...

i dont think that...

shiwani2002sg (10/22/2008)

---

can anyone suggest some querry with which i can find how many tables were affected( with insert or update) with last querry.

say if i run some procedure

insert_into_tables...

oh im sorry for that

but in sql server 2000

there is varchar(8000)

what do you want to do

krayknot (10/21/2008)

---

Arul Manoj (10/21/2008)

---

I have table to store user login details. Now i want to get the time difference for each login for all users. The table is as below

User...

Arul Manoj (10/22/2008)

---

Thanks for your reply.

But i need the following result:

For each user i have to compare the stop time of 1st row with start time of 2nd row...

Pravin Patel (10/22/2008)

---

DECLARE @v1 AS NVARCHAR(30)

SET @v1 = '1,2,3'

PRINT ('select * from user_login_dtl where CAST(login_type_id AS NVARCHAR(10)) in (' + @v1 +')')

SELECT * FROM user_login_dtl WHERE CAST(login_type_id AS NVARCHAR(10)) in...