Is it possible to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info. If so How?1 4211
How do I compare two values when one value(data type) is char and the other is an integer?3 5839
What are the pros and cons of creating extended stored procedures?1 3763
I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?1 4759
How to Check Whether a Global Temporary Exists in a SQL Database or not?2 5502
how to know Who Is Blocking Your SQL Server?4 8531
How to Get the last identity value used4 5161
How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?1 3469
How to Run a Query on a Remote SQL Server?2 5971
How to Generate a Series of Random Integers With T-SQL?1 2829
What is normalization?9 6481
What is a Stored Procedure?8 6195
Can you give an example of Stored Procedure?4 6751
your distribution database is full what will u do
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
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
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
what are the Prerequisites for Replication?
what exactly sql injuction.how to overcome.....
how to use DTS package in 2000,2005,2008 in sql server
What are the dis_advantages of stored procedures, triggers, indexes?
Does any body please help me what question's have asked for SSRS in the interview?
How do use Having,Group by,Group function in SQL?
what is difference between view and Dip.
New concepts of sql server 2005 use in your project.
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
Tell about MOM Tool(Microsoft Operator Manager)?