Formatting is the function of presentation layer. SQL Server is not the right place to do this kind of formatting. Harsh Athalye India. "Nothing is...
What kind of data you want to store? Integer or fractional ? In SQL Server, the size of numeric (integer data) data is not decided based on number...
Which method do you use to import from Excel? Harsh Athalye India. "Nothing is Impossible"
Check out this article link: http://vyaskn.tripod.com/analyzing_profiler_output.htm This one is also good:...
Although syntactically there is no error, the result will be unpredictable for first statement where TB1 is not referenced. Second one is correct way...
Provide more information...How can anybody possibly help you with so little information ! "Nothing is Impossible"
There is no in built function to do this...although with some efforts you can mimic it: Select (Select Count(*) from Tbl x where x.pk <= y.pk) as...
There is nothing to worry about sp_reset_connection. It is a lightweight sp used for connection pooling I suppose. If you want to find out more what...
If these two tables are linked on some key, you can simply use Insert into...Select. Insert into x(user_id) select y.empl_nmbr from Employee_info y...
Simply create Insert trigger on table 2 as Create Trigger t1 on tabl2 for insert as begin if exists(select * from table1 where doc_number in...
Check the value of rs("Amt").Type property ! "Nothing is Impossible"
Separate names with a comma.
