| ||||||||||||||||||||||||||||||||||||||||
|
You reset your password.
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
You reset your password.
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Info about changing your password
| ||||||||||||||||||||||||||||||||||||||||||||
|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
This will create an identity column in the following table.
CREATE TABLE dbo.MyTable ( ID INT IDENTITY(1,1) ,MyShortDesc varchar(20) ,MyLongDesc varchar(500) );
Here's a query which displays the .mdf and .ldf location of all the databases in the server.
SELECT physical_name
FROM master.sys.master_files
select
GROUP_ID
, GROUP_COUNTER= ROW_NUMBER()
OVER ( PARTITION BY [GROUP_ID]
ORDER BY [GROUP_ID]
)
from GROUP_TABLE
There are some good video tutorials available here.Check it out.
Hi All, we are back after a pause.Here's an interesting article which talks about the different ways of selecting the duplicate rows from a table.Hope it will be useful to you.
Article
Can you instantiate a COM object by using T-SQL?
1. True
2. False
- The dynamic SQL Performs slower because the optimizer has to create an execution plan for every execution.
What are the disadvantages of cursors?
1. Cursor results in a network roundtrip
2. Cursor requires more resources and temporary storage
3. Cursor results in more IO operations
4. 1 & 2
5. 1, 2 & 3
6. None
Today's tips are not really related to T-SQL,but I hope these will improve the way you approach SQL SERVER.
Today's best practice techniques are
Hi All!...we decided to write some posts on the best practices in writing T-SQL,which we think helpful to the newbies.We will list three best practices each day for the next seven days and hope this series will be helpful to all the readers.So today's best practices tips are,