How can windows applications connect to sql servers via odbc?

678

What is the beast way to write CTE in SQL Server ?

658

how many bits ip address consist of? : Sql server database administration

544

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

1871

Mention the differences between local and global temporary tables.

651

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

741

How the authentication mode can be changed?

735

What is command parameter in ssrs?

130

How to add more data to the testing table in ms sql server?

643

What is the difference between a view and a stored procedure?

653

How can we delete Duplicate row in table?

714

Mention what are the core components of ssrs?

232

What is the difference between set and select?

659

What is the default fill factor value?

668

How to provide login information for a new odbc dsn?

615