How to provide values to stored procedure parameters in ms sql server?
No Answer is Posted For this Question
Be the First to Post Answer
4 Please write a querry to find repeated numbers in the following table. Table Name: Table1 Field1 10 15 20 15 10
Tell me what is sql profiler?
Define Check points and End Points?
Tell me what is difference between clustered and non clustered index?
How do I change my passwords (database, LDAP, and so on) without causing an outage?
What is analysis service repository?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
explain how to create a new schema in a database? : Sql server database administration
What is Deadlock?
system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:28.513 if i write "select dateadd(dd,2,getdate()) ".it returns "2009-01-26 19:59:38.340"...my question is dat could it be possible to retrive da date in da format "26 jan 2009 ...."??
How can your resolve deadlocks?
4 Answers IBM, IMS, Iron Mountain, NuWare,
Can you use order by when defining a view?