How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

How to populate a table in sql server?

0 Answers  


What is blocking and how would you troubleshoot it?

2 Answers  


What is a full text index?

0 Answers  


How many levels of sp nesting are possible?

0 Answers  


Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???

3 Answers  






What is the difference between function and stored procedure in sql server?

0 Answers  


How to find the login name linked to a given user name?

0 Answers  


what is the order of execution of where,having,group by in select stement

6 Answers   IBM, Tanla Solutions,


Where do we use trace frag?

0 Answers  


How to perform key word search in tables?

0 Answers  


Does an index slow down updates on indexed columns?

0 Answers  


i have account table which consists of account name,card no and card no consists 16 digits now i want to retrieve the data if card no starts from 4 then it should print visa and if it starts from 5 then it should print master so plse help me to write simple query with out store procs .

3 Answers  


Categories