How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
How to populate a table in sql server?
What is blocking and how would you troubleshoot it?
What is a full text index?
How many levels of sp nesting are possible?
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???
What is the difference between function and stored procedure in sql server?
How to find the login name linked to a given user name?
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?
How to perform key word search in tables?
Does an index slow down updates on indexed columns?
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 .