armm1388 (5/15/2013)

---

Hi

I have sql server DB and C# Application.

How can I restricted count of user who use from my DB?

How can I do this by c# or by SQL SERVER...

Jeff Moden (5/14/2013)

---

sqlfriends (5/14/2013)

---

I would like to convert a varchar column to datetime.

The varchar column are supposed are be like a date : 2013-05-12

But there may be a wrong date...

That will help to start getting relevant help:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

The only way for SQL Server to start counting from 2 after inserting 1000 into identity is to reseed it. But, it's a stupid thing to do anyway.

However, if...

than use the first link from my previous post.

You can use ADO.NET transaction to do so,...

sqlfriends (5/14/2013)

---

Lynn Pettis (5/14/2013)

---

I'd probably have the application do the update, but that's just me. The app could be coded such that the update needs to occur in both...

salliven (5/14/2013)

---

Hi!

Can I insert a table without identity reseed?

Exapmle:

CREATE TABLE #table (id int IDENTITY (1,1), col1 int)

INSERT INTO #table DEFAULT VALUES

-- Id = 1

-- If I insert identity values, then...

ninobuttez (5/14/2013)

---

Hi,

I need again your help. Something very easy for you I guess:

I need to add a value in the column of a table when the value is null.

So let's...

Hi and welcome to the forum.

As you here first time, I would advice you to have a look an article from the link at the bottom of my signature....

Yeah, my wrong. Clicked the wrong link and didn't bother to check...

Thank You...

Lynn Pettis (5/14/2013)

---

Eugene Elutin (5/14/2013)

---

William Gary Wright (5/14/2013)

---

I left the office last night being half way done writing a script to create a database with some data in it for...

Abhijit More (5/14/2013)

---

How do you want us to help? - need help to optimize the query.

Can you drop this proc and never use? - not possible

If not, what...

William Gary Wright (5/14/2013)

---

I left the office last night being half way done writing a script to create a database with some data in it for you all to look...

Abhijit More (5/14/2013)

---

Hello!

I have one stored proc which returns data by querying multiple tables using union clause without any search criteria.

select xyz as Col1 from table1 join table2 ...(total 8...

that classical question was answered long ago ;-):

http://sqlinthewild.co.za/index.php/2009/03/19/catch-all-queries/