Hi friends, My sample data is as follows DECLARE @Sample TABLE ( fbNumINT, Customervarchar(50), paidAmountFLOAT, WeightINT ) INSERT INTO...
Hi Friends, Have a best of 2009 and fabulous year ahead.Hope you all get the better and better opportunities in 2009. Warm regards,...
Hi Friends, A Fairly simple question.As i am into more of development part of database,What is standard way of writing Stored procedures,say...
Hello friends, We have to do the input output analysis (Leontief 's models) on captured data about report flows in an organization. We have to solve...
Hi friends, I wanted some information about latest certifications,to which i can go for ? I wanted to go for database development side.As...
Hello friends, When we write joins for tables in stored procedure,Does the join eliminates rows before Where condition. Suppose a query like...
Hi, Friends, Is there any option other than GO command, for Create Procedures (functions,views etc)Script ( i.e Multiple create procedure...
Hello Friends, Is it Possible to write SELECT t.value AS @val FROM TABLE t As i have some dynamic values to come as a column heading ....
Hello Friends I have a requirement like datesearch for all cases( =,>,<,<=,>= etc), now from frontend it is passed me in date format eg...
Hello, I have a requirement ,Nested procedure. i.e I need like Insert Into #temp Exec ProcedureName @param But Insert - Exec not...
Hello Friends, I have a table that has a field with datatype TEXT,in that i m storing values like '1,2,3,4,5' and so on..those are ids of...
Hello Friends, I have a table which stores grades in varchar type,values are like 12,11,10,1S,2S,K,TK etc. Now in this i need sorting like...
Hello, We can get our user tables like this way below, but Is there any way to find out temp table exists in same way. ( in temp database )...
Hello Friends, I have a requirement,and need to store secure data like credit card nos and its expirty dates. How to avoid sql...
Is it possible to declare local variable of type 'text'.I have tried but 'data types are invalid for local variables.' Is the only way is to declare...
Hi, <br /> Is there any way to decrypt(to see the content of) the encrypted stored procedure.<br /><br /><br />[<img...
Separate names with a comma.
