Answer / chandra deo mahto

START File_name or @<File_Name>

Answer / pankaj dwivedi

xp_cmdShell 'bat file'

what is the information that can be stored inside a bit column? : Sql server database administration

0 Answers  

---

where do you use Isolations?give me some exmpale?

1 Answers  

---

Explain having clause?

0 Answers  

---

what command is used to create a table by copying the structure of another table?

7 Answers  

---

What is the difference between clustered and non-clustered indexes in ms sql server?

0 Answers  

---

Does a server store data?

0 Answers  

---

How do you delete a data source?

0 Answers  

---

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  

---

I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

0 Answers   HCL, Wipro,

---

What is Schema in Database?

1 Answers   Cap Gemini,

---

What is attribute hierarchy? : sql server analysis services, ssas

0 Answers  

---

How to encrypt data between dialogs?

0 Answers  

---