You can set a default database in user login level .Run below system proc to set your default database .

Exec sp_defaultdb @loginame='ur Login', @defdb='sims'

This sets by default database as sims...

Can you please re-frame your question..

if you are connecting by using connection string via application,you will not be having issues . Or if you are talking about in query...

Jeff Moden (1/4/2014)

---

That would be better performance...

Jeff Moden (1/4/2014)

---

sql crazy kid (1/4/2014)

---

Hello,

First i would thank to Michael ,i never known in date function by default 0 treat as beginning of the date[1900-01-01] which drives here to...

Hello,

First i would thank to Michael ,i never known in date function by default 0 treat as beginning of the date[1900-01-01] which drives here to get the corresponding start and...

Jeff Moden (1/2/2014)

---

I can see doing it only if you need to change the keys...

Jeff Moden (1/1/2014)

---

sql crazy kid (12/31/2013)

---

If i drop a clustered index from table, how the non clustered behave when this is on same table.

Will all the non clustered index drop...

Jeff Moden (12/29/2013)

---

As well as the marvelous articles that Gail posted, Books Online has some great information in it (if you don't know what Books Online is, post back... you...

Kindly give some more ideas about Internal architecture of Non Leaf nodes.

As per my understanding this having page header,index rows which helps to find next Non Leaf node/Leaf...

CDC configured on SQL database and tables. So you will be able to get the list of tables which is part of CDC.

Table cdc.change_tables returns list of all the tables...

Structured Query Language has it's own coding standards, your question is beyond that.You should follow that,it would help you to solve your problem.

I suggest start with mssql library.

You should define your input parameter as "@Poll_I int out".

Also the called application should have variable to set your output as like below

declare @Poll int

InsertNewPoll @varquestion ='TestQst',@Poll OUT

More...

Clustered index always seen sorted table in physical order, As per the previous this is not necessarily stored in physical order,Is there any specific case clustered index not sorted...

Really helpful... Thanks

Hello dear,

please tryout this . I assume from your query string is not limited to 2 commas .

Declare @strsql varchar(50),@chrindex int

set @strsql = 'AA,BB,C,D'

select @strsql --print original val

select @chrindex=CHARINDEX(',',@strsql,1)

select...