Answer / guest

Windows mode and mixed mode (SQL & Windows).

Answer / guest

there are two authentics in sql server.
1- windows authentics
2- sql authentic

Answer / rajkumar v

1.Windows authentication
2.Mixed authentication(SQL Server and Windows
authentication mode)

Answer / dupinder singh

SQL Server 2008 offers two authentication mode options:

Windows authentication mode requires users to provide a
valid Windows username and password to access the database
server. In enterprise environments, these credentials are
normally Active Directory domain credentials.

Mixed authentication mode allows the use of Windows
credentials but supplements them with local SQL Server user
accounts that the administrator may create and maintain
within SQL Server.

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

0 Answers  

---

Do you know nested transaction?

0 Answers  

---

What is a select query statement in ms sql server?

0 Answers  

---

What is microsoft sql server?

0 Answers  

---

What are the restrictions while creating batches in sql server?

0 Answers  

---

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h

1 Answers  

---

What command would you use to add a column to a table in sql server?

0 Answers  

---

How to transfer a table from one schema to another?

0 Answers   MCN Solutions,

---

hi to all teachers,... Friends who write in the query mode Full text Search in Sql Server have experience Who make(Convert) this Stored Procedure as a normal Full text Search, which contains and .. Is used, into Advance of the tips I have thanked all friends perfection. Email : rezaafandi@yahoo.com Create PROCEDURE Sp_student @fname varchar(50), @lname varchar(50), @tel varchar(50), @code varchar(50), @adr varchar(50), @search_operation varchar(50), @totalRowCount bigint output AS begin if @search_operation = 'and' begin SELECT f3,f4,f5,f6,f7 FROM tb_student WHERE( f5 like '%' + @fname + '%' and f4 like '%' + @lname + '%' and f6 like '%' + @tel + '%' and f7 like '%' + @code + '%' and f3 like '%' + @adr +'%' ) select @totalRowCount = @@rowcount end

0 Answers  

---

How to get all stored procedures in sql server?

0 Answers  

---

What is the difference between substr and charindex in the sql server?

0 Answers  

---

Explain datetime2 data type in sal server 2008?

0 Answers  

---